Shows how to build and use relational databases with SQL. This book helps you to: discover how to Use SQL in a client/server system; build a multitable relational database; construct nested and recursive queries; set up database security; use SQL within applications; and, map SQL to XML.

See how SQL interfaces with today's environments. Start building and using relational databases with SQL's newest features. The database may be the twenty-first century filing cabinet, but building one is a little more complex than sliding drawers into a metal box. With this book to guide you through all the newest features of SQL, you'll soon be whipping up relational databases, using SQL with XML to power data-driven Web sites, and more! This book helps you to: discover how to Use SQL in a client/server system; build a multitable relational database; construct nested and recursive queries; set up database security; use SQL within applications; and, map SQL to XML.

Book 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: 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.