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

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

Joe Celko


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

This publication will swap how you take into consideration the issues you clear up with SQL programs.. concentrating on 3 key table-based options, Celko unearths their strength via particular examples and transparent causes. As you grasp those recommendations, you’ll locate you can conceptualize difficulties as rooted in units and solvable via declarative programming. sooner than lengthy, you’ll be coding extra speedy, writing extra effective code, and utilizing the whole strength of SQL

• packed with 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 way of joins), temporal tables (for temporal queries, historic facts, and audit information), and digital tables (for superior performance).

• provides transparent tips for opting for and properly using the precise desk procedure.

Show sample text content

Download sample