SQL For Dummies, 7th EditionISBN: 978-0-470-55741-9
Paperback
456 pages
February 2010
This title is out-of-print and not currently available for purchase from this site.
|
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.
Chapter 21: Triggers.
Part VII: The Part of Tens.
Chapter 22: Ten Common Mistakes.
Chapter 23: Ten Retrieval Tips.
Appendix: SQL:2008 Reserved Words.
Index.