Dedication;Preface; Why We Wrote This Book; Audience for This Book; Which Platform and Version?; Structure of This Book; Conventions Used in This Book; About the Code; Comments and Questions; Acknowledgments;Chapter 1: Pivot Tables; 1.1 Using a Pivot Table;Chapter 2: Sets; 2.1 Introduction; 2.2 The Students Example; 2.3 Implementing Set Difference; 2.4 Comparing Two Sets for Equality; 2.5 Implementing Partial Intersection; 2.6 Implementing Full Intersection; 2.
7 Classifying Subsets; 2.8 Summarizing Classes of Sets; 2.9 Aggregating Aggregates; 2.10 Summarizing Aggregated Classes; 2.11 Including Nonaggregated Columns; 2.12 Finding the Top N Values in a Set; 2.13 Reporting the Size of a Set's Complement; 2.14 Finding the Complement of a Set; 2.
15 Finding the Complement of a Missing Set; 2.16 Finding Complements of Sets with Different Universes; 2.17 Comparing a Set with Its Universe; 2.18 Dynamic Classification System;Chapter 3: Data Structures; 3.1 Types of Data Structures; 3.2 Working Example; 3.3 Finding Regions; 3.4 Reporting Region Boundaries; 3.
5 Limiting Region Size; 3.6 Ranking Regions by Size; 3.7 Working with Sequences; 3.8 Working with Runs; 3.9 Cumulative Aggregates in Lists; 3.10 Implementing a Stack; 3.11 Implementing Queues; 3.12 Implementing Priority Queues; 3.
13 Comparing Two Rows in an Array; 3.14 Printing Matrices and Arrays; 3.15 Transposing a Matrix; 3.16 Calculating a Matrix Trace; 3.17 Comparing Two Matrices for Size; 3.18 Adding and Subtracting Matrices; 3.19 Multiplying Matrices;Chapter 4: Hierarchies in SQL; 4.1 Types of Hierarchies; 4.
2 Creating a Permission Hierarchy; 4.3 Changing Individual Permissions; 4.4 Adding New Individual Permissions; 4.5 Centralizing Authorization Logic; 4.6 Implementing General Hierarchies; 4.7 Traversing Hierarchies Recursively; 4.8 Manipulating Hierarchies Recursively; 4.9 Aggregating Hierarchies; 4.
10 Preparing Multilevel Operations; 4.11 Aggregating Hierarchies Revised;Chapter 5: Temporal Data; 5.1 Introduction; 5.2 The Schedules Example; 5.3 Enforcing Granularity Rules; 5.4 Storing Out-of-Range Temporal Values; 5.5 Deriving the First and Last Dates of the Month; 5.6 Printing Calendars; 5.
7 Calculating Durations; 5.8 Reporting Durations; 5.9 Querying Periods; 5.10 Querying Periods and Respecting Granularity; 5.11 Finding Available Periods; 5.12 Finding Common Available Periods; 5.13 Excluding Recurrent Events; 5.14 Excluding Nonrecurring Events; 5.
15 Finding Continuous Periods; 5.16 Using Calendar Information with Periods; 5.17 Using Calendar Information with Durations;Chapter 6: Audit Logging; 6.1 Audit Logs; 6.2 The Warehouse Example; 6.3 Row-Level Logging; 6.4 Reporting Log Events; 6.5 Generating Current Snapshots; 6.
6 Generating Time-Restricted Snapshots; 6.7 Undoing Table Changes; 6.8 Minimizing Audit-Log Space Consumption; 6.9 Online Account Balancing; 6.10 Activity-Level Logging; 6.11 Partitioning Large Log Tables; 6.12 Server Push;Chapter 7: Importing and Transforming Data; 7.1 Considerations When Importing Data; 7.
2 Working Examples; 7.3 Importing External Data; 7.4 Importing Data into a Live System; 7.5 Importing with a Single Procedure; 7.6 Hiding the Import Procedure; 7.7 Folding Tables; 7.8 Pivoting Tables; 7.9 Joining Arrays with Tables; 7.
10 Joining Arrays with Master Tables; 7.11 Joining Arrays with Multiple Master Records; 7.12 Extracting Master Records from Tables; 7.13 Generating Master Records Online; 7.14 Working with Duplicates;Chapter 8: Statistics in SQL; 8.1 Statistical Concepts; 8.2 The Light-Bulb Factory Example; 8.3 Calculating a Mean; 8.
4 Calculating a Mode; 8.5 Calculating a Median; 8.6 Calculating Standard Deviation, Variance, and Standard Error; 8.7 Building Confidence Intervals; 8.8 Calculating Correlation; 8.9 Exploring Patterns with Autocorrelation; 8.10 Using a Simple Moving Average; 8.11 Extending Moving Averages;Appendix A: The T-Distribution Table;Colophon;.