SQL, the complete reference /
Complete reference SQL
James R. Groff and Paul N. Weinberg.
- 2nd ed.
- Berkeley, Calif. : Osborne/McGraw-Hill, c2002.
- xxiv, 1050 p. : ill. ; 24 cm + 1 computer laser optical disc (4 3/4 in.)
Includes index.
1. Introduction -- 2. A Quick Tour of SQL -- 3. SQL In Perspective -- 4. Relational Databases -- 5. SQL Basics -- 6. Simple Queries -- 7. Multiple Queries (Joins) -- 8. Summary Queries -- 9. Subqueries and Query Expressions -- 10. Database Updates -- 11. Data Integrity -- 12. Transaction Processing -- 13. Creating a Database -- 14. Views -- 15. SQL Security -- 16. The System Catalog -- 17. Embedded SQL -- 18. Dynamic SQL * -- 19. SQL APIs -- 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 -- 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.