Everyday Computing Advanced Computing The Internet At Home Health, Mind & Body Making & Managing Money Sports & Leisure Travel Beyond The Classroom
Certification
Databases
Networking
Programming
Moms, Dads, and Grads -- Win $500!
SQL For Dummies, 6th Edition

SQL For Dummies, 6th Edition


By Allen G. Taylor

ISBN: 978-0-470-04652-4
Format: Paper
Pages: 432 Pages
Pub. Date: August 2006

E-mail a Friend About This Book
Price: $24.99
Description
Author Information
Table of Contents
Read Excerpt: Chapter (PDF)
Read Excerpt: Table of Contents (PDF)
Read Excerpt: Index (PDF)
Introduction.

Part I: Basic Concepts.

Chapter 1: Relational Database Fundamentals.

Chapter 2: SQL Fundamentals.

Chapter 3: The Components of SQL.

Part II: Using SQL to Build Databases.

Chapter 4: Building and Maintaining a Simple Database Structure.

Chapter 5: Building a Multitable Relational Database.

Part III: Storing and Retrieving Data.

Chapter 6: Manipulating Database Data.

Chapter 7: Specifying Values.

Chapter 8: Using Advanced SQL Value Expressions.

Chapter 9: Zeroing In on the Data You Want.

Chapter 10: Using Relational Operators.

Chapter 11: Delving Deep with Nested Queries.

Chapter 12: Recursive Queries.

Part IV: Controlling Operations.

Chapter 13: Providing Database Security.

Chapter 14: Protecting Data.

Chapter 15: Using SQL within Applications.

Part V: Taking SQL to the Real World.

Chapter 16: Accessing Data with ODBC and JDBC.

Chapter 17: Operating on XML Data with SQL.

Part VI: Advanced Topics.

Chapter 18: Stepping through a Dataset with Cursors.

Chapter 19: Adding Procedural Capabilities with Persistent Stored Modules.

Chapter 20: Handling Errors.

Part VII: The Part of Tens.

Chapter 21: Ten Common Mistakes.

Chapter 22: Ten Retrieval Tips.

Part VIII: Appendixes.

Appendix A: SQL:2003 Reserved Words.

Appendix B: Glossary.

Index.

Related Articles
Knowing Just Enough about Relational Databases
Setting Up an Oracle Environment
Working with Code after Installing an Oracle PL/SQL Database
The Scoop on SQL and PL/SQL
Setting Up Your Computer for PHP and MySQL Web Site Development
Related Titles
PHP & MySQL For Dummies, 3rd Edition
SQL All-in-One Desk Reference For Dummies
Microsoft SQL Server 2005 Programming For Dummies
MicrosoftSQL Server 7 For Dummies
Microsoft SQL Server 2000 For Dummies