false 2823404 1 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.<br><br>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.<br><br>* Joe brings you comprehensive treatment of SQL programming techniques that make use of tables rather than procedural code. <br><br>* 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.<br><br>* A unique contribution, many techniques which are novel and unavailable elsewhere. 2849507 21 1 2008 Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL (The Morgan Kaufmann Series in Data Management Systems) total:3|5:2|4:1| 3 14 8 0 0 0 false false Tue Jun 16 19:20:01 -0700 2009 Tue Jun 16 19:20:01 -0700 2009 0 0 false false Wed Jan 21 07:22:42 -0800 2009 Wed Jan 21 07:22:42 -0800 2009 5 0 false false Mon Dec 01 04:26:11 -0800 2008 Mon Dec 01 04:27:17 -0800 2008 0 0 false false Wed Sep 17 12:54:00 -0700 2008 Wed Jun 17 21:05:22 -0700 2009 0 0 false false Fri Sep 12 02:49:47 -0700 2008 Fri Sep 12 02:49:51 -0700 2008 5 0 false false Thu Jun 12 00:33:09 -0700 2008 Thu Jun 12 00:33:09 -0700 2008 4 0 false false Sat Mar 29 01:48:34 -0700 2008 Sat Mar 29 01:48:43 -0700 2008 0 0 false false Thu Feb 14 22:50:27 -0800 2008 Thu Feb 14 22:50:27 -0800 2008 http://www.goodreads.com/book_link/follow/8?book_id=2823404