SQL Clearly Explained (Third Edition)

✍ Scribed by Jan L. Harrington

• Publisher: Morgan Kaufmann
• Year: 2010
• Tongue: English
• Leaves: 447
• Category: Library

✦ Synopsis

A lucid guide to SQL which provides the tools to put practical instruction to work immediately!SQL Clearly Explained is one of those rare books that delivers 100 percent what its title promises. If you need to use SQL on the job, and who doesnt, then this book should be on your desk.This book functions as a very good tutorial, taking you from the basics through expert topics in a very straightforward manner.

✦ Table of Contents

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