The Programmer's Guide to SQL

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.

Table of Contents
	Introduction
	Chapter 1	-	Understanding SQL and Relational Databases
	Chapter 2	-	Retrieving Data with SQL
	Chapter 3	-	Modifying Data
	Chapter 4	-	Summarizing and Grouping Data
	Chapter 5	-	Performing Calculations and using Functions
	Chapter 6	-	Combining SQL Queries
	Chapter 7	-	Querying Multiple Tables
	Chapter 8	-	Hiding Complex SQL with Views
	Chapter 9	-	Using Stored Procedures
	Chapter 10	-	Transactions
	Chapter 11	-	Users and Security
	Chapter 12	-	Working with Database Objects
	Chapter 13	-	Triggers
	Chapter 14	-	Case Study: Building a Product Catalog
	Chapter 15	-	Case Study: Implementing Role-Based Security
	Appendix A	-	Executing SQL Statements
	Appendix B	-	Setting up the InstantUniversity Database
	Appendix C	-	Data Types
	Index
	List of Figures
	List of Tables
	List of Examples
	List of Sidebars