Joe Celko's SQL for Smarties
Advanced SQL Programming
3rd Edition
Published on 23. August 2005
Book
Paperback/Softback
840 pages
978-0-12-369379-2 (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.
Reviews / Votes
"This book is a classic, and this revision will merely solidify its position." --Rudy Limeback "SQL for Smarties is a well-known and highly regarded text in the industry and a new edition of the book will be sought by database practitioners regardless of the DBMS they use." --Craig Mullins, BMC SoftwareMore details
Series
Edition
3rd edition
Language
English
Place of publication
San Francisco
United States
Publishing group
Elsevier Science & Technology
Target group
Professional and scholarly
Working SQL programmers, including those application developers, database analysts, and others who want to pick up some advanced programming tips and techniques, and also those who are developing new features for DBMSs who want to know about users' ideas and needs.
Edition type
New edition
Dimensions
Height: 235 mm
Width: 191 mm
Weight
1665 gr
ISBN-13
978-0-12-369379-2 (9780123693792)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
New editions
Book
12/2014
5th Edition
Morgan Kaufmann
€63.50
Shipment within 15-20 days
Book
11/2010
4th Edition
Morgan Kaufmann
€59.41
Article exhausted; check for reprint
Additional editions
E-Book
07/2010
3rd Edition
Morgan Kaufmann
€49.95
Available for download
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
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