Course · Interactive

SQL Foundations

A comprehensive from-zero SQL course — SELECT, filtering, aggregates, joins, subqueries, UNION, and modifying data — 30 lessons of live, auto-graded SQLite queries in your browser.

Who it's for

Complete beginners — no installation. The foundation for data analytics and for pairing SQL with Python or R.

What you'll learn

  • Write SELECT queries with filtering, sorting, and limiting
  • Aggregate with GROUP BY, HAVING, and common functions
  • Join multiple tables with INNER and LEFT JOIN
  • Use CASE, expressions, subqueries, and derived tables
  • Insert, update, delete, and create tables safely

Course contents

  1. 01Getting Started — SELECT, columns, aliases
  2. 02Filtering — WHERE, LIKE, IN, NULL
  3. 03Aggregates — COUNT through HAVING
  4. 04Joins — inner, left, multi-table
  5. 05Subqueries & expressions
  6. 06Modifying data & schema
  7. 07Practice