Comments:
*******************************************************************************<br />
Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual<br />
*******************************************************************************<br />
<br />
-------------------------------------------------------------------------------<br />
General Information<br />
-------------------------------------------------------------------------------<br />
Type.................: Ebook<br />
Part Size............: 8,092,779 bytes<br />
<br />
<br />
<br />
<br />
-------------------------------------------------------------------------------<br />
Post Information<br />
-------------------------------------------------------------------------------<br />
Posted by............: ~tqw~<br />
<br />
-------------------------------------------------------------------------------<br />
Release Notes<br />
-------------------------------------------------------------------------------<br />
Joe Celko has looked deep into the code of novice SQL programmers and found a <br />
consistent and troubling pattern. These programmers have not changed their <br />
approach from writing code for a procedural language, like C, to a declarative <br />
language--which is what SQL is. As a result they are not fully using the power <br />
and capability inherent in SQL and that translates into writing more code than <br />
they need to write, more complex code than is needed, and ultimately lower <br />
productivity.<br />
<br />
Thinking in sets reveals the conceptual shift these programmers need to make. <br />
Through detailed examples and clear explanations, Joe enables readers to <br />
concepualize database problems as rooted in sets and solvable through <br />
declarative programming techniques. The book focuses on three main table-based <br />
SQL techniques that not only demonstrate this set characteristic of SQL but also <br />
dramatically simplify application development. For each table type--auxillary, <br />
temporal and virrual--Joe teaches not only the new kind of thinking required to <br />
use them effectively but also how to choose the right table technique to apply <br />
and why.<br />
<br />
Table Of Contents<br />
<br />
Table of Contents Preface xvii<br />
1 SQL Is Declarative, Not Procedural<br />
2 Hardware, Data Volume, and Maintaining Databases<br />
3 Data Access and Records <br />
4 Lookup Tables <br />
5 Auxiliary Tables <br />
6 Views <br />
7 Virtual Tables <br />
8 Complicated Functions via Tables <br />
9 Temporal Tables <br />
10 Scrubbing Data with Non-1NF Tables <br />
11 Thinking in SQL <br />
12 Group Characteristics <br />
13 Turning Specifications into Code <br />
14 Using Procedure and Function Calls <br />
15 Numbering Rows <br />
16 Keeping Computed Data <br />
17 Triggers for Constraints <br />
18 Procedural and Data Driven Solutions <br />
Index <br />
<br />
Product Details<br />
<br />
* ISBN: 0123741378<br />
* ISBN-13: 9780123741370<br />
* Format: Paperback, 362pp<br />
* Publisher: Elsevier Science & Technology Books<br />
* Pub. Date: January 2008<br />
<br />
-------------------------------------------------------------------------------<br />
Install Notes<br />
-------------------------------------------------------------------------------<br />
Adobe Acrobat Reader<br />
<br />
<br />
Add comment