Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards. Mr. Celko is author a series of books on SQL and RDBMS for Elsevier/MKP. He is an independent consultant based in Austin, Texas. He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.
PART I : Data Declaration Features1. Databases versus File Systems2.
Transactions and Concurrency Control3. Tables4. Keys, Exposed Physical
Locators and Generated Values5. Normalization6. VIEWs and CTEs7. Auxiliary
Tables and Views8. Other Schema Objects9. DDL Flaws to Avoid
PART II : Data Types10. Numeric Data in SQL11. Character Data Types in
SQL12. Temporal Data Types in SQL13. Multiple Column Data Elements14. NULLs
and 3-Valued Logic in SQL15. Table Administration Operations16. Set
Operators
PART III Row and Column Level Features17. Comparison or Theta Operators18.
Quantified Subquery Predicates19. BETWEEN and OVERLAPS Predicates20. CASE
Expression Family21. LIKE and SIMILAR TO Predicates22. Simple One Table
SELECT Statements23. Intermediate Aggregate Functions24. Descriptive
Statistic Aggregate Functions25. OLAP Aggregate Functions26. JOINs
PART IV: Data Structures in SQL27. Graphs in SQL28. Trees and Hierarchies
in SQL29. Queues and Lists30. Matrices in SQL
PART V: Typical Queries31. Coverings and Partitions32. Runs, Gaps, and
Islands Rewrite or Expansion33. Inventory and Auction Models34. Relational
Division35. Temporal Queries and Operations
PART VI: Implementation and Coding Issues36. Access Methods37. Basic
Optimization Principles38. Overview of SQL/PSM
