Joe Celko's SQL for Smarties: Advanced SQL Programming / Edition 4

Joe Celko's SQL for Smarties: Advanced SQL Programming / Edition 4

by Joe Celko
     
 

SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 15 years later and in its fourth edition, this classic reference still reigns supreme as the only book written by a SQL master that teaches programmers and practitioners to become SQL masters themselves!

See more details below

Overview

SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 15 years later and in its fourth edition, this classic reference still reigns supreme as the only book written by a SQL master that teaches programmers and practitioners to become SQL masters themselves! These are not just tips and techniques; also offered are the best solutions to old and new challenges. Joe Celko conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. New to the fourth edition, Joe features new examples to reflect the ANSI/ISO Standards so anyone can use it. He also updates data element names to meet new ISO—11179 rules with the same experience-based teaching style that made the previous editions the classics they are today.

Product Details

ISBN-13:
9780123820228
Publisher:
Elsevier Science
Publication date:
10/29/2010
Series:
Morgan Kaufmann Series in Data Management Systems Series
Pages:
816
Sales rank:
738,329
Product dimensions:
7.50(w) x 9.20(h) x 1.50(d)

Table of Contents

1Database design1
2Normalization61
3Numeric data in SQL101
4Temporal data types in SQL119
5Character data types in SQL169
6NULLs : missing data in SQL185
7Multiple column data elements201
8Table operations211
9Comparison or theta operators235
10Valued predicates241
11CASE expressions247
12LIKE predicate261
13BETWEEN and OVERLAPS predicates273
14The [NOT] IN() predicate287
15EXISTS() predicate299
16Quantified subquery predicates309
17The SELECT statement317
18VIEWs, derived tables, materialized tables, and temporary tables369
19Partitioning data in queries401
20Grouping operations425
21Aggregate functions439
22Auxiliary tables477
23Statistics in SQL509
24Regions, runs, gaps, sequences, and series549
25Arrays in SQL575
26Set operations591
27Subsets605
28Trees and hierarchies in SQL623
29Temporal queries641
30Graphs in SQL681
31OLAP in SQL709
32Transactions and concurrency control719
33Optimizing SQL731

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >