| Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL Contributor(s): Celko, Joe (Author) |
|
 |
ISBN: 0123741378 ISBN-13: 9780123741370 Publisher: Morgan Kaufmann Publishers OUR PRICE: $33.61 Product Type: Paperback - Other Formats Published: January 2008 Annotation: Joe Celko has looked deep into the code of novice SQL programmers and found a consistent and troubling pattern. These programmers 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 conceptualize database problems as rooted in sets and solvable through declarative programming techniques. The book focuses on three table-based SQL techniques that not only demonstrate this set characteristic of SQL, but also dramatically simplify application development. For each table type--auxiliary, temporal and virtual--Joe teaches the new kind of thinking required to use them effectively, how to choose the right table technique to apply, and why. |
| Additional Information |
| BISAC Categories: - Computers | Programming Languages - Sql - Computers | Databases - General - Computers | Programming - General |
| Dewey: 005.13 |
| LCCN: 2007043898 |
| Series: Morgan Kaufmann Series in Data Management Systems |
| Physical Information: 0.9" H x 7.51" W x 9.12" (1.72 lbs) 384 pages |
| Descriptions, Reviews, Etc. |
| Publisher Description: 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, you'll find you are able to conceptualize problems as rooted in sets and solvable through declarative programming. Before long, you'll be coding more quickly, writing more efficient code, and applying the full power of SQL |