Description
Book SynopsisTrade Review"...a must-read book for any SQL programmer, covering advanced topics in an understandable way...aimed at taking experienced SQL programmers and giving them the extras to make them experts." --I Programmer, 2015
Table of ContentsPART 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