Skip to content
Play · 45 min

Data · SQL for product teams

Reading a database with SELECT

Lesson 1 of 4 · 45 min · with Lucía Moreno

Tables, rows and your first queries against a real product database.

A database is a set of tables, and a table is a spreadsheet with strict rules. If you know spreadsheets, you already know half of SQL.

Your first query

SELECT name, created_at
FROM users
WHERE plan = 'pro'
ORDER BY created_at DESC
LIMIT 20;

We read that query word by word, then change it to answer five small questions about the note-taking app’s users.