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 usually fight whilst compelled to paintings with SQL. Why? Joe Celko believes the matter lies with their procedural programming approach, which retains them from taking complete good thing about the ability of declarative languages. the result's overly complicated and inefficient code, let alone misplaced productivity.

This e-book will switch how you take into consideration the issues you clear up with SQL programs.. targeting 3 key table-based options, Celko finds their energy via designated examples and transparent causes. As you grasp those thoughts, you’ll locate you may conceptualize difficulties as rooted in units and solvable via declarative programming. earlier than lengthy, you’ll be coding extra speedy, writing extra effective code, and utilizing the entire energy of SQL

• packed with the insights of 1 of the world’s best SQL specialists - famous for his wisdom and his skill to educate what he knows.

• makes a speciality of auxiliary tables (for computing features and different values through joins), temporal tables (for temporal queries, old facts, and audit information), and digital tables (for greater performance).

• provides transparent information for identifying and properly employing the ideal desk method.

Show sample text content

Download sample