β Scribed by Jan L. Harrington
No coin nor oath required. For personal study only.
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
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
π SIMILAR VOLUMES
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.
This book explains SQL very clearly indeed, as the title implies. I knew a bit of SQL before I started reading this book, so the first 50-odd pages didn't teach me much, but they still made me understand a few things here and there more thoroughly. I got my copy yesterday, and I'm at around page 10
Fully revised and updated, Relational Database Design, Second Edition is the most lucid and effective introduction to relational database design available. Here, you'll find the conceptual and practical information you need to develop a design that ensures data accuracy and user satisfaction while o
Data Modeling Essentials, Third Edition provides expert tutelage for data modelers, business analysts and systems designers at all levels. Beginning with the basics, this book provides a thorough grounding in theory before guiding the reader through the various stages of applied data modeling and da
This is one of those books that are perhaps nice to have IN ADDITION to something better. Btw, do NOT overestimate the "for smarties" part in the title: the book is not all that advanced: it's more like an extensive cookbook with a lot of personal opinion thrown in (not always consistent; for exampl
SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 10 years later and in the third edition, this classic still reigns supreme as the book written by an SQL master that teaches future SQL m