Ebook: SQL for dummies

Written in easy-to-understand terms and updated with the latest information on SQL, this handy reference shows you step-by-step how to make your database designs a reality using SQL:2003. 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. 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

---

Written in easy-to-understand terms and updated with the latest information on SQL, this handy reference shows you step-by-step how to make your database designs a reality using SQL:2003. 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. 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