Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL free download online
Title: Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL Author(s): Joe Celko Pages: 384 Publisher: Morgan Kaufmann Publication date: 2008 Language: English Format: PDF ISBN-10: 0123741378 ISBN-13: Description: New advice for novice SQL programmers: think like a pro, think in sets!
Perfectly intelligent programmers often struggle when forced to work with SQL. Why? Joe Celko believes the problem lies with their procedural programming mindset, which keeps them from taking full advantage of the power of declarative languages. The result is overly complex and inefficient code, not to mention lost productivity.
This book will change the way you think about the problems you solve with SQL programs.. Focusing on three key table-based techniques, Celko reveals their power through detailed examples and clear explanations. As you master these techniques, youll find you are able to conceptualize problems as rooted in sets and solvable through declarative programming. Before long, youll be coding more quickly, writing more efficient code, and applying the full power of SQL
Filled with the insights of one of the worlds leading SQL authorities - noted for his knowledge and his ability to teach what he knows.
Focuses on auxiliary tables (for computing functions and other values by joins), temporal tables (for temporal queries, historical data, and audit information), and virtual tables (for improved performance).
Presents clear guidance for selecting and correctly applying the right table technique.
Book Description
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.
About the Author
Joe Celko is a noted consultant, lecturer, teacher, and one of the most-read SQL authors in the world. He is well known for his ten years of service on the ANSI SQL standards committee, his dependable help on assorted SQL newsgroups, his column in Intelligent Enterprise (which won several Readers Choice Awards), and the war stories he tells to provide real-world insights into SQL programming. His best-selling books include Joe Celkos SQL for Smarties: Advanced SQL Programming, Joe Celkos SQL Puzzles and Answers, Joe Celkos Trees and Hierarchies in SQL for Smarties, and Joe Celkos SQL Style, all published by Morgan Kaufmann.
Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL free download links:
Title: Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL