McGraw Hill - SQL - The Complete Reference.pdf

SQL: plete 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 ments
Back Cover


Synopsis by Dean Andrews
What is SQL and where did e 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:
plete Reference. Much more than just a listing of mands
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 - plete 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
- 2 -
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 - working and Distributed Databases - 546
Chapter 23 - SQL and Objects - 57