Joe Celko''s Sql for Smarties - Advanced Sql Programming

Informationen zum Autor 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. Klappentext 5th edition. Inhaltsverzeichnis PART I : Data Declaration Features 1. 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 Types 10. 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 Features 17. 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 SQL 27. Graphs in SQL28. Trees and Hierarchies in SQL29. Queues and Lists30. Matrices in SQL PART V: Typical Queries 31. 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 Issues 36. Access Methods37. Basic Optimization Principles38. Overview of SQL/PSM

Product details

• Authors: Joe Celko, Joe (Independent Consultant Celko, Celko Joe
• Publisher: ELSEVIER SCIENCE BV
• Languages: English
• Product format: Paperback / Softback
• Released: 02.12.2014
• EAN: 9780128007617
• ISBN: 978-0-12-800761-7
• No. of pages: 852
• Series: Morgan Kaufmann; The Morgan Kaufmann Series in Data Management Systems; Morgan Kaufmann Series in Data; Morgan Kaufmann Series in Data; The Morgan Kaufmann Series in Data Management Systems
• Subjects: Natural sciences, medicine, IT, technology > IT, data processing > Programming languages; COMPUTERS / Programming / General, database programming, COMPUTERS / Database Administration & Management