Cover for Joe Celko's SQL for Smarties

Joe Celko's SQL for Smarties

Advanced SQL Programming

A volume in The Morgan Kaufmann Series in Data Management Systems

Book • Third edition2005

Author:

Joe Celko

Joe Celko's SQL for Smarties

Advanced SQL Programming

A volume in The Morgan Kaufmann Series in Data Management Systems

Book • Third edition2005

 

Cover for Joe Celko's SQL for Smarties

Author:

Joe Celko

About the book

Browse this book

Book description

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, 10 years later an ... read full description

Browse content

Table of contents

Actions for selected chapters

Select all / Deselect all

  1. Full text access
  2. Book chapterAbstract only

    Chapter 1 - Database Design

    Pages 1-59

  3. Book chapterAbstract only

    Chapter 2 - Normalization

    Pages 61-99

  4. Book chapterAbstract only

    Chapter 3 - Numeric Data in SQL

    Pages 101-118

  5. Book chapterAbstract only

    Chapter 4 - Temporal Data Types in SQL

    Pages 119-167

  6. Book chapterAbstract only

    Chapter 5 - Character Data Types in SQL

    Pages 169-183

  7. Book chapterAbstract only

    Chapter 6 - NULLs: Missing Data in SQL

    Pages 185-200

  8. Book chapterAbstract only

    Chapter 7 - Multiple Column Data Elements

    Pages 201-209

  9. Book chapterAbstract only

    Chapter 8 - Table Operations

    Pages 211-234

  10. Book chapterAbstract only

    Chapter 9 - Comparison or Theta Operators

    Pages 235-240

  11. Book chapterAbstract only

    Chapter 10 - Valued Predicates

    Pages 241-245

  12. Book chapterAbstract only

    Chapter 11 - CASE Expressions

    Pages 247-259

  13. Book chapterAbstract only

    Chapter 12 - LIKE Predicate

    Pages 261-271

  14. Book chapterAbstract only

    Chapter 13 - Between and Overlaps Predicates

    Pages 273-285

  15. Book chapterAbstract only

    Chapter 14 - The [NOT] IN() Predicate

    Pages 287-297

  16. Book chapterAbstract only

    Chapter 15 - EXISTS() Predicate

    Pages 299-308

  17. Book chapterAbstract only

    Chapter 16 - Quantified Subquery Predicates

    Pages 309-315

  18. Book chapterAbstract only

    Chapter 17 - The SELECT Statement

    Pages 317-368

  19. Book chapterAbstract only

    Chapter 18 - VIEWs, Derived Tables, Materialized Tables, and Temporary Tables

    Pages 369-399

  20. Book chapterAbstract only

    Chapter 19 - Partitioning Data in Queries

    Pages 401-423

  21. Book chapterAbstract only

    Chapter 20 - Grouping Operations

    Pages 425-438

  22. Book chapterAbstract only

    Chapter 21 - Aggregate Functions

    Pages 439-475

  23. Book chapterAbstract only

    Chapter 22 - Auxiliary Tables

    Pages 477-507

  24. Book chapterAbstract only

    Chapter 23 - Statistics in SQL

    Pages 509-548

  25. Book chapterAbstract only

    Chapter 24 - Regions, Runs, Gaps, Sequences, and Series

    Pages 549-573

  26. Book chapterAbstract only

    Chapter 25 - Arrays in SQL

    Pages 575-589

  27. Book chapterAbstract only

    Chapter 26 - Set Operations

    Pages 591-603

  28. Book chapterAbstract only

    Chapter 27 - Subsets

    Pages 605-622

  29. Book chapterAbstract only

    Chapter 28 - Trees and Hierarchies in SQL

    Pages 623-640

  30. Book chapterAbstract only

    Chapter 29 - Temporal Queries

    Pages 641-680

  31. Book chapterAbstract only

    Chapter 30 - Graphs in SQL

    Pages 681-707

  32. Book chapterAbstract only

    Chapter 31 - OLAP in SQL

    Pages 709-718

  33. Book chapterAbstract only

    Chapter 32 - Transactions and Concurrency Control

    Pages 719-730

  34. Book chapterAbstract only

    Chapter 33 - Optimizing SQL

    Pages 731-760

  35. Book chapterNo access

    References

    Pages 761-775

  36. Book chapterNo access

    Index

    Pages 777-808

  37. Book chapterNo access

    About the Author

    Page 810

About the book

Description

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, 10 years later and in the third edition, this classic still reigns supreme as the book written by an SQL master that teaches future SQL masters. These are not just tips and techniques; Joe also offers the best solutions to old and new challenges and conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. In the third edition, Joe features new examples and updates to SQL-99, expanded sections of Query techniques, and a new section on schema design, with the same war-story teaching style that made the first and second editions of this book classics.

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, 10 years later and in the third edition, this classic still reigns supreme as the book written by an SQL master that teaches future SQL masters. These are not just tips and techniques; Joe also offers the best solutions to old and new challenges and conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. In the third edition, Joe features new examples and updates to SQL-99, expanded sections of Query techniques, and a new section on schema design, with the same war-story teaching style that made the first and second editions of this book classics.

Key Features

  • Expert advice from a noted SQL authority and award-winning columnist, who has given ten years of service to the ANSI SQL standards committee and many more years of dependable help to readers of online forums.
  • Teaches scores of advanced techniques that can be used with any product, in any SQL environment, whether it is an SQL-92 or SQL-99 environment.
  • Offers tips for working around system deficiencies.
  • Continues to use war stories--updated!--that give insights into real-world SQL programming challenges.
  • Expert advice from a noted SQL authority and award-winning columnist, who has given ten years of service to the ANSI SQL standards committee and many more years of dependable help to readers of online forums.
  • Teaches scores of advanced techniques that can be used with any product, in any SQL environment, whether it is an SQL-92 or SQL-99 environment.
  • Offers tips for working around system deficiencies.
  • Continues to use war stories--updated!--that give insights into real-world SQL programming challenges.

Details

ISBN

978-0-12-369379-2

Language

English

Published

2005

Copyright

Copyright © 2005 Elsevier Inc. All rights reserved

Imprint

Morgan Kaufmann

Authors

Joe Celko