- 2 -
SQL: The Complete Reference
by James R. Groff and Paul N. Weinberg
ISBN: 0072118458
Osborne/McGraw-Hill © 1999, 994 pages
An encyclopedic reference guide to the SQL database
language for both technical and non-technical readers.
Table of Contents
Colleague Comments
Back Cover
Synopsis by Dean Andrews
What is SQL and where did it come from? How do the SQL tools vary across
database applications from different vendors? How will SQL change in the
future? You'll find the answers to all these questions and many more in SQL:
The Complete Reference. Much more than just a listing of SQL commands
and their parameters, this encyclopedic reference guide explains the concepts
and constructs of SQL programming such that non-technical readers will
understand them and technical readers won't be bored.
Table of Contents
SQL
- The Complete Reference - 4
Preface - 6
Part I An Overview of SQL
Chapter 1
- Introduction - 8
Chapter 2
- A Quick Tour of SQL - 15
Chapter 3
- SQL In Perspective - 22
Chapter 4
- Relational Databases - 38
Part II Retrieving Data
Chapter 5
- SQL Basics - 51
Chapter 6
- Simple Queries - 69
Chapter 7
- Multi-Table Queries (Joins) - 101
Chapter 8
- Summary Queries - 136
Chapter 9
- Subqueries and Query Expressions - 158
Part III Updating Data
Chapter 10 - Database Updates - 196
Chapter 11 - Data Integrity - 211
Chapter 12 - Transaction Processing - 236
Part IV Database Structure
Chapter 13 - Creating a Database - 256
Chapter 14 - Views - 290
Chapter 15 - SQL Security - 304
- 3 -
Chapter 16 - The System Catalog - 321
Part V Programming with SQL
Chapter 17 - Embedded SQL - 344
Chapter 18 - Dynamic SQL* - 387
Chapter 19 - SQL APIs - 430
Part VI SQL Today and Tomorrow
Chapter 20 - Database Processing and Stored Procedures - 435
Chapter 21 - SQL and Data Warehousing - 535
Chapter 22 - SQL Networking and Distributed Dat