Joe Celko's SQL for Smarties

Joe Celko's SQL for Smarties : Advanced SQL Programming

3.96 (166 ratings by Goodreads)
By (author) 

List price: US$66.95

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

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.
show more

Product details

  • Paperback | 840 pages
  • 188 x 231.1 x 48.3mm | 1,700.99g
  • Morgan Kaufmann Publishers In
  • San Francisco, United States
  • English
  • 3rd edition
  • 0123693799
  • 9780123693792
  • 1,076,821

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
show more

About Joe Celko

Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards. He has written over 900 columns in the computer trade and academic press, mostly dealing with data and databases. Joe has authored eight books on SQL for Morgan Kaufmann.
show more

Review quote

"This book is a classic, and this revision will merely solidify its position."
--Rudy Limeback
show more

Review Text

"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 Software "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 Software
show more

Rating details

166 ratings
3.96 out of 5 stars
5 32% (53)
4 41% (68)
3 20% (34)
2 5% (9)
1 1% (2)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X