SQL Clearly Explained / Edition 3

SQL Clearly Explained / Edition 3

by Jan L. Harrington
     
 

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

… See more details below

Overview

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.

Product Details

ISBN-13:
9780123756978
Publisher:
Elsevier Science
Publication date:
05/07/2010
Series:
Morgan Kaufmann Series in Data Management Systems Series
Pages:
480
Sales rank:
1,338,728
Product dimensions:
7.50(w) x 9.20(h) x 1.20(d)

Table of Contents

Preface
Ch. 1Introduction1
Ch. 2Simple SQL Retrieval17
Ch. 3Retrieving Data from More Than One Table: Joins47
Ch. 4Advanced Retrieval Operations81
Ch. 5Calculations and Grouping Queries97
Ch. 6Data Modification125
Ch. 7Managing Database Structure: Part I133
Ch. 8Managing Database Structure: Part II155
Ch. 9Users, Sessions, and Transaction Control177
Ch. 10Embedded SQL191
Ch. 11Dynamic SQL209
App. AUnimplemented SQL-92 Features223
App. BThe Online Bookstore Database237
App. CSQLSTATE Return Codes245
App. DSQL Syntax Summary251
Glossary261
Index271

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >