Joe Celko's SQL for Smarties: Advanced SQL Programming

Front Cover
Morgan Kaufmann, 2000 - Computers - 553 pages
3 Reviews

SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques you need to transform yourself into an expert SQL programmer. Now, in this fully updated second edition, SQL mastermind Joe Celko keeps you moving forward, using his entertaining, conversational style to teach you the best solutions to old and new challenges and to convey the way you need to think if you really want to get the most out of your SQL programming efforts.


Inside, logic- and set-based analyses replace the traditional, procedural approach to problem-solving, helping you make the conceptual leap that separates an SQL guru from the rest of the pack. As you catch on to Celko's approach, you'll devour what he has to say about some of SQL's toughest topics: how aggregate functions really work, the best way to work with NULLs, how and why to fake array structures, and much more.


This book gives special emphasis to SQL-92 and product-independent techniques that let you optimize performance or achieve highly specialized behavior, regardless of the RDBMS with which you work. If you're serious about SQL, you won't let SQL for Smarties out of your sight.



* Presents all-new war stories that give you insight into real-world SQL programming challenges.
* Continues to cover SQL-89 but focuses heavily on the SQL-92 standard.
* Offers still more undocumented tips for working around system deficiencies.
* Teaches scores of advanced techniques that can be used with any product, in any SQL environment.
* Offers expert advice from a noted SQL authority and award-winning columnist.
  

What people are saying - Write a review

User Review - Flag as inappropriate

I love this book. When I started using it I was a beginner and very quickly moved to a more competent intermediate/advanced SQL user. I would, and have, recommend it to anyone needing to get more from their SQL programming.

Review: Joe Celko's SQL for Smarties: Advanced SQL Programming

User Review  - Kevin - Goodreads

Good, but a bit over-rated. Some of the code in here is a bit obscure and most would probably have trouble finding use for it on everyday projects. Still neat, though. Read full review

Contents

V
7
VII
20
VIII
23
IX
26
XI
29
XII
30
XIII
31
XV
33
CXI
283
CXII
287
CXIV
290
CXV
299
CXVII
308
CXVIII
315
CXIX
316
CXX
319

XVI
34
XVII
35
XVIII
45
XIX
46
XX
49
XXII
51
XXIII
53
XXIV
54
XXV
56
XXVI
60
XXVII
65
XXVIII
70
XXIX
73
XXX
74
XXXI
77
XXXII
85
XXXIII
88
XXXIV
89
XXXV
91
XXXVI
97
XXXVIII
100
XXXIX
101
XL
109
XLI
111
XLII
112
XLIII
113
XLIV
114
XLV
115
XLVI
116
XLVII
118
XLIX
119
L
120
LI
122
LII
127
LIV
132
LV
133
LVI
135
LVIII
138
LX
139
LXI
140
LXII
141
LXIII
143
LXV
151
LXVI
154
LXVII
162
LXVIII
165
LXIX
166
LXX
167
LXXI
171
LXXIII
175
LXXIV
176
LXXV
178
LXXVIII
179
LXXIX
181
LXXXI
183
LXXXII
193
LXXXIII
194
LXXXIV
197
LXXXV
198
LXXXVI
201
LXXXVII
203
LXXXVIII
205
LXXXIX
207
XCI
208
XCII
211
XCIV
213
XCV
215
XCVI
216
XCVII
219
XCIX
232
C
249
CII
253
CIII
265
CV
266
CVI
268
CVII
273
CVIII
277
CIX
281
CX
282
CXXI
320
CXXII
323
CXXIII
334
CXXIV
343
CXXVI
346
CXXVII
348
CXXVIII
351
CXXX
353
CXXXI
366
CXXXIII
367
CXXXIV
376
CXXXV
383
CXXXVI
384
CXXXVII
385
CXXXVIII
388
CXL
393
CXLII
398
CXLIII
402
CXLIV
405
CXLV
409
CXLVI
410
CXLVII
414
CXLVIII
416
CXLIX
419
CL
421
CLII
423
CLIII
426
CLIV
431
CLV
432
CLVI
433
CLVII
434
CLIX
435
CLXI
437
CLXII
441
CLXIII
447
CLXIV
450
CLXV
451
CLXVI
452
CLXVII
455
CLXVIII
456
CLXIX
460
CLXX
461
CLXXI
467
CLXXII
468
CLXXIII
471
CLXXIV
473
CLXXV
474
CLXXVI
475
CLXXVII
481
CLXXVIII
482
CLXXIX
485
CLXXX
486
CLXXXI
487
CLXXXII
492
CLXXXIII
493
CLXXXIV
495
CLXXXV
497
CLXXXVII
498
CLXXXVIII
499
CLXXXIX
502
CXC
503
CXCI
504
CXCII
506
CXCIII
507
CXCIV
511
CXCV
512
CXCVII
513
CXCIX
515
CCI
516
CCIII
517
CCIV
518
CCVII
520
CCIX
521
CCXI
522
CCXII
523
CCXIII
533
CCXIV
554
Copyright

Common terms and phrases

About the author (2000)

Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards.

Mr. Celko is author a series of books on SQL and RDBMS for Elsevier/MKP. He is an independent consultant based in Austin, Texas.

He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.

Bibliographic information