- 816 pages
- English
- ePUB (mobile friendly)
- Available on iOS & Android
About This Book
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.
- 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
Frequently asked questions
Information
Table of contents
- Cover image
- Title page
- Table of Contents
- Copyright
- Dedication
- About the Author
- Introduction to the Fourth Edition
- 1. Databases versus File Systems
- 2. Transactions and Concurrency Control
- 3. Schema Level Objects
- 4. Locating Data and Special Numbers
- 5. Base Tables and Related Elements
- 6. Procedural, Semiprocedural, and Declarative Programming
- 7. Procedural Constructs
- 8. Auxiliary Tables
- 9. Normalization
- 10. Numeric Data Types
- 11. Temporal Data Types
- 12. Character Data Types
- 13. NULLs: Missing Data in SQL
- 14. Multiple Column Data Elements
- 15. Table Operations
- 16. Comparison or Theta Operators
- 17. Valued Predicates
- 18. CASE Expressions
- 19. LIKE and SIMILAR TO Predicates
- 20. BETWEEN and OVERLAPS Predicates
- 21. The [NOT] IN() Predicate
- 22. EXISTS() Predicate
- 23. Quantified Subquery Predicates
- 24. The Simple SELECT Statement
- 25. Advanced SELECT Statements
- 26. Virtual Tables: VIEWs, Derived Tables, CTEs, and MQTs
- 27. Partitioning Data in Queries
- 28. Grouping Operations
- 29. Simple Aggregate Functions
- 30. Advanced Grouping, Windowed Aggregation, and OLAP in SQL
- 31. Descriptive Statistics in SQL
- 32. Subsequences, Regions, Runs, Gaps, and Islands
- 33. Matrices in SQL
- 34. Set Operations
- 35. Subsets
- 36. Trees and Hierarchies in SQL
- 37. Graphs in SQL
- 38. Temporal Queries
- 39. Optimizing SQL
- Index