Apress, 2003. — 400 p.
The book covers the latest version of the SQL standard, SQL-99, and includes two complete case studies, showing how to create and query the underlying database for a fully featured web site, and how to implement role-based security in your applications.
Understanding SQL and Relational Databases
Retrieving Data with SQL
Modifying Data
Summarizing and Grouping Data
Performing Calculations and using Functions
Combining SQL Queries
Querying Multiple Tables
Hiding Complex SQL with Views
Using Stored Procedures
Transactions
Users and Security
Working with Database Objects
Triggers
Case Study: Building a Product Catalog
Case Study: Implementing Role-Based Security
Appendix A - Executing SQL Statements
Appendix B - Setting up the InstantUniversity Database
Appendix C - Data Types