4th edition. — John Wiley & Sons, 2001. — 431 p. — ISBN: 0-7645-0737-0.
Discover How To:
Understand SQL and relational database basics;
Build a multitable database;
Retrieve data from a database;
Use SQL in Internet and enterprise applications;
Capitalize on new SQL:1999 features.
Basic Concepts.Relational Database Fundamentals.
SQL Fundamentals.
The Components of SQL.
Using SQL to Build Databases.Building and Maintaining a Simple Database Structure.
Building a Multitable Relational Database.
Storing and Retrieving Data.Manipulating Database Data.
Specifying Values.
Advanced SQL Value Expressions.
Zeroing in on the Data You Want.
Relational Operators.
Delving Deep with Nested Queries.
Recursive Queries.
Providing Database Security.
Controlling Operations.Using SQL within Applications.
SQL in the Real World.ODBC and JDBC.
SQL on the Internet.
Database on the Organizational Intranet
Triggers.
Advanced Topics.Cursors.
Persistent Stored Modules.
Error-Handling.
Dynamic SQL.
Major New Features Added to SQL by the SQL:1999 Specification.
The Part of Tens.Ten Common Mistakes.
Ten Retrieval Tips.
Appendix A: SQL: 1999 Reserved Words.
Appendix B: Glossary.