Load the dataset and write your first SELECT queries
Writing your first SQL queries means getting a factual answer without filing a ticket with the data team. You set up a SQLite environment in minutes, explore how the tables are structured, then select, filter and sort rows. A solid footing for every product question that follows.
Lesson objective
By the end of this lesson, you will be able to load the Atelio dataset into SQLite (in the browser or locally), explore the structure of the tables and write SELECT queries that pick columns, filter with WHERE, sort with ORDER BY and limit with LIMIT.
Topics covered
- SQL queries
- SELECT
- WHERE
- ORDER BY
- SQLite
In the glossary
Where it fits
First queries
How do I get a reliable number from a table myself, without being caught out by missing values and dates?
Lessons in this module
- Load the dataset and write your first SELECT queries (this lesson)
- Count, sum, group
- Missing values and dates, two traps that produce wrong numbers
What you will learn in this module
This lesson is part of the course Model your product’s data and query it with SQL
- Write queries that filter, sort and aggregate (SELECT, WHERE, ORDER BY, GROUP BY, HAVING) while handling NULL values and dates correctly.
Related courses
- Product ManagementAdvancedRegular practice: you already use the tools or work on this topic.
Git for PMs: ship as a team without putting production at risk
3 hr 30 min
- Tech for PMsAll levelsNo prerequisites: accessible to everyone.
Explain how a web product works, from browser to server
2 hr 30 min
- Tech for PMsJuniorSome basics are useful: introductory knowledge of the topic.
Design and test an API integration as a PM
3 hr