SQL Clearly Explained, 3rd Edition details the release of the SQL standard (SQL:2008), including two sets of extensions to support object-relational databases and XML. NEW chapters include coverage of the relational data model, relational algebra, SQL object-relational support, triggers and stored procedures, as well as XML. This expanded edition is packed with tips, tricks and other vital information for working with SQL. Demonstrates how to formulate SQL queries and how queries are processed to maximize performance of the database management system Explains use of SQL to enter, modify or delete data to maintain database structural elements Covers in great detail new SQL application for XML to meet the growing XML usage in development of online content
Author(s): Jan L. Harrington
Edition: 3
Year: 2010
Language: English
Pages: 480
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
