Joe Celko's SQL for Smarties

3rd Edition

Advanced SQL Programming

Authors: Joe Celko Joe Celko
Paperback ISBN: 9780123693792
eBook ISBN: 9780080460048
Imprint: Morgan Kaufmann
Published Date: 29th July 2005
Page Count: 840
39.99 + applicable tax
49.95 + applicable tax
64.95 + applicable tax
62.95 + applicable tax
Unavailable
Compatible Not compatible
VitalSource PC, Mac, iPhone & iPad Amazon Kindle eReader
ePub & PDF Apple & PC desktop. Mobile devices (Apple & Android) Amazon Kindle eReader
Mobi Amazon Kindle eReader Anything else

Institutional Access


Table of Contents

Part I: Data Relational Model Basics Keys and uniqueness; Normalization Practical Hints for Normalization; Practical Hints for Denormalization; Encoding and scales Implementations;Generator functions Part II: DDL (Data Declaration Language)Part III: DML (Data Manipulation Language) 1. Numeric Data in SQL 2. Temporal Datatypes in SQL 3. Character Datatypes in SQL 4. Other Expressions 5. Table Operations 6. INSERT INTO Statement 7. The UPDATE Statement 8. Comparison or Theta Operators 9. Valued Predicates 10. LIKE and SIMILAR TO Predicates 11. BETWEEN and OVERLAPS Predicates 12. The [NOT] IN Predicate 13. [NOT] EXISTS() Predicate 14. Quantified Subquery Predicate 15. The Simple SELECT Statement 16. OUTER JOINs 17. Old versus New JOIN syntax 18. Bin Packing 19. VIEWs 20. TEMPORARY TABLEs 21. Partitioning Data 22. Grouping Operations 23. Aggregate Functions 24. Other Aggregate Functions 25. Auxiliary Tables 26. Statistics in SQL 27. Regions, Runs, Gaps, Sequences and Series 28. Array Structures in SQL 29. Set Operations 30. Subsets 31. Trees in SQL 32. Graphs in SQL 33. Optimizing Code

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.

Key Features

  • 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.

Readership

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.


Details

No. of pages:
840
Language:
English
Copyright:
© Morgan Kaufmann 2005
Published:
Imprint:
Morgan Kaufmann
eBook ISBN:
9780080460048
Paperback ISBN:
9780123693792

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 the Authors

Joe Celko 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.

Affiliations and Expertise

Independent Consultant, Austin, Texas

Joe Celko 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.

Affiliations and Expertise

Independent Consultant, Austin, Texas