
Premium
SQL by Ear
1/19/2026
Part One — SQL 101: Retrieving Data
1/19/2026
Lecture One — What SQL Is, and Which SQL You’re Learning
1/19/2026
Lecture Two — Reading Data: SELECT, FROM, and the Shape of a Query
1/19/2026
Lecture Three — Filtering Rows: WHERE and Boolean Logic
1/19/2026
Lecture Four — The NULL Trap: Three-Valued Logic
1/19/2026
Lecture Five — Sorting and Limiting: ORDER BY and LIMIT
1/19/2026
Lecture Six — Data Types and Expressions
1/19/2026
Lecture Seven — Combining Tables: JOIN Fundamentals
1/19/2026
Lecture Eight — More Joins: Self-Joins, Multi-Table Joins, and the Fan-Out Trap
1/19/2026
Lecture Nine — Aggregation: GROUP BY, Aggregates, and HAVING
1/19/2026
Lecture Ten — Putting 101 Together: From a Question to a Query
1/19/2026
Part Two — SQL 102: Reasoning With Data
1/19/2026
Lecture Eleven — Subqueries: Queries Inside Queries
1/19/2026
Lecture Twelve — Common Table Expressions: Writing SQL People Can Read
1/19/2026
Lecture Thirteen — Window Functions I: Row Context and Ranking
1/19/2026
Lecture Fourteen — Window Functions II: Running Totals, Moving Averages, Period-over-Period
1/19/2026
Lecture Fifteen — Conditional Logic and Reshaping: CASE, Conditional Aggregation, and Pivots
1/19/2026
Lecture Sixteen — Dates and Time for Analytics
1/19/2026
Lecture Seventeen — Set Operations: UNION, INTERSECT, EXCEPT
1/19/2026
Lecture Eighteen — Semi-Structured Data: A Practical Look at JSON
1/19/2026
Lecture Nineteen — How Data Is Organized: Keys, Relationships, and Just Enough Normalization
1/19/2026
Lecture Twenty — Changing Data Safely: INSERT, UPDATE, DELETE, and Transactions
1/19/2026
Lecture Twenty-one — Saving Logic: Views and Materialized Views
1/19/2026
Lecture Twenty-two — Making Queries Fast: Indexes and How the Database Thinks
1/19/2026
Lecture Twenty-three — Writing SQL With an AI Assistant: Using Claude and LLMs to Generate, Explain, and Debug Queries
1/19/2026
Lecture Twenty-four — Capstone: From an Ambiguous Question to a Defensible Answer
1/19/2026