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