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

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.