Cover for Joe Celko's SQL for Smarties

Joe Celko's SQL for Smarties

Advanced SQL Programming

A volume in The Morgan Kaufmann Series in Data Management Systems

Book • Fourth Edition2011

Author:

Joe Celko

Joe Celko's SQL for Smarties

Advanced SQL Programming

A volume in The Morgan Kaufmann Series in Data Management Systems

Book • Fourth Edition2011

 

Cover for Joe Celko's SQL for Smarties

Author:

Joe Celko

About the book

Browse this book

Book description

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 w ... read full description

Browse content

Table of contents

Actions for selected chapters

Select all / Deselect all

  1. Full text access
  2. Book chapterAbstract only

    1 - Databases versus File Systems

    Pages 1-10

  3. Book chapterAbstract only

    2 - Transactions and Concurrency Control

    Pages 11-22

  4. Book chapterAbstract only

    3 - Schema Level Objects

    Pages 23-33

  5. Book chapterAbstract only

    4 - Locating Data and Special Numbers

    Pages 35-50

  6. Book chapterAbstract only

    5 - Base Tables and Related Elements

    Pages 51-104

  7. Book chapterAbstract only

    6 - Procedural, Semiprocedural, and Declarative Programming

    Pages 105-122

  8. Book chapterAbstract only

    7 - Procedural Constructs

    Pages 123-144

  9. Book chapterAbstract only

    8 - Auxiliary Tables

    Pages 145-179

  10. Book chapterAbstract only

    9 - Normalization

    Pages 181-214

  11. Book chapterAbstract only

    10 - Numeric Data Types

    Pages 215-236

  12. Book chapterAbstract only

    11 - Temporal Data Types

    Pages 237-253

  13. Book chapterAbstract only

    12 - Character Data Types

    Pages 255-269

  14. Book chapterAbstract only

    13 - NULLs: Missing Data in SQL

    Pages 271-287

  15. Book chapterAbstract only

    14 - Multiple Column Data Elements

    Pages 289-298

  16. Book chapterAbstract only

    15 - Table Operations

    Pages 299-321

  17. Book chapterAbstract only

    16 - Comparison or Theta Operators

    Pages 323-328

  18. Book chapterAbstract only

    17 - Valued Predicates

    Pages 329-332

  19. Book chapterAbstract only

    18 - CASE Expressions

    Pages 333-343

  20. Book chapterAbstract only

    19 - LIKE and SIMILAR TO Predicates

    Pages 345-354

  21. Book chapterAbstract only

    20 - BETWEEN and OVERLAPS Predicates

    Pages 355-367

  22. Book chapterAbstract only

    21 - The [NOT] IN() Predicate

    Pages 369-379

  23. Book chapterAbstract only

    22 - EXISTS() Predicate

    Pages 381-388

  24. Book chapterAbstract only

    23 - Quantified Subquery Predicates

    Pages 389-395

  25. Book chapterAbstract only

    24 - The Simple SELECT Statement

    Pages 397-405

  26. Book chapterAbstract only

    25 - Advanced SELECT Statements

    Pages 407-443

  27. Book chapterAbstract only

    26 - Virtual Tables: VIEWs, Derived Tables, CTEs, and MQTs

    Pages 445-472

  28. Book chapterAbstract only

    27 - Partitioning Data in Queries

    Pages 473-492

  29. Book chapterAbstract only

    28 - Grouping Operations

    Pages 493-505

  30. Book chapterAbstract only

    29 - Simple Aggregate Functions

    Pages 507-538

  31. Book chapterAbstract only

    30 - Advanced Grouping, Windowed Aggregation, and OLAP in SQL

    Pages 539-554

  32. Book chapterAbstract only

    31 - Descriptive Statistics in SQL

    Pages 555-593

  33. Book chapterAbstract only

    32 - Subsequences, Regions, Runs, Gaps, and Islands

    Pages 595-616

  34. Book chapterAbstract only

    33 - Matrices in SQL

    Pages 617-630

  35. Book chapterAbstract only

    34 - Set Operations

    Pages 631-641

  36. Book chapterAbstract only

    35 - Subsets

    Pages 643-663

  37. Book chapterAbstract only

    36 - Trees and Hierarchies in SQL

    Pages 665-680

  38. Book chapterAbstract only

    37 - Graphs in SQL

    Pages 681-700

  39. Book chapterAbstract only

    38 - Temporal Queries

    Pages 701-736

  40. Book chapterAbstract only

    39 - Optimizing SQL

    Pages 737-762

  41. Book chapterNo access

    References

    Pages 763-773

  42. Book chapterNo access

    Index

    Pages 775-787

About the book

Description

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.

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

Details

ISBN

978-0-12-382022-8

Language

English

Published

2011

Copyright

Copyright © 2011 Elsevier Inc. All rights reserved

Imprint

Morgan Kaufmann

Authors

Joe Celko