Joe Celko's SQL for Smarties: Advanced SQL Programming

by Joe Celko

Overview

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.

Product Details

ISBN-13:	9780080460048
Publisher:	Morgan Kaufmann Publishers
Publication date:	07/26/2010
Series:	The Morgan Kaufmann Series in Data Management Systems
Sold by:	Barnes & Noble
Format:	eBook
Pages:	840
File size:	13 MB
Note:	This product may take a few minutes to download.

About the Author

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.

Table of Contents

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

What People are Saying About This

From the Publisher

Bestselling author and SQL guru Joe Celko ensures programming success through his new and expanded edition of SQL for Smarties which is packed with tips, tricks and other indispensable information for any and all SQL database practitioners and programmers who need to know how to get their job done.

Editorial Reviews

The Barnes & Noble Review
Joe Celko’s SQL for Smarties turns experienced SQL programmers into great SQL programmers. Now he’s updated this classic to reflect today’s state-of-the-art in SQL coding. That means new examples, many drawn from SQL-99 features that were still on the drawing board last time. It also means more advanced query techniques, plus a whole new discussion of schema design. What hasn’t changed, though, is just as important: Celko’s relentlessly informed and practical approach, and the breadth of his coverage.

Do you want to design or normalize databases more effectively? Make better use of data types, tables, CASE expressions, predicates, SELECT, VIEW, partitioning data, grouping operations, aggregate functions? Handle gaps, sequences, series? OLAP, transactions, currency control, optimization? Celko offers advanced techniques for all that, and plenty more. Get this book, and get a stack of Post-it Notes: you’ll use ’em. Bill Camarda, from the November 2005 Read Only

bn.com

A compendium of tips and tricks for advanced SQL programming, with coverage of database and data design, data types, and operations on tables, in an informal, conversational style. The bulk of the book covers predicates and logical operators of SQL, and complex queries. SQL-89 features now supported by commercial RDBMSs are discussed, as well as SQL-92 and how it's being implemented in current and future database products. An appendix offers source code for six check-digit programs. Annotation c. Book News, Inc., Portland, OR (booknews.com)

Booknews

"...a must—read book for any SQL programmer, covering advanced topics in an understandable way...aimed at taking experienced SQL programmers and giving them the extras to make them experts." —I Programmer, 2015

From the Publisher