This is a pretty good book for a beginner, someone who's seeing SQL (or any other database-related language) for the first time. It's good, but a bit to simplistic for anyone who's actively worked with databases. Good starting point, though.
Author(s): Jan L. Harrington
Series: The Morgan Kaufmann Series in Data Management Systems
Edition: 3
Publisher: Morgan Kaufmann
Year: 2010
Language: English
Pages: 447
Cover Page
......Page 1
Title Page
......Page 2
Copyright......Page 4
Preface to the Third
Edition......Page 5
The Relational Data
Model......Page 10
Relational Algebra......Page 35
Introduction to SQL......Page 70
Simple SQL
Retrieval......Page 80
Retrieving Data
from More Than
One Table......Page 109
Advanced Retrieval
Operations......Page 133
Working with Groups
of Rows......Page 162
Data Modification......Page 198
Schemas and Tables......Page 210
Views, Temporary
Tables, CTEs, and
Indexes......Page 236
Keeping the Design
Up to Date......Page 253
Users and Access
Rights......Page 260
Users, Sessions,
and Transaction
Control......Page 269
Writing and
Executing SQL
Routines and
Modules—Triggers
and Stored
Procedures......Page 280
Embedded SQL......Page 294
Dynamic SQL......Page 316
XML Support......Page 329
The Object-
Relational Data
Model......Page 352
Object-Relational
Support......Page 389
Common Acronyms
and Abbreviations......Page 405
SQLSTATE Return
Codes......Page 407
SQL Syntax
Summary......Page 418
Glossary......Page 430
Index......Page 440
