Joe Celko's SQL for Smarties: Advanced SQL Programming (Paperback, 5, Revised)

PART I : Data Declaration Features 1. Databases versus File Systems 2. Transactions and Concurrency Control 3. Tables 4. Keys, Exposed Physical Locators and Generated Values 5. Normalization 6. VIEWs and CTEs 7. Auxiliary Tables and Views 8. Other Schema Objects 9. DDL Flaws to Avoid

PART II : Data Types 10. Numeric Data in SQL 11. Character Data Types in SQL 12. Temporal Data Types in SQL 13. Multiple Column Data Elements 14. NULLs and 3-Valued Logic in SQL 15. Table Administration Operations 16. Set Operators

PART III Row and Column Level Features 17. Comparison or Theta Operators 18. Quantified Subquery Predicates 19. BETWEEN and OVERLAPS Predicates 20. CASE Expression Family 21. LIKE and SIMILAR TO Predicates 22. Simple One Table SELECT Statements 23. Intermediate Aggregate Functions 24. Descriptive Statistic Aggregate Functions 25. OLAP Aggregate Functions 26. JOINs

PART IV: Data Structures in SQL 27. Graphs in SQL 28. Trees and Hierarchies in SQL 29. Queues and Lists 30. Matrices in SQL

PART V: Typical Queries 31. Coverings and Partitions 32. Runs, Gaps, and Islands Rewrite or Expansion 33. Inventory and Auction Models 34. Relational Division 35. Temporal Queries and Operations

PART VI: Implementation and Coding Issues 36. Access Methods 37. Basic Optimization Principles 38. Overview of SQL/PSM