Based on Alan Beaulieu’s Learning SQL, 3rd Edition (O'Reilly Media 2020)
Learning Basic SQL
Query Primer
Filtering
Querying Multiple Tables
Working With Sets
Data Generation, Manipulation, and Conversion
Grouping and Aggregates
Subqueries
Joins Revisited
Conditional Logic
Transactions
Indexes and Constraints
Views
Metadata
Analytic Functions
Working with Large Databases