Morgan Kaufmann Joe Celkos Thinking in Sets Auxiliary Temporal and Virtual Table

Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables

in SQL (c) by Morgan Kaufmann

The type of the release is: eBook

In the PDF format with ISBN: 0123741378 and Pub Date: January 21, 2008

The size of the release is: 01 disks x 1.44mb

And released on: 02/12/2008

Joe Celko has looked deep into the code of novice SQL programmers and

found a consistent and troubling pattern. These programmers have not

changed their approach from writing code for a procedural language, like

C, to a declarative language--which is what SQL is. As a result they are

not fully using the power and capability inherent in SQL and that

translates into writing more code than they need to write, more complex

code than is needed, and ultimately lower productivity. Thinking in sets

reveals the conceptual shift these programmers need to make. Through

detailed examples and clear explanations, Joe enables readers to

concepualize database problems as rooted in sets and solvable through

declarative programming techniques. The book focuses on three main

table-based SQL techniques that not only demonstrate this set

characteristic of SQL but also dramatically simplify application

development. For each table type--auxillary, temporal and virrual--Joe

teaches not only the new kind of thinking required to use them

effectively but also how to choose the right table technique to apply

and why.

* Joe brings you comprehensive treatment of SQL programming techniques

that make use of tables rather than procedural code.

* The focus on real world examples and Joe's creative teaching style

enable SQL programmers to conquer a common weak spot, while learning

these new tools.

* A unique contribution, many techniques which are novel and unavailable

elsewhere.

/-/0123741378/