Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL: Auxiliary, Temporal, and Virtual Tables in SQL (The Morgan Kaufmann in Data Management Systems)

Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL: Auxiliary, Temporal, and Virtual Tables in SQL (The Morgan Kaufmann in Data Management Systems)

Joe Celko


completely clever programmers usually fight while pressured to paintings with SQL. Why? Joe Celko believes the matter lies with their procedural programming mind-set, which retains them from taking complete good thing about the facility of declarative languages. the result's overly complicated and inefficient code, let alone misplaced productivity.

This ebook will switch how you take into consideration the issues you remedy with SQL programs.. targeting 3 key table-based suggestions, Celko finds their strength via targeted examples and transparent factors. As you grasp those options, you’ll locate you may conceptualize difficulties as rooted in units and solvable via declarative programming. sooner than lengthy, you’ll be coding extra quick, writing extra effective code, and utilizing the complete energy of SQL.

• full of the insights of 1 of the world’s top SQL gurus - famous for his wisdom and his skill to educate what he knows.
• specializes in auxiliary tables (for computing capabilities and different values by means of joins), temporal tables (for temporal queries, old information, and audit information), and digital tables (for better performance).
• provides transparent advice for choosing and properly utilising the precise desk procedure.

Show sample text content

Download sample