SQL Clearly Explained, 3rd Edition

SQL Clearly Explained, 3^rd 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

Table of Contents

Chapter 1. The Relational Data Model
Chapter 2. Relational Algebra
Chapter 3. Introduction to SQL
Chapter 4. Simple SQL Retrieval
Chapter 5. Retrieving Data from More Than One Table
Chapter 6. Advanced Retrieval Operations
Chapter 7. Working with Groups of Rows
Chapter 8. Data Modification
Chapter 9. Schemas and Tables
Chapter 10. Views, Temporary Tables, CTEs, and Indexes
Chapter 11. Keeping the Design Up to Date
Chapter 12. Users and Access Rights
Chapter 13. Users, Sessions, and Transaction Control
Chapter 14. Writing and Executing SQL Routines and Modules—Triggers and Stored Procedures
Chapter 15. Embedded SQL
Chapter 16. Dynamic SQL
Chapter 17. XML Support
Chapter 18. The Object- Relational Data Model
Chapter 19. Object-Relational Support