9780123741370

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

by
  • ISBN13:

    9780123741370

  • ISBN10:

    0123741378

  • Format: Paperback
  • Copyright: 2008-01-22
  • Publisher: Elsevier Science
  • Purchase Benefits
  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $33.95 Save up to $5.09
  • Buy New
    $28.86

    PRINT ON DEMAND: 2-4 WEEKS. THIS ITEM CANNOT BE CANCELLED OR RETURNED.

Supplemental Materials

What is included with this book?

  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
  • The eBook copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Summary

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.

Table of Contents

SQL Is Declarative, Not Proceduralp. 1
Hardware, Data Volume, and Maintaining Databasesp. 29
Data Access and Recordsp. 37
Lookup Tablesp. 51
Auxiliary Tablesp. 65
Viewsp. 87
Virtual Tablesp. 117
Complicated Functions via Tablesp. 137
Temporal Tablesp. 155
Scrubbing Data with Non-1NF Tablesp. 191
Thinking in SQLp. 215
Group Characteristicsp. 235
Turning Specifications into Codep. 255
Using Procedure and Function Callsp. 273
Numbering Rowsp. 287
Keeping Computed Datap. 297
Triggers for Constraintsp. 301
Procedural and Data Driven Solutionsp. 323
Indexp. 349
Table of Contents provided by Blackwell. All Rights Reserved.

Rewards Program

Write a Review