×

Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

Joe Celko's SQL for Smarties: Advanced SQL Programming / Edition 3
     

Joe Celko's SQL for Smarties: Advanced SQL Programming / Edition 3

by Joe Celko
 

See All Formats & Editions

ISBN-10: 0123693799

ISBN-13: 9780123693792

Pub. Date: 07/29/2005

Publisher: Elsevier Science

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

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:
9780123693792
Publisher:
Elsevier Science
Publication date:
07/29/2005
Series:
Morgan Kaufmann Series in Data Management Systems Series
Edition description:
REV
Pages:
840
Product dimensions:
7.46(w) x 9.20(h) x 1.80(d)

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

Customer Reviews

Average Review:

Post to your social network

     

Most Helpful Customer Reviews

See all customer reviews