Course 1 of 6 on the Data Analyst path
SQL for analysts and developers
Query data with SQL: SELECT, joins, grouping, subqueries, NULLs, window functions and CTEs, then indexes, transactions, normalisation and isolation levels.
- 14 lessons
- About 107 min reading
- Beginner to intermediate
- Updated 13 Nov 2026
After this course you can
- Write SELECT queries with filters, sorting and NULL-safe logic
- Combine tables with inner, left and self joins and avoid duplicate-row traps
- Summarise data with GROUP BY, HAVING and subqueries
- Rank, compare rows and build running totals with window functions and CTEs
- Read an index and a query plan, and explain why a query is slow
- Explain transactions, ACID, isolation levels and normalisation in an interview
Before you start: nothing. Python is not needed. A free PostgreSQL or MySQL install is enough to try every example.
Lessons
Querying one table
Combining tables
Summarising data
Window functions and CTEs
SQL for applications
Database theory for interviews
Know it, or think you know it?
Take a free mock interview on SQL for analysts and developers for Data Analyst: 3 questions, a score and feedback on each, in about 10 minutes.