Basics
6
Structuring Queries
The Data Analyst SQL Cookbook
Preface
Introduction
Meet the Data
Meet the Tools
Basics
1
OLTP vs. OLAP
2
Selecting Tables
3
Joining Tables
4
Window Functions
5
Filtering Tables
6
Structuring Queries
7
Schemaless Tables
8
Anti-Patterns
Models
9
Types of Models
10
Calendar Date Dimension
11
Factless Fact Tables
12
Ragged Depth Hierarchies
Recipes
13
Splitting Time Intervals
14
Querying Intersecting Dates
15
Pivoting and Unpivoting
16
Grouping consecutive rows
17
finding-gaps-in-ordered-data
18
Occupancy
19
Qualifying Events in Time
References
Table of contents
7
Subqueries
8
Common table expressions
9
Recursive CTEs
Report an issue
Basics
6
Structuring Queries
6
Structuring Queries
7
Subqueries
8
Common table expressions
9
Recursive CTEs
5
Filtering Tables
7
Schemaless Tables