SQL By Ear

Michael Král

This audiobook is narrated by a digital voice. SQL by Ear is a complete spoken course in analytical SQL — twenty-four lectures that carry you from your first database question to the reasoning real analysis demands, with no screen required. Part one...

Premium Chapters

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