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 belowOverview
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:
- 731,331
- Product dimensions:
- 7.50(w) x 9.20(h) x 1.50(d)
Table of Contents
1 | Database design | 1 |
2 | Normalization | 61 |
3 | Numeric data in SQL | 101 |
4 | Temporal data types in SQL | 119 |
5 | Character data types in SQL | 169 |
6 | NULLs : missing data in SQL | 185 |
7 | Multiple column data elements | 201 |
8 | Table operations | 211 |
9 | Comparison or theta operators | 235 |
10 | Valued predicates | 241 |
11 | CASE expressions | 247 |
12 | LIKE predicate | 261 |
13 | BETWEEN and OVERLAPS predicates | 273 |
14 | The [NOT] IN() predicate | 287 |
15 | EXISTS() predicate | 299 |
16 | Quantified subquery predicates | 309 |
17 | The SELECT statement | 317 |
18 | VIEWs, derived tables, materialized tables, and temporary tables | 369 |
19 | Partitioning data in queries | 401 |
20 | Grouping operations | 425 |
21 | Aggregate functions | 439 |
22 | Auxiliary tables | 477 |
23 | Statistics in SQL | 509 |
24 | Regions, runs, gaps, sequences, and series | 549 |
25 | Arrays in SQL | 575 |
26 | Set operations | 591 |
27 | Subsets | 605 |
28 | Trees and hierarchies in SQL | 623 |
29 | Temporal queries | 641 |
30 | Graphs in SQL | 681 |
31 | OLAP in SQL | 709 |
32 | Transactions and concurrency control | 719 |
33 | Optimizing SQL | 731 |
Customer Reviews
Average Review: