Joe Celko's SQL for Smarties

Produktbeschreibung

5th edition. 

Inhaltsverzeichnis

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 

Autoreninfo

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.