The Art of SQL - page 1
- 1
- 2
- The Art of SQL
- The Art of SQL
- Table of Contents
- The Art of SQL
- Dedication
- Preface
- Why Another SQL Book?
- Audience
- Assumptions This Book Makes
- Contents of This Book
- Conventions Used in This Book
- Using Code Examples
- Comments and Questions
- Safari Enabled
- Acknowledgments
- Chapter 1. Laying Plans
- Section 1.1. The Relational View of Data
- Section 1.2. The Importance of Being Normal
- Section 1.3. To Be or Not to Be, or to Be Null
- Section 1.4. Qualifying Boolean Columns
- Section 1.5. Understanding Subtypes
- Section 1.6. Stating the Obvious
- Section 1.7. The Dangers of Excess Flexibility
- Section 1.8. The Difficulties of Historical Data
- Section 1.9. Design and Performance
- Section 1.10. Processing Flow
- Section 1.11. Centralizing Your Data
- Section 1.12. System Complexity
- Section 1.13. The Completed Plans
- Chapter 2. Waging War
- Section 2.1. Query Identification
- Section 2.2. Stable Database Connections
- Section 2.3. Strategy Before Tactics
- Section 2.4. Problem Definition Before Solution
- Section 2.5. Stable Database Schema
- Section 2.6. Operations Against Actual Data
- Section 2.7. Set Processing in SQL
- Section 2.8. Action-Packed SQL Statements
- Section 2.9. Profitable Database Accesses
- Section 2.10. Closeness to the DBMS Kernel
- Section 2.11. Doing Only What Is Required
- Section 2.12. SQL Statements Mirror Business Logic
- Section 2.13. Program Logic into Queries
- Section 2.14. Multiple Updates at Once
- Section 2.15. Careful Use of User-Written Functions
- Section 2.16. Succinct SQL
- Section 2.17. Offensive Coding with SQL
- Section 2.18. Discerning Use of Exceptions
- Chapter 3. Tactical Dispositions
- Section 3.1. The Identification of
- Section 3.2. Indexes and Content Lists
- Section 3.3. Making Indexes Work
- Section 3.4. Indexes with Functions and Conversions
- Section 3.5. Indexes and Foreign Keys
- Section 3.6. Multiple Indexing of the Same Columns
- Section 3.7. System-Generated Keys
- Section 3.8. Variability of Index Accesses
- Chapter 4. Maneuvering
- Section 4.1. The Nature of SQL
- Section 4.2. Five Factors Governing the Art of SQL
- Section 4.3. Filtering
- Chapter 5. Terrain
- Section 5.1. Structural Types
- Section 5.2. The Conflicting Goals
- Section 5.3. Considering Indexes as Data Repositories
- Section 5.4. Forcing Row Ordering
- Section 5.5. Automatically Grouping Data
- Section 5.6. The Double-Edged Sword of Partitioning
- Section 5.7. Partitioning and Data Distribution
- Section 5.8. The Best Way to Partition Data
- Section 5.9. Pre-Joining Tables
- Section 5.10. Holy Simplicity
- Chapter 6. The Nine Situations
- Section 6.1. Small Result Set, Direct Specific Criteria
- Section 6.2. Small Result Set, Indirect Criteria
- Section 6.3. Small Intersection of Broad Criteria
- Section 6.4. Small Intersection, Indirect Broad Criteria
- Section 6.5. Large Result Set
- Section 6.6. Self-Joins on One Table
- Section 6.7. Result Set Obtained by Aggregation
- 1
- 2
