SQL For Dummies

* SQL is the international standard database language used to create, access, manipulate, maintain, and store information in a relational database management system (DBMS)-a vital tool for database programmers and Web developers
* The new SQL standard due for release in summer 2003 is the first updated standard in over three years; it mandates the expansion of SQL beyond its relational roots to handle images, sound files, and other nonrelational data types and will produce a great need for updated information
* The fifth edition of this popular reference guide is completely revised to cover these enhancements, including how to handle data stored in XML files and on the Web, expanded coverage of image and sound files, and some hot new trends like OLE DB
* Uses the friendly, easy-to-understand For Dummies style to show programmers and Web developers how to build relational databases, retrieve information from them, implement a database design, secure a database, and perform other essential functions with SQL
* Author has written twenty computer books, many relating to databases and database management

Table of Contents

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: Retrieving Data.

Chapter 6: Manipulating Database Data.

Chapter 7: Specifying Values.

Chapter 8: Advanced SQL Value Expressions.

Chapter 9: Zeroing In on the Data You Want.

Chapter 10: Relational Operators.

Chapter 11: Delving Deep with Nested Queries.

Chapter 12: Recursive Queries.

Chapter 13: Providing Database Security.

Part IV: Controlling Operations.

Chapter 14: Protecting Data.

Chapter 15: Using SQL Within Applications.

Part V: SQL in the Real World.

Chapter 16: ODBC and JDBC.

Chapter 17: SQL:2003 and XML.

Part VI: Advanced Topics.

Chapter 18: Cursors.

Chapter 19: Persistent Stored Modules.

Chapter 20: Error-Handling.

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.