Description

Book Synopsis


Trade 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 Contents
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

Joe Celkos SQL for Smarties

    Product form

    A Paperback by Joe Celko

    £48.44

    Includes FREE delivery

    RRP £50.99 – you save £2.55 (5%)

    Order before 4pm today for delivery by Wed 18 Nov 2026.

    3 in stock

      Trusted by thousands of customers. See 2,385+ Customer Reviews

      View other formats and editions of Joe Celkos SQL for Smarties by Joe Celko

      Book details

      Published 2 December 2014
      ISBN-13 9780128007617
      978-0128007617
      ISBN-10 0128007613

      Description

      Book Synopsis


      Trade 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 Contents
      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

      Recently viewed products

      © 2026 Book Curl

        • American Express
        • Apple Pay
        • Diners Club
        • Discover
        • Google Pay
        • Maestro
        • Mastercard
        • PayPal
        • Shop Pay
        • Union Pay
        • Visa

        Login

        Forgot your password?

        Don't have an account yet?
        Create account