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
