Joe Celko's SQL for Smarties
Advanced SQL Programming
3rd Edition
Published on 26. July 2010
840 pages
978-0-08-046004-8 (ISBN)
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.
- 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.
More details
Other editions
New editions
E-Book
05/2014
4th Edition
Morgan Kaufmann
€51.95
Available for download
Additional editions
Book
08/2005
3rd Edition
Morgan Kaufmann
€50.75
Article exhausted; check for reprint
Person
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.
Content
Chapter 1: Database Design
Chapter 2: Normalization
Chapter 3: Numeric Data in SQL
Chapter 4: Temporal Data Types in SQL
Chapter 5: Character Data Types in SQL
Chapter 6: NULLs
Chapter 7: Multiple Column Data Elements
Chapter 8: Table Operations
Chapter 9: Comparison or Theta Operators
Chapter 10: Valued Predicates
Chapter 11: CASE Expressions
Chapter 12: LIKE Predicate
Chapter 13: Between and Overlaps Predicates
Chapter 14: The [NOT] IN() predicate
Chapter 15: EXISTS() predicate
Chapter 16: Quantified Subquery Predicates
Chapter 17: The SELECT Statement
Chapter 18: VIEWs, Derived Tables, Materialized Tables, and Temporary Tables
Chapter 19: Partitioning Data in Queries
Chapter 20: Grouping Operations
Chapter 21: Aggregate Functions
Chapter 22: Auxiliary Tables
Chapter 23: Statistics in SQL
Chapter 24: Regions, Runs, Gaps, Sequences, and Series
Chapter 25: Arrays in SQL
Chapter 26: Set Operations
Chapter 27: Subsets
Chapter 28: Trees and Hierarchies in SQL
Chapter 29: Temporal Queries
Chapter 30: Graphs in SQL
Chapter 31: OLAP in SQL
Chapter 32: Transactions and Concurrency Control
Chapter 33: Optimizing SQL
References
General References
Logic
Mathematical Techniques
Random Numbers
Scales and Measurements
Missing Values
Regular Expressions
Graph Theory
Introductory SQL Books
Optimizing Queries
Temporal Data and the Year 2000 Problem
SQL Programming Techniques
Classics
Forum
Updatable VIEWs
Theory, Normalization, and Advanced Database Topics
Books on SQL-92 and SQL-99
Standards and Related Groups
Web Sites Related to SQL
Statistics
Temporal Databases
Index
About the Author
