Acknowledgments.

PART I: SQL Basic Concepts and Principles.

Chapter 1: SQL and Relational Database Management Systems (RDBMS).

Chapter 2: Fundamental SQL Concepts and Principles.

Chapter 3: SQL Data Types.

PART II: Creating and Modifying Database Objects.

Chapter 4: Creating RDBMS Objects.

Chapter 5: Altering and Destroying RDBMS Objects.

PART III: Data Manipulation and Transaction Control.

Chapter 6: Data Manipulation Language (DML).

Chapter 7: Sessions, Transactions, and Locks.

PART IV: Retrieving and Transforming Data.

Chapter 8: Understanding SELECT Statement.

Chapter 9: Multitable Queries.

Chapter 10: SQL Functions.

Chapter 11: SQL Operators.

PART V: Implementing Security Using System Catalogs.

Chapter 12: SQL and RDBMS Security.

Chapter 13: The System Catalog and INFORMATION_SCHEMA.

PART VI: Beyond SQL: Procedural Programming and Database Access Mechanisms.

Chapter 14: Stored Procedures, Triggers, and User-Defined Functions.

Chapter 15: Dynamic and Embedded SQL Overview.

Chapter 16: SQL API.

Chapter 17: New Developments: XML, OLAP, and Objects.

Appendix A: What’s on the CD-ROM.

Appendix B: The ACME Sample Database.

Appendix C: Basics of Relational Database Design.

Appendix D: Installing RDBMS Software.

Appendix E: Accessing RDBMS.

Appendix F: Installing the ACME Database.

Appendix G: SQL Functions.

Appendix H: SQL Syntax Reference.

Appendix I: SQL-Reserved Keywords.

Appendix J: SQL99 Major Features Compliance Across Different RDBMS.

Appendix K: The Other RDBMS.

Appendix L: A Brief Introduction to the Number Systems, Boolean Algebra, and Set Theory.

Index.

End-User License Agreement.