Author: Ryan Stephens,Ron Plew,Arie D. Jones

Publisher: Pearson Education

ISBN: 9780132603911

Category: Computers

Page: 504

View: 1807

In just 24 sessions of one hour or less, you’ll learn how to use SQL to build effective databases, efficiently retrieve your data, and manage everything from performance to security! Using this book’s straightforward, step-by-step approach, you’ll learn hands-on through practical examples. Each lesson builds on what you’ve already learned, giving you a strong real-world foundation for success. The authors guide you from the absolute basics to advanced techniques—including views, transactions, Web data publishing, and even powerful SQL extensions for Oracle and Microsoft SQL Server! Step-by-step instructions carefully walk you through the most common SQL tasks. Quizzes and Exercises at the end of each chapter help you test your knowledge. By the Way notes present interesting information related to the discussion. Did You Know? tips offer advice or show you easier ways to perform tasks. Watch Out! cautions alert you to possible problems and give you advice on how to avoid them. Learn how to… Understand what SQL is, how it works, and what it does Define efficient database structures and objects “Normalize” raw databases into logically organized tables Edit relational data and tables with DML Manage database transactions Write effective, well-performing queries Categorize, summarize, sort, group, and restructure data Work with dates and times Join tables in queries, use subqueries, and combine multiple queries Master powerful query optimization techniques Administer databases and manage users Implement effective database security Use views, synonyms, and the system catalog Extend SQL to the enterprise and Internet Master important Oracle and Microsoft SQL Server extensions to ANSI SQL
Read More

Author: Ryan Stephens,Ron Plew,Arie D. Jones

Publisher: Sams Publishing

ISBN: 9780132715126

Category: Computers

Page: 504

View: 9075

In just 24 lessons of one hour or less, you will learn professional techniques to design and build efficient databases and query them to extract useful information. Using a straightforward, step-by-step approach, each lesson builds on the previous one, allowing you to learn the essentials of ANSI SQL from the ground up. Example code demonstrates the authors’ professional techniques, while exercises written for MySQL offer the reader hands-on learning with an open-source database. Included are advanced techniques for using views, managing transactions, database administration, and extending SQL. Step-by-step instructions carefully walk you through the most common SQL tasks. Q&As, Quizzes, and Exercises at the end of each chapter help you test your knowledge. Notes and Tips point out shortcuts and solutions. New terms are clearly defined and explained. Learn how to… Use SQL-2003, the latest standard for the Structured Query Language Design and deploy efficient, secure databases Build advanced queries for information retrieval Sort, group, and summarize information for best presentation Tune databases and queries for maximum performance Understand database administration and security techniques For more than ten years the authors have studied, applied, and documented the SQL standard and its application to critical database systems. Ryan Stephens and Ron Plew are entrepreneurs, speakers, and cofounders of Perpetual Technologies, Inc. (PTI), a fast-growing IT management and consulting firm which specializes in database technologies. They taught database courses for Indiana University–Purdue University in Indianapolis for five years and have authored more than a dozen books on Oracle, SQL, database design, and the high availability of critical systems. Arie D. Jones is Senior SQL Server database administrator and analyst for PTI. He is a regular speaker at technical events and has authored several books and articles. Category: Database Covers: ANSI SQL User Level: Beginning–Intermediate Register your book at informit.com/title/9780672330186 for convenient access to updates and corrections as they become available.
Read More

Author: Ryan K. Stephens,Ronald R. Plew,Arie Jones

Publisher: Sams Publishing

ISBN: 9780672335419

Category: Computers

Page: 473

View: 6326

Explains how to use SQL to manage users and security; summarize, sort, and restructure data; and interact with relational database management systems.
Read More

Author: Ryan Stephens,Ron Plew,Arie D. Jones

Publisher: Sams Publishing

ISBN: 9780768690392

Category: Computers

Page: 840

View: 3392

The Fifth Edition of Sams Teach Yourself SQL in 21 Days More than 48,000 sold! In just one hour a day, you’ll have all the skills you need to begin creating effective SQL queries, reports, and database applications. With this complete tutorial, you’ll quickly master the basics and then move on to more advanced features and concepts: Quickly apply essential SQL techniques in useful, real-world queries Design trustworthy, high-performance databases Manipulate your data with views and transactions Leverage powerful features including stored procedures, triggers, and cursors Work with new objects introduced with the latest SQL standards Get practical, expert tips on implementing SQL in your business environment Learn on your own time, at your own pace No previous SQL or database experience required Learn techniques that work with any current version of SQL Discover how to write faster, more efficient queries Secure your data using best practices from experienced database administrators Build more powerful databases with features exclusive to Oracle SQL*Plus, Oracle PL/SQL, and Microsoft Transact-SQL Write queries for the free, open source MySQL database Embed your SQL code in other applications
Read More

Author: Jesse Liberty,Rogers Cadenhead

Publisher: Pearson Education

ISBN: 9780672331824

Category: Computers

Page: 528

View: 4801

Starter Kit Includes C++ compiler and IDE for Windows, Mac & Linux In just 24 lessons of one hour or less, you can learn the basics of programming with C++–one of the most popular and powerful programming languages ever created. Using a straightforward, step-by-step approach, this fast and friendly tutorial teaches you everything you need to know, from installing and using a compiler, to debugging the programs you’ve created, to what’s coming in C++0x, the next version of C++. Each lesson builds on what you’ve already learned, giving you a solid understanding of the basics of C++ programming concepts and techniques. Step-by-step instructions carefully walk you through the most common C++ programming tasks Quizzes and Exercises at the end of each chapter help you test yourself to make sure you’re ready to go on Starter Kit software provides everything you need to create and compile C++ programs on any platform–Windows, Mac or Linux Learn how to… Install and use a C++ compiler for Windows, Mac OS X or Linux Build object-oriented programs in C++ Master core C++ concepts such as functions, classes, arrays, and pointers Add rich functionality with linked lists and templates Debug your programs for flawless code Learn exception and error-handling techniques Discover what’s new in C++0x, the next version of C++ Jesse Liberty is the author of numerous books on software development, including best selling titles on C++ and .NET. He is the president of Liberty Associates, Inc. where he provides custom programming, consulting, and training. Rogers Cadenhead is a web application developer who has written many books on Internet-related topics, including Teach Yourself Java in 24 Hours. He maintains this book’s official website at http://cplusplus.cadenhead.org. CD-ROM Includes C++ compiler Visual development environment for Windows, Mac and Linux Source code for the book’s examples Register your book at informit.com/register for convenient access to updates and corrections as they become available.
Read More

Author: Julie C. Meloni

Publisher: Sams Publishing

ISBN: 0134439589

Category: Computers

Page: 704

View: 2614

In just a short time, you can learn how to use PHP, MySQL, and JavaScript together to create dynamic, interactive websites and applications using three leading web development technologies. No previous programming experience is required. Using a straightforward, step-by-step approach, each lesson in this book builds on the previous ones, enabling you to learn the essentials of full-stack web application development – from HTML, CSS, and JavaScript on the front end, to PHP scripting and MySQL databases on the server. Regardless of whether you run Linux, Windows, or MacOS, the book includes complete instructions to install all the software you need to set up a stable environment for learning, testing, and production. Step-by-step instructions carefully walk you through the most common web application development tasks. Practical, hands-on examples show you how to apply what you learn. Quizzes and exercises help you test your knowledge and stretch your skills. Learn how to: • Build web pages with HTML5 and CSS • Use JavaScript to build dynamic, interactive web pages • Get PHP, MySQL, and JavaScript to work together to create modern, standards-compliant web applications • Enhance interactivity with AJAX • Leverage JavaScript libraries such as jQuery • Work with cookies and user sessions • Get user input with web-based forms • Use basic SQL commands • Interact with the MySQL database using PHP • Write maintainable code and get started with version control • Decide when frameworks such as Bootstrap, Foundation, React, Angular, and Laravel can be useful • Create a web-based discussion forum or calendar • Add a storefront and shopping cart to your site Contents at a Glance PART I Web Application Basics 1 Understanding How the Web Works 2 Structuring HTML and Using Cascading Style Sheets 3 Understanding the CSS Box Model and Positioning 4 Introducing JavaScript 5 Introducing PHP PART II Getting Started with Dynamic Web Sites 6 Understanding Dynamic Web Sites and HTML5 Applications 7 JavaScript Fundamentals: Variables, Strings, and Arrays 8 JavaScript Fundamentals: Functions, Objects, and Flow Control 9 Understanding JavaScript Event Handling 10 The Basics of Using jQuery PART III Taking Your Web Applications to the Next Level 11 AJAX: Getting Started with Remote Scripting 12 PHP Fundamentals: Variables, Strings, and Arrays 13 PHP Fundamentals: Functions, Objects, and Flow Control 14 Working with Cookies and User Sessions 15 Working with Web-Based Forms PART IV Integrating a Database into Your Applications 16 Understanding the Database Design Process 17 Learning Basic SQL Commands 18 Interacting with MySQL Using PHP PART V Getting Started with Application Development 19 Creating a Simple Discussion Forum 20 Creating an Online Storefront 21 Creating a Simple Calendar 22 Managing Web Applications PART VI Appendixes A Installation QuickStart with XAMPP B Installing and Configuring MySQL C Installing and Configuring Apache D Installing and Configuring PHP
Read More

Author: Julie C. Meloni

Publisher: Sams Publishing

ISBN: 0672335433

Category: Computers

Page: 653

View: 3164

Explains how to create Web sites using the PHP scripting language, the MySQL database system, and the Apache Web server on a Windows, Linux, or Mac system.
Read More

Author: Rogers Cadenhead

Publisher: Sams Publishing

ISBN: 0132841711

Category: Computers

Page: 432

View: 7258

Sams Teach Yourself Java in 24 Hours, Sixth Edition Covering Java 7 and Android Development In just 24 lessons of one hour or less, you can learn how to create Java applications. Using a straightforward, step-by-step approach, popular author Rogers Cadenhead helps you master the skills and technology you need to create desktop and web programs, web services, and even an Android app in Java. Full-color figures and clear step-by-step instructions visually show you how to program with Java. Quizzes and Exercises at the end of each chapter help you test your knowledge. Notes, Tips, and Cautions provide related information, advice, and warnings. Learn how to… Set up your Java programming environment Write your first working program in just minutes Control program decisions and behavior Store and work with information Build straightforward user interfaces Create interactive web programs Use threading to build more responsive programs Read and write files and XML data Master best practices for object-oriented programming Create flexible, interoperable web services with JAX-WS Use Java to create an Android app PART I: Getting Started HOUR 1: Becoming a Programmer HOUR 2: Writing Your First Program HOUR 3: Vacationing in Java HOUR 4: Understanding How Java Programs Work PART II: Learning the Basics of Programming HOUR 5: Storing and Changing Information in a Program HOUR 6: Using Strings to Communicate HOUR 7: Using Conditional Tests to Make Decisions HOUR 8: Repeating an Action with Loops PART III: Working with Information in New Ways HOUR 9: Storing Information with Arrays HOUR 10: Creating Your First Object HOUR 11: Describing What Your Object Is Like HOUR 12: Making the Most of Existing Objects PART IV: Programming a Graphical User Interface HOUR 13: Building a Simple User Interface HOUR 14: Laying Out a User Interface HOUR 15: Responding to User Input HOUR 16: Building a Complex User Interface PART V: Moving into Advanced Topics HOUR 17: Creating Interactive Web Programs HOUR 18: Handling Errors in a Program HOUR 19: Creating a Threaded Program HOUR 20: Reading and Writing Files PART VI: Writing Internet Applications HOUR 21: Reading and Writing XML Data HOUR 22: Creating Web Services with JAX-WS HOUR 23: Creating Java2D Graphics HOUR 24: Writing Android Apps PART VII: Appendixes APPENDIX A: Using the NetBeans Integrated Development Environment APPENDIX B: Where to Go from Here: Java Resources APPENDIX C: This Book’s Website APPENDIX D: Setting Up an Android Development Environment
Read More

Author: Katie Cunningham

Publisher: Sams Publishing

ISBN: 0133354466

Category: Computers

Page: 320

View: 9315

In just 24 sessions of one hour or less, Sams Teach Yourself Python in 24 Hours will help you get started fast, master all the core concepts of programming, and build anything from websites to games. Using this book’s straightforward, step-by-step approach, you’ll move from the absolute basics through functions, objects, classes, modules, database integration, and more. Every lesson and case study application builds on what you’ve already learned, giving you a rock-solid foundation for real-world success! Step-by-step instructions carefully walk you through the most common Python development tasks. Quizzes and Exercises at the end of each chapter help you test your knowledge. Notes present interesting information related to the discussion. Tips offer advice or show you easier ways to perform tasks. Warnings alert you to possible problems and give you advice on how to avoid them. Learn how to… Install and run the right version of Python for your operating system Store, manipulate, reformat, combine, and organize information Create logic to control how programs run and what they do Interact with users or other programs, wherever they are Save time and improve reliability by creating reusable functions Master Python data types: numbers, text, lists, and dictionaries Write object-oriented programs that work better and are easier to improve Expand Python classes to make them even more powerful Use third-party modules to perform complex tasks without writing new code Split programs to make them more maintainable and reusable Clearly document your code so others can work with it Store data in SQLite databases, write queries, and share data via JSON Simplify Python web development with the Flask framework Quickly program Python games with PyGame Avoid, troubleshoot, and fix problems with your code
Read More

Author: Ben Forta

Publisher: Pearson Education

ISBN: 0672336073

Category: Computers

Page: 274

View: 6684

Explains how to use Structured Query Language to work within a relational database system, including information retrieval, security, data manipulation, and user management.
Read More

Author: Phil Ballard,Michael Moncur

Publisher: Sams Publishing

ISBN: 0133048314

Category: Computers

Page: 448

View: 3713

Learn JavaScript in 24 Hours Covers JavaScript 1.8+, Ajax and jQuery In just 24 lessons of one hour or less, you can learn how to create dynamic, interactive Web pages with the popular and ubiquitous JavaScript web programming language. Using a straightforward, step-by-step approach, each lesson in this book clearly and carefully walks you through basic concepts and techniques, and helps you learn the essentials of JavaScript programming from the ground up. Learn how to… Use JavaScript to build dynamic, interactive Web pages Debug scripts Create scripts that work in all browsers Work with HTML5 and CSS3 Leverage the popular jQuery library Control CSS with simple JavaScripts Add Ajax effects to your web pages Script animations and music Step-by-step instructions carefully walk you through the most common JavaScript programming tasks Quizzes at end of every chapter help you build and test your knowledge Interactive online exercises let you practice what you learn at the Codecademy web site with no downloads or installation needed Sams Publishing has teamed up with Codecademy — the online place where anyone can learn and teach coding — to provide readers of Sams Teach Yoruself JavaScript in 24 Hours with an exclusive area on the Codecademy web site where you can supplement what you've learned in this book with some fun, fully interactive exercises and projects. After reading a lesson in the book you can roll up your sleeves and get some hands-on coding experience at codecademy.com/tracks/teachyourself
Read More

Author: B. J. Miller

Publisher: Pearson Education

ISBN: 067233724X

Category: Computers

Page: 423

View: 6682

Offers twenty-four lessons teaching how to build next-generation OS X and iOS apps using Apple's new programming language, with step-by-step instructions for such common tasks as using operators, iterating code with loops, and introducing generics.
Read More

From Novice to Professional

Author: Iggy Fernandez

Publisher: Apress

ISBN: 1590599683

Category: Computers

Page: 464

View: 9392

This book, written by veteran Oracle database administrator Iggy Fernandez, a regular on the Oracle conference circuit and the editor of NoCOUG Journal, is a manageable introduction to key Oracle database administration topics including planning, installation, monitoring, troubleshooting, maintenance, and backups, to name just a few. As is clear from the table of contents, this book is not simply a recitation of Oracle Database features such as what you find in the reference guides available for free download on the Oracle web site. For example, the chapter on database monitoring explains how to monitor database availability, database changes, database security, database backups, database growth, database workload, database performance, and database capacity. The chapters of this book are logically organized into four parts that closely track the way your database administration career will naturally evolve. Part 1 gives you necessary background in relational database theory and Oracle Database concepts, Part 2 teaches you how to implement an Oracle database correctly, Part 3 exposes you to the daily routine of a database administrator, and Part 4 introduces you to the fine art of performance tuning. Each chapter has exercises designed to help you apply the lessons of the chapter. Each chapter also includes a list of reference works that contain more information on the topic of the chapter. In this book, you'll find information that you won't find in other books on Oracle Database. Here you'll discover not only technical information, but also guidance on work practices that are as vital to your success as technical skills. The author's favorite chapter is "The Big Picture and the Ten Deliverables." If you take the lessons in that chapter to heart, you can quickly become a much better Oracle database administrator than you ever thought possible. What you’ll learn Theory of relational database management systems Oracle Database internals Licensing, architecture, and sizing Software installation and database creation Using indexes to improve performance User management and data loading How to monitor all aspects of your database How to solve and fix problems Database backups and database recovery Database maintenance Database tuning SQL tuning Who this book is for If you are an IT professional who has been thrust into an Oracle database administration role without the benefit of formal training, or you just want to understand how Oracle Database works, this book is for you. It's the book the author wishes he'd had when he first started using Oracle Database many years ago. It's the book that he would have liked to have given to the many IT colleagues and friends who, over the years, have asked him to teach them the basics of Oracle Database.
Read More

Author: Darl Kuhn

Publisher: Apress

ISBN: 1430229713

Category: Computers

Page: 720

View: 6501

Pro Oracle Database 11g Administration is a book focused on results. Author Darl Kuhn draws from a well of experience over a decade deep to lay out real-world techniques that lead to success as an Oracle Database administrator. He gives clear explanations on how to perform critical tasks. He weaves in theory where necessary without bogging you down in unneeded detail. He is not afraid to take a stand on how things should be done. He won’t leave you adrift in a sea of choices, showing you three ways to do something and then walking away. Database administration isn’t about passing a certified exam, or about pointing-and-clicking your way through a crisis. Database administration is about applying the right solution at the right time, about avoiding risk, about making robust choices that get you home each night in time for dinner with your family. If you have “buck stops here” responsibility for an Oracle database, then Pro Oracle Database 11g Administration is the book you need to help elevate yourself to the level of Professional Oracle Database Administrator. Condenses and organizes the core job of a database administrator into one volume. Takes a results-oriented approach to getting things done. Lays a foundation upon which to build a senior level of expertise
Read More

Author: Michael Morrison

Publisher: Sams Publishing

ISBN: 9780672322136

Category: Computers

Page: 485

View: 7731

Sams Teach Yourself XML in 24 Hours, Second Edition focuses on teaching the reader the fundamental concepts of XML using practical, hands-on examples. Rather than dwelling on dry theory, the book is filled with clear, real-world examples of how the technology can be used today. This book includes coverage of topics such as: Displaying XML files in HTML files; Parsing HTML files into corresponding hierarchical tree structure; Embedding XML code into an HTML file; Using Extensible Style Sheets (XSL) ; Performing queries in XSL; Building an online store.
Read More

Author: Tony Butcher

Publisher: Sams Publishing

ISBN: 9780672323928

Category: Computers

Page: 608

View: 4293

This guide teaches readers how to design and implement their an open source database. Topics include designing and creating a database; normalizing data; adding tables, columns and indexes; importing and exporting data; administering, optimizing and troubleshooting My SQL; and locks and keys.
Read More

Author: Rogers Cadenhead

Publisher: Pearson Education

ISBN: 0672337029

Category: Computers

Page: 441

View: 558

Offers an updated tutorial for beginners explaining how to use Java to create desktop and Web programs, applications, and web services, including setting up the programming environment, building user interfaces, and writing Android apps.
Read More

Covers OS X, Linux, and Solaris

Author: Dave Taylor

Publisher: Sams Publishing

ISBN: 0134095421

Category: Computers

Page: 496

View: 5354

Learn to use Unix, OS X, or Linux quickly and easily! In just 24 lessons of one hour or less, Sams Teach Yourself Unix in 24 Hours helps you get up and running with Unix and Unix-based operating systems such as Mac OS X and Linux. Designed for beginners with no previous experience using Unix, this book’s straightforward, step-by-step approach makes it easy to learn. Each lesson clearly explains essential Unix tools and techniques from the ground up, helping you to become productive as quickly and efficiently as possible. Step-by-step instructions carefully walk you through the most common Unix tasks. Practical, hands-on examples show you how to apply what you learn. Quizzes and exercises help you test your knowledge and stretch your skills. Notes and tips point out shortcuts and solutions Learn how to… Pick the command shell that’s best for you Organize the Unix file system (and why) Manage file and directory ownership and permissions Maximize your productivity with power filters and pipes Use the vi and emacs editors Create your own commands and shell scripts Connect to remote systems using SSH and SFTP Troubleshoot common problems List files and manage disk usage Get started with Unix shell programming Set up printing in a Unix environment Archive and back up files Search for information and files Use Perl as an alternative Unix programming language Set up, tweak, and make use of the GNOME graphical environment Contents at a Glance HOUR 1: What Is This Unix Stuff? HOUR 2: Getting onto the System and Using the Command Line HOUR 3: Moving About the File System HOUR 4: Listing Files and Managing Disk Usage HOUR 5: Ownership and Permissions HOUR 6: Creating, Moving, Renaming, and Deleting Files and Directories HOUR 7: Looking into Files HOUR 8: Filters, Pipes, and Wildcards! HOUR 9: Slicing and Dicing Command-Pipe Data HOUR 10: An Introduction to the vi Editor HOUR 11: Advanced vi Tricks, Tools, and Techniquess HOUR 12: An Overview of the emacs Editor HOUR 13: Introduction to Command Shells HOUR 14: Advanced Shell Interaction HOUR 15: Job Control HOUR 16: Shell Programming Overview HOUR 17: Advanced Shell Programming HOUR 18: Printing in the Unix Environment HOUR 19: Archives and Backups HOUR 20: Using Email to Communicate HOUR 21: Connecting to Remote Systems Using SSH and SFTP HOUR 22: Searching for Information and Files HOUR 23: Perl Programming in Unix HOUR 24: GNOME and the GUI Environment Appendix A: Common Unix Questions and Answers
Read More

Author: Bradley L. Jones,Peter Aitken,Dean Miller

Publisher: Sams Publishing

ISBN: 0133414388

Category: Computers

Page: 696

View: 8380

Sams Teach Yourself C Programming in One Hour a Day, Seventh Edition is the newest version of the worldwide best-seller Sams Teach Yourself C in 21 Days. Fully revised for the new C11 standard and libraries, it now emphasizes platform-independent C programming using free, open-source C compilers. This edition strengthens its focus on C programming fundamentals, and adds new material on popular C-based object-oriented programming languages such as Objective-C. Filled with carefully explained code, clear syntax examples, and well-crafted exercises, this is the broadest and deepest introductory C tutorial available. It’s ideal for anyone who’s serious about truly mastering C – including thousands of developers who want to leverage its speed and performance in modern mobile and gaming apps. Friendly and accessible, it delivers step-by-step, hands-on experience that starts with simple tasks and gradually builds to professional-quality techniques. Each lesson is designed to be completed in hour or less, introducing and clearly explaining essential concepts, providing practical examples, and encouraging you to build simple programs on your own. Coverage includes: Understanding C program components and structure Mastering essential C syntax and program control Using core language features, including numeric arrays, pointers, characters, strings, structures, and variable scope Interacting with the screen, printer, and keyboard Using functions and exploring the C Function Library Working with memory and the compiler Contents at a Glance PART I: FUNDAMENTALS OF C 1 Getting Started with C 2 The Components of a C Program 3 Storing Information: Variables and Constants 4 The Pieces of a C Program: Statements, Expressions, and Operators 5 Packaging Code in Functions 6 Basic Program Control 7 Fundamentals of Reading and Writing Information PART II: PUTTING C TO WORK 8 Using Numeric Arrays 9 Understanding Pointers 10 Working with Characters and Strings 11 Implementing Structures, Unions, and TypeDefs 12 Understanding Variable Scope 13 Advanced Program Control 14 Working with the Screen, Printer, and Keyboard PART III: ADVANCED C 15 Pointers to Pointers and Arrays of Pointers 16 Pointers to Functions and Linked Lists 17 Using Disk Files 18 Manipulating Strings 19 Getting More from Functions 20 Exploring the C Function Library 21 Working with Memory 22 Advanced Compiler Use PART IV: APPENDIXES A ASCII Chart B C/C++ Reserved Words C Common C Functions D Answers
Read More