Skip to content
SQLFree

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.

What you will leave with

By the end, you can inspect a relational schema and write multi-table queries without treating SQL as memorized syntax.

Modules
4
Duration
~10 hours
Level
Beginner
Access
Free course
  • Animated JOIN operations
  • Live SQL playground
  • No prerequisites

What you will be able to do

What this course prepares you to do.

The curriculum is organized around these 4 practical outcomes.

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

Course map

One connected route through SQL Fundamentals.

4 modules / ~10 hours

Curriculum

Every module earns the next one.

Open a module to inspect every section before you start. Your progress follows you through the course.

01
Module 1

Database Fundamentals

BeginnerFree

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

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

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

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.

Start with the background you have. The prerequisite notes above tell you exactly what is assumed.

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.

Module 1 introduces 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