SQL Programming
A lightweight execution-visualization book.
Tables and Select
Create and Insert
Select Columns
Where and Order
Case Labels
Aggregates
Count and Sum
Group By
Having
Joins
Inner Join
Left Join
Join Then Filter
Data Changes
Insert Rows
Update Rows
Delete Rows
Subqueries and CTEs
Scalar Subquery
IN Subquery
CTE
Constraints and Indexes
Primary Key
Unique Constraint
Index Plan