SQL : the complete reference
| Main Author: | |
|---|---|
| Other Authors: | , |
| Format: | Book |
| Published: |
New York:
Osborne McGraw-Hill,
2010.
|
| Edition: | 3rd ed. |
| Subjects: |
Table of Contents:
- Introduction
- A quick tour of SQL
- SQL in perspective
- Relational databases
- SQL basics
- Simple queries
- Multitable queries (Joins)
- Summary queries
- Subqueries and query expressions
- Database updates
- Data integrity
- Transaction processing
- Creating a database
- Views
- SQL security
- The system catalog
- Embedded SQL
- Dynamic SQL*
- SQL APIs
- Database processing and stored procedural SQL
- SQL and data warehousing
- SQL and application servers
- SQL Networking and distributed databases
- SQL and objects
- SQL and XML
- Specialty databases
- The future of SQL
- The sample database
- DBMS vendor profiles
- SQL syntax reference