SQL: The Complete Reference, Second Edition

by Groff, James R.

• ISBN13: 9780072225594
• ISBN10: 0072225599
• Edition: 2nd
• Format: Paperback
• Copyright: 2002-08-28
• Publisher: McGraw-Hill Osborne Media

Summary

Learn all you need to know about SQL with this one-stop resource. Updated to include information on Web services and XML, this complete guide also comes with a Windows 2000- and XP- compatible CD containing 4 databases (SQL Server 2000, IBM DB2 Version 7.2, Sybase, and mySQL).

Author Biography

James R. Groff and Paul N. Weinberg were the cofounders of Network Innovations Corporation, an early developer of SQL-based networking software that linked personal computers to corporate databases. Groff is currently CEO of TimesTen Performance Software, developer of an ultra-high-performance main-memory SQL database for communications and Internet applications. Weinberg is Vice President of A2i, Inc., developer of a database-driven, cross-media catalog publishing system that supports printed and electronic output from a single data source.

Table of Contents

Part I: An Overview of SQL

1: Introduction

2: A Quick Tour of SQL

3: SQL in Perspective

4: Relational Databases

Part II: Retrieving Data

5: SQL Basics

6: Simple Queries

7: Multitable Queries (Joins)

8: Summary Queries

9: Subqueries and Query Expressions

Part III: Updating Data

10: Database Updates

11: Data Integrity

12: Transaction Processing

Part IV: Database Structure

13: Creating a Database

14: Views

15: SQL Security

16: The System Catalog

Part V: Programming with SQL

17: Embedded SQL

18: Dynamic SQL *

19: SQL APIs

Part VI: SQL Today and Tomorrow

20: Database Processing and Stored Procedures

21: SQL and Data Warehousing

22: SQL and Application Servers

23: SQL Networking and Distributed Databases

24: SQL and Objects

25: SQL and XML

26: The Future of SQL

Part VII: Appendixes

A: The Sample Database

B: Database Vendor Profiles

C: SQL Syntax Reference

D: SQL Call-Level Interface

E: SQL Information Schema Standard

F: CD-ROM Installation Guide