Skip to content
Data foundationsFree

Write useful SQL from your first lesson.

SQL Fundamentals

Build a reliable mental model for relational data, then use SELECT, filtering, aggregation, and JOINs to answer real questions in a live SQL editor.

Course map

One sequence, from foundation to finish.

4 connected modules
What you will be able to do

Leave with capability, not just vocabulary.

Read a relational schema and follow keys between tables

Filter, sort, and calculate values with SQL expressions

Summarize data with GROUP BY and aggregate functions

Join related tables and validate the resulting rows

Running example

Bean & Brew, a coffee-shop dataset whose customers, products, and orders grow with each module.

Prerequisites

None. The course starts with tables, rows, columns, keys, and NULL.

Curriculum

Every module earns the next one.

Open any module to review its exact sections. Progress and completion follow you through the course.

4 modules · ~10 hours
01
Module 1

Database Fundamentals

BeginnerFree

Topics include What is a Relational Database?, Tables, Rows, and Columns, Understanding Data Types, and more.

View 6 sections
  1. 1What is a Relational Database?
  2. 2Tables, Rows, and Columns
  3. 3Understanding Data Types
  4. 4The Mystery of NULL
  5. 5Keys: The Magic That Connects Tables
  6. 6Common Mistakes to Avoid
155 min6 sections
Open module
02
Module 2

Filtering & Sorting Data

BeginnerFree

Topics include Your First Query: SELECT & FROM, Filtering with WHERE, Combining Filters: AND, OR, NOT, and more.

View 7 sections
  1. 1Your First Query: SELECT & FROM
  2. 2Filtering with WHERE
  3. 3Range & List Filtering: BETWEEN and IN
  4. 4Combining Filters: AND, OR, NOT
  5. 5Handling NULL Values
  6. 6Pattern Matching with LIKE
  7. 7Sorting, Limiting, and Uniqueness
150 min7 sections
Open module
03
Module 3

Aggregating & Summarizing Data

BeginnerFree

Topics include Aggregate Functions: COUNT, SUM, AVG, Grouping Data with GROUP BY, Filtering Groups with HAVING.

View 5 sections
  1. 1Aggregate Functions - The Aggregation Engine
  2. 2COUNT Deep Dive: Three Ways to Count
  3. 3Grouping Data with GROUP BY
  4. 4NULL Behavior in Aggregates
  5. 5Filtering Groups with HAVING
150 min5 sections
Open module
04
Module 4

Joining Tables

IntermediateFree

Topics include INNER JOIN, LEFT JOIN, RIGHT JOIN & FULL OUTER JOIN, and more.

View 5 sections
  1. 1Understanding All Four JOIN Types
  2. 2SELF JOIN
  3. 3CROSS JOIN
  4. 4Multi-Table Joins
  5. 5Set Operations - UNION, INTERSECT, EXCEPT
150 min5 sections
Open module
Who this course is for

Built for people who need to use the skill.

01

Complete SQL beginners

02

Spreadsheet users moving into analytics

03

Analysts who want a stronger query foundation

Start the course

Begin with Database Fundamentals.

The first module establishes the language and example used throughout the rest of the course.

Open Module 1
SQL Fundamentals Course - Learn SQL from Scratch | Free Interactive Tutorial 2026 | Let's Data Science