Module
Module 1 of 6Lesson 1 of 1~4 min

Course overview

This SQL for product managers course teaches you to read and design your product's data model, then query it yourself with read-only access. You stop waiting on the data team for routine questions and walk into technical reviews with solid arguments. Everything runs in the browser, with nothing to install.

Take this lesson: your first course is freeSee the full syllabus

Lesson objective

By the end of this overview, you will know what you are going to produce (the data model of a feature and ten SQL queries on your product), which dataset you will practise on and which five modules take you there.

Topics covered

  • SQL for product managers
  • data model
  • SQL queries
  • read-only access
  • data self-service

Where it fits

Overview

What will I be able to do by the end of this course, and in what order?

Lessons in this module

  1. Course overview (this lesson)

What you will learn in the course

This lesson is part of the course Model your product’s data and query it with SQL

  • Read a data model (tables, primary and foreign keys, cardinalities, entity-relationship diagram) and connect it to the product's screens and rules.
  • Model the data of a feature (entities, attributes, relationships, keys, cardinalities) and get the model validated by the engineering team.
  • Compare a relational database and a document (NoSQL) database for a product need and justify the choice based on expected queries, consistency and change.
  • Write queries that filter, sort and aggregate (SELECT, WHERE, ORDER BY, GROUP BY, HAVING) while handling NULL values and dates correctly.
  • Combine several tables with INNER and LEFT joins, and check that the result neither loses nor duplicates any row.
  • Turn a product question into a verifiable query, using CTEs and simple window functions (ROW_NUMBER, LAG, SUM OVER).
  • Query data read-only while protecting personal data, and have an AI draft SQL while checking every query before using its result.

Related courses