SQL

Topics include:

• SQL capabilities, usage, and programming with embedded SQL, dynamic SQL and SQL APIs
  
• Detailed discussion of the SQL standards, history, market trends and the future of SQL
  
• Chapters on stored procedures, data warehousing, networking and distributed databases
  
• Feature comparisons of all the leading brands of SQL DBMS
  
• Appendixes containing vendor profiles, and SQL syntax and API references

What's more, the Bonus CD that accompanies the book includes full-function
Windows 95/NT versions of all five of the leading brands of SQL-based
DBMS:

• Microsoft SQL Server 7
  
• Oracle8
  
• Informix
  
• Sybase
  
• IBM DB2

These are not incomplete "demo" versions of the DBMS products. Rather,
they are full-capability evaluation versions of the latest software from
the five leading database vendors, software that would cost over $900 if
purchased separately.

Using the free software on the CD, the reader can:

• Learn basic SQL capabilities and practice their use
  
• Work through the examples in the book using a live SQL DBMS
  
• Try out advanced features of each DBMS, such as stored procedures
  
• Build a prototype of their own database
  
• Test and compare the capabilities of each product
  
• Understand the real-world differences between different SQL
  implementations
  
• Find a SQL DBMS that best suits their specific needs

SQL: The Complete Reference - the most comprehensive book on SQL with the
most comprehensive collection of valuable SQL DBMS software from the
leading DBMS vendors.

Table of contents

Overview of SQL
Introduction - Update on New Market Developments
A Quick Tour of SQL
SQL in Perspective - JDBC, Data Warehousing, Objects, SQL3
Relational Databases
Retrieving Data
SQL Basics - SQL 2/SQL 3, Database Comparisons
Simple Queries
Multi-Table Queries
Summary Queries
Subqueries
Updating Data
Database Updates - SQL2/SQL3
Data Integrity - Expanded Treatment of Triggers
Transaction Processing
Database Structure
Creating a Database - Treatment of Network/Distributed Databases
Views
SQL Security
The System Catalog - SQL2/SQL3/ODBC Material
Object Extensions - OODB, Object/Relational, BLOBs
SQL and Networking - Distributed, Performance, Internet Issues
Programming with SQL
Embedded SQL
Dynamic SQL
SQL APIs - Expansion on ODBC, JDBC
Future Directions
Distributed Database Management
The Future of SQL