Skip to content
LDS Logo
LDS

SQL Fundamentals

Free

Query, filter, aggregate, and JOIN — the core of SQL — on the Bean & Brew coffee-shop dataset, with animated explanations and in-browser practice.

4 modules · Free with a (free) account.

View the full course

What this course covers

A module-by-module concept outline. Open the course to learn each topic with animated explanations, in-browser code, practice challenges, and a knowledge check.

Module 1. Database Fundamentals

Topics
What is a Relational Database?Tables, Rows, and ColumnsUnderstanding Data TypesKeys: Primary & Foreign
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

Module 2. Filtering & Sorting Data

Topics
Your First Query: SELECT & FROMFiltering with WHERECombining Filters: AND, OR, NOTPattern Matching with LIKESorting Results: ORDER BYRemoving Duplicates: DISTINCTLimiting Results with LIMIT
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

Module 3. Aggregating & Summarizing Data

Topics
Aggregate Functions: COUNT, SUM, AVGGrouping Data with GROUP BYFiltering Groups with HAVING
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

Module 4. Joining Tables

Topics
INNER JOINLEFT JOINRIGHT JOIN & FULL OUTER JOINJoining Multiple TablesUNION vs UNION ALL
Sections
  1. 1Understanding All Four JOIN Types
  2. 2SELF JOIN
  3. 3CROSS JOIN
  4. 4Multi-Table Joins
  5. 5Set Operations - UNION, INTERSECT, EXCEPT

Ready to start SQL Fundamentals?

Free with a (free) account — sign in and start learning.

Go to the course

All course syllabi

SQL MasterySQL Window FunctionsPython FundamentalsPandas FundamentalsStatistics for Data ScienceProbability for Data ScientistsMachine Learning Fundamentals (scikit-learn)A/B Testing & ExperimentationLLM Foundations