Online Course Overview

Learn SQL

Learn SQL online through our comprehensive course. Query databases and work with relational data.

32 Lessons in 9 Sections

Beginner

Start Learning Open Workspace

Curriculum

01Introduction

What is SQL?

Learn the basics of SQL and relational databases.

02Reading Data

The SELECT Statement

How to retrieve data from a database.

Filtering with WHERE

Filter your results based on conditions.

AND, OR, NOT

Combine multiple conditions.

Sorting with ORDER BY

Sort your query results.

LIMIT and OFFSET

Restrict the number of rows returned.

Working with NULL

Handling missing data.

Pattern Matching (LIKE)

Search for patterns in text.

The IN Operator

Match against a list of values.

The BETWEEN Operator

Filter within a range.

Aliases (AS)

Rename columns and tables.

03Writing Data

INSERT INTO

Add new records to a table.

UPDATE Records

Modify existing records.

DELETE Records

Remove records from a table.

04Relationships

Introduction to JOINs

Combine data from multiple tables.

INNER JOIN

Get matching records from both tables.

LEFT JOIN

Get all records from the left table.

05Aggregation

GROUP BY

Group rows with the same values.

HAVING Clause

Filter grouped records.

COUNT()

Count the number of rows.

SUM() and AVG()

Calculate totals and averages.

MIN() and MAX()

Find minimum and maximum values.

06Advanced Queries

Subqueries

Queries within queries.

CASE Statement

Conditional logic in SQL.

07Database Schema

CREATE TABLE

Define a new table.

Data Types

Common SQL data types.

Primary Keys

Uniquely identify rows.

Foreign Keys

Enforce relationships.

ALTER TABLE

Modify an existing table.

DROP TABLE

Delete a table entirely.

08Performance

Indexes

Speed up your queries.

09Advanced Concepts

Transactions

Ensuring data integrity.

Explore the SQL Ecosystem

Continue learning SQL

Access all SQL lessons and tutorials.

Practice SQL exercises

Apply your knowledge with interactive coding challenges.

Test your knowledge with SQL quizzes

Check your understanding with multiple-choice questions.

Build SQL projects

Create real-world applications from scratch.

Try SQL in the playground

Write and execute SQL code instantly in your browser.

Browse the SQL reference

Quickly look up syntax, methods, and properties.