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 frequently fight whilst compelled to paintings with SQL. Why? Joe Celko believes the matter lies with their procedural programming frame of mind, which retains them from taking complete benefit of the facility 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 remedy with SQL programs.. targeting 3 key table-based recommendations, Celko unearths their energy via certain examples and transparent motives. As you grasp those suggestions, you’ll locate you may conceptualize difficulties as rooted in units and solvable via declarative programming. prior to lengthy, you’ll be coding extra quick, writing extra effective code, and utilising the total strength of SQL.

• choked with the insights of 1 of the world’s prime SQL specialists - famous for his wisdom and his skill to coach what he knows.
• makes a speciality of auxiliary tables (for computing services and different values by way of joins), temporal tables (for temporal queries, old information, and audit information), and digital tables (for more advantageous performance).
• offers transparent assistance for choosing and properly utilising the fitting desk process.

Show sample text content

Download sample