The relational model for database management: version 2
The relational model for database management: version 2
A relational model of data for large shared data banks
Communications of the ACM
| Hi-index | 0.00 |
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 Table of ContentsChapter 1: The relational data model Chapter 2: Manipulating relations with 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: Calculations and grouping queries Chapter 8: Data Modifications 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 manipulation Chapter 14: 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