Skip to content

CoursesData

SQL for product teams

Query your product's database yourself, from the first SELECT to a weekly dashboard.

Level
Intermediate
Lessons
4
Time
3 h 40 min
Teacher
Lucía Moreno
Enrol for $79Watch lesson one free →
Lucía Moreno, Data analyst in Valencia

What you will learn.

  1. 01Read any table with SELECT, WHERE and ORDER BY
  2. 02Combine tables with joins without getting lost
  3. 03Measure funnels and retention with GROUP BY
  4. 04Turn your queries into a dashboard you check every week

We query the database of a fictional note-taking app with ten thousand users. Every lesson starts from a question a product team would ask on a Monday morning and ends with the query that answers it.

You should be comfortable with spreadsheets. No programming is needed.

Who it's for

  • Product managers and designers who wait on the data team
  • Analysts moving from spreadsheets to databases

The curriculum.

4 lessons, 3 h 40 min in total. The first 2 are free to watch.

  1. 01Reading a database with SELECTTables, rows and your first queries against a real product database.45 min Free
  2. 02Joins without the fearCombine users, notes and payments into one answer, and know which join to use.1 h Free
  3. 03Grouping, counting and funnelsGROUP BY, COUNT and date functions to measure signups, activation and retention.1 h Locked
  4. 04From queries to a weekly dashboardSave your queries, chart them, and build the dashboard you check every Monday.55 min Locked
Lucía Moreno, Data analyst in Valencia

Your teacher

Lucía Moreno

Data analyst, Valencia

Lucía is the lead analyst at a travel company in Valencia, where she answers product questions with Python and SQL every day. She taught maths in a high school for six years before moving into data.

That shows in her lessons: one idea at a time, real datasets, and no formula without a reason for it.

More from Lucía →

This course

$79

Pay once, keep it for life

  • All 4 lessons of SQL for product teams
  • Exercise files and source code
  • Every future update, free
Enrol for $79

All access

$349

Every course, and every new one

Learning more than one thing? All access costs less than four courses bought one by one.

Compare plans

Questions, answered.

  • How long do I have access?

    For life. You pay once and keep the course, including every update.

  • Do I need to install anything?

    Only what the first lesson lists, and it is all free. Each lesson notes any tools it uses.

  • Is there a certificate?

    No. We would rather you leave with a finished project you can show than a PDF.

  • What if it isn't for me?

    Write to us within 14 days and we refund you in full.

Keep going.

More courses that pair well with this one.