Cart
Free Shipping in Australia
Proud to be B-Corp

Joe Celko's SQL for Smarties Joe Celko (Independent Consultant, Austin, Texas)

Joe Celko's SQL for Smarties By Joe Celko (Independent Consultant, Austin, Texas)

Summary

Offers solutions to 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. This edition teaches various advanced techniques that can be used with any product, in any SQL environment, whether it is an SQL-92 or SQL-99 environment.

Joe Celko's SQL for Smarties Summary

Joe Celko's SQL for Smarties: Advanced SQL Programming by Joe Celko (Independent Consultant, Austin, Texas)

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.

Joe Celko's SQL for Smarties Reviews

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

About Joe Celko (Independent Consultant, Austin, Texas)

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

Additional information

GOR013191328
9780123693792
0123693799
Joe Celko's SQL for Smarties: Advanced SQL Programming by Joe Celko (Independent Consultant, Austin, Texas)
Used - Like New
Paperback
Elsevier Science & Technology
20050823
840
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
The book has been read, but looks new. The book cover has no visible wear, and the dust jacket is included if applicable. No missing or damaged pages, no tears, possible very minimal creasing, no underlining or highlighting of text, and no writing in the margins

Customer Reviews - Joe Celko's SQL for Smarties