McGraw-Hill SQL The Complete Reference, 3rd Edition

SQL The Complete Reference, 3rd Edition Part I: An Overview of SQL

Chapter 1. Introduction

Chapter 2. A Quick Tour of SQL

Chapter 3. SQL in Perspective

Chapter 4. Relational Databases

Part II: Retrieving Data

Chapter 5. SQL Basics

Chapter 6. Simple Queries

Chapter 7. Multitable Queries (Joins)

Chapter 8. Summary Queries

Chapter 9. Subqueries and Query Expressions

Part III: Updating Data

Chapter 10. Database Updates

Chapter 11. Data Integrity

Chapter 12. Transaction Processing

Part IV: Database Structure

Chapter 13. Creating a Database

Chapter 14. Views

Chapter 15. SQL Security

Chapter 16. The System Catalog

Part V: Programming with SQL

Chapter 17. Embedded SQL

Chapter 18. Dynamic SQL

Chapter 19. SQL APIs

Part VI: SQL Today and Tomorrow

Chapter 20. Database Processing and Stored Procedural SQL

Chapter 21. SQL and Data Warehousing

Chapter 22. SQL and Application Servers

Chapter 23. SQL Networking and Distributed Databases

Chapter 24. SQL and Objects

Chapter 25. SQL and XML

Chapter 26. Specialty Databases

Chapter 27. The Future of SQL

Part VII: Appendixes

Appendix A. The Sample Database

Appendix B. DBMS Vendor Profiles

Appendix C. SQL Syntax Reference

Index