The Query Is the New Follow-Up Question

How a Database Is Actually Organized

Reading Your First Query Without Fear

Where PMs Actually Sit Between Dashboards and Raw Data

The Query Lifecycle, From Question to Decision

SELECT, FROM, WHERE: Asking a Precise Question

Filtering and Sorting: WHERE, ORDER BY, LIMIT

Aggregating Data: GROUP BY, COUNT, SUM, AVG

JOINs: Connecting Tables Without Breaking Your Numbers

Common Mistakes That Quietly Give You the Wrong Answer

Funnel Analysis in SQL

Cohort and Retention Queries

Segmenting Users: CASE WHEN and Subqueries

Time-Based Analysis: Dates, Trends, and Comparisons

Sanity-Checking Your Own Query

From Query to Decision: Framing the Ask

Writing a Data Request an Analyst Can Actually Use

When to Write SQL Yourself vs. When to Ask for Help

Window Functions, Explained Without Fear

CTEs: Making Complex Queries Readable

Speaking the Language of Data Teams

SQL and the Modern Data Stack, for PMs

Capstone: Write and Run a Real Product Metrics Query Set

The Brief

The Four Required Deliverables

How You Will Be Assessed

Foundations and Technical Fluency

Product Judgment

Query Construction

Data Quality and Trust

Scenario and Case Style