Part I: SQL Basic Concepts and Principles
Chapter 1: SQL and Relational Database Management Systems (RDBMS)
Selecting Your Database Software
Everything in Details: DBMS Implementations
Object Database and Object-Relational Database Models
Brief History of SQL and SQL Standards
Chapter 2: Fundamental SQL Concepts and Principles
Once Upon a Time: Date and Time Data Types
Object and User-Defined Data Types
Part II: Creating and Modifying Database Objects
Chapter 4: Creating RDBMS Objects
Other SQL99 and Implementation-Specific Objects
CREATE Statement Cross-Reference
Chapter 5: Altering and Destroying RDBMS Objects
Other Implementation-Specific Objects
ALTER and DROP Statements Cross-Reference
Part III: Data Manipulation and Transaction Control
Chapter 6: Data Manipulation Language (DML)
INSERT: Populating Tables with Data
DELETE: Removing Data from Table
Other SQL Statements to Manipulate Data
Chapter 7: Sessions, Transactions, and Locks
Part IV: Retrieving and Transforming Data
Chapter 8: Understanding SELECT Statement
Single Table SELECT Statement Syntax
SELECT Clause: What Do We Select?
FROM Clause: Select from What?
WHERE Clause: Setting Horizontal Limits
GROUP BY and HAVING Clauses: Summarizing Results
ORDER BY Clause: Sorting Query Output
Combining the Results of Multiple Queries
Outer Joins: Joining Tables on Columns Containing NULL Values
Multitable Joins with Correlated Queries
Improving Efficiency of Multitable Queries
Part V: Implementing Security Using System Catalogs
Chapter 12: SQL and RDBMS Security
Managing Security with Privileges
Using Constraints for Security
Using Stored Procedures and Triggers for Security
Chapter 13: The System Catalog and INFORMATION_SCHEMA
IBM DB2 UDB 8.1 System Catalogs
Microsoft SQL Server 2000 System Catalog
Part VI: Beyond SQL--Procedural Programming and Database Access Mechanisms
Chapter 14: Stored Procedures, Triggers, and User-Defined Functions
Procedural Extension Uses and Benefits
Key Elements of a SQL Procedural Language
Chapter 15: Dynamic and Embedded SQL Overview
SQL Statement Processing Steps
Microsoft Open Database Connectivity (ODBC)
Java Database Connectivity (JDBC)
IBM DB2 UDB Call-Level Interface (CLI)
Microsoft Data Access Interfaces
Chapter 17: New Developments--XML, OLAP, and Objects
OLAP and Business Intelligence
Appendix A: What's on the CD-ROM
Appendix B: The ACME Sample Database
General Information and Business Rules
Column Constraints and Defaults
SQL Scripts to Create ACME Database Objects
Appendix C: Basics of Relational Database Design
Identifying Entities and Attributes
Pitfalls of Relational Database Design
Appendix D: Installing RDBMS Software
Installing IBM DB2 UDB 8.1 Personal Edition
Installing Microsoft SQL Server 2000
Using IBM DB2 UDB 8.1 Command-Line Processor (CLP)
Using Microsoft SQL Server Utilities to Access Database
Appendix F: Installing the ACME Database
Installing the ACME Database on Oracle 9i (Unix/Linux) Using SQL*Plus
Installing the ACME Database on DB2 UDB 8.1 (Windows) Using CLP
Installing ACME Database on Microsoft SQL Server 2000 Using OSQL Utility
Appendix H: SQL Syntax Reference
Transactional Control Statements
Appendix I: SQL-Reserved Keywords
Appendix J: SQL99 Major Features Compliance Across Different RDBMS
Appendix L: A Brief Introduction to the Number Systems, Boolean Algebra, and Set Theory
Logic Elements of Boolean Algebra