Joe Celko's SQL for Smarties: Advanced SQL Programming (Google eBook)

Front Cover
Elsevier, Nov 22, 2010 - Computers - 816 pages
1 Review
Joe Celkos SQL for Smarties: Advanced SQL Programming offers tips and techniques in advanced programming. This book is the fourth edition and it consists of 39 chapters, starting with a comparison between databases and file systems. It covers transactions and currency control, schema level objects, locating data and schema numbers, base tables, and auxiliary tables. Furthermore, procedural, semi-procedural, and declarative programming are explored in this book.
The book also presents the different normal forms in database normalization, including the first, second, third, fourth, fifth, elementary key, domain-key, and Boyce-Codd normal forms. It also offers practical hints for normalization and denormalization. The book discusses different data types, such as the numeric, temporal and character data types; the different predicates; and the simple and advanced SELECT statements. In addition, the book presents virtual tables, and it discusses data partitions in queries; grouping operations; simple aggregate functions; and descriptive statistics, matrices and graphs in SQL. The book concludes with a discussion about optimizing SQL. It will be of great value to SQL programmers.

KEY FEATURES

  • Expert advice from a noted SQL authority and award-winning columnist who has given ten years service to the ANSI SQL standards committee
  • Teaches scores of advanced techniques that can be used with any product, in any SQL environment, whether it is an SQL 92 or SQL 2008 environment
  • Offers tips for working around deficiencies and gives insight into real-world challenges
  

What people are saying - Write a review

Review: Joe Celko's SQL for Smarties: Advanced SQL Programming

User Review  - Kevin - Goodreads

Good, but a bit over-rated. Some of the code in here is a bit obscure and most would probably have trouble finding use for it on everyday projects. Still neat, though. Read full review

Contents

Chapter 1 Databases versus File Systems
1
Chapter 2 Transactions and Concurrency Control
11
Chapter 3 Schema Level Objects
23
Chapter 4 Locating Data and Special Numbers
35
Chapter 5 Base Tables and Related Elements
51
Chapter 6 Procedural Semiprocedural and Declarative Programming
105
Chapter 7 Procedural Constructs
123
Chapter 8 Auxiliary Tables
145
Chapter 22 EXISTS Predicate
381
Chapter 23 Quantified Subquery Predicates
389
Chapter 24 The Simple SELECT Statement
397
Chapter 25 Advanced SELECT Statements
407
VIEWs Derived Tables CTEs and MQTs
445
Chapter 27 Partitioning Data in Queries
473
Chapter 28 Grouping Operations
493
Chapter 29 Simple Aggregate Functions
507

Chapter 9 Normalization
181
Chapter 10 Numeric Data Types
215
Chapter 11 Temporal Data Types
237
Chapter 12 Character Data Types
255
Missing Data in SQL
271
Chapter 14 Multiple Column Data Elements
289
Chapter 15 Table Operations
299
Chapter 16 Comparison or Theta Operators
323
Chapter 17 Valued Predicates
329
Chapter 18 CASE Expressions
333
Chapter 19 LIKE and SIMILAR TO Predicates
345
Chapter 20 BETWEEN and OVERLAPS Predicates
355
Chapter 21 The NOT IN Predicate
369
Chapter 30 Advanced Grouping Windowed Aggregation and OLAP in SQL
539
Chapter 31 Descriptive Statistics in SQL
555
Chapter 32 Subsequences Regions Runs Gaps and Islands
595
Chapter 33 Matrices in SQL
617
Chapter 34 Set Operations
631
Chapter 35 Subsets
643
Chapter 36 Trees and Hierarchies in SQL
665
Chapter 37 Graphs in SQL
681
Chapter 38 Temporal Queries
701
Chapter 39 Optimizing SQL
737
References
763
Index
775
Copyright

Common terms and phrases

About the author (2010)

Industry Consultant

Bibliographic information