We're sorry but this app doesn't work properly without JavaScript enabled. Please enable it to continue.

Learn SQL

Get dangerous with relational databases: query, filter, join, and aggregate data without hiding behind an ORM.

What you'll learn in this SQL course

Learn all the basics of Structured Query Language in this comprehensive SQL course. You'll build out real database tables and practice querying them in flexible ways right in the browser. Not only will you understand how to use SQL, but you'll also learn in what situations you should use it. We will cover architectural design patterns and how to use SQL in a production environment.

Chapter List

1
Introduction
Learn about the basics of SQL and how it came to be
2
Tables
Create new tables and learn how to structure data efficiently
3
Constraints
Learn how to keep data accurate and up to date
4
CRUD
Create, read, update and delete information from a SQL database
5
Basic Queries
Practice additional clauses and features that SQL offers for more flexible querying
6
Structuring
Learn how to order and limit the data returned in large query sets
7
Aggregations
Learn how to run powerful calculations on entire datasets
8
Subqueries
Practice the advanced technique of nesting queries inside one another
9
Normalization
Learn how to normalize a database in order to keep it's data consistent and accurate
10
Joins
Practice joining multiple tables together in order to power real world usecases
11
Performance
Learn how to keep databases running fast and efficient in production

Join 60,491 students in the Learn SQL course

Read reviews of their learning experiences

Gamifying led me to a better understanding of the subject matter.

(5/5)
Dannie Walters profile image

Dannie Walters

United States

Great hands-on SQL course. You write real queries from the first lesson instead of just reading about them, and the difficulty builds at a good pace: filtering and aggregates first, then subqueries, joins, normalization, and indexes. The many-to-many and composite key lessons, plus the exercise on why WHERE and HAVING behave differently, made concepts click that I’d only half understood before. Highly recommended if you want SQL you can actually use on the job.

(5/5)
Ramadan Lotfy profile image

Ramadan Lotfy

Egypt, Cairo

Quick and easy to follow, covers most of the basics and provides a nice off-ramp that allows you to carry your studies into more advanced concepts.

(5/5)
Ethan Petta profile image

Ethan Petta

United States

Very nice overview of the basics of SQL, but also database design topics like normalization. Very helpful for any aspiring backend developer.

(5/5)
Radek Novotný profile image

Radek Novotný

Czechia

Quite useful and fun.

(4/5)
Stanley Yeung profile image

Stanley Yeung

Hong Kong SAR China

It's really easy to digest. There are many things I've learned in school that I didn't fully understand until now.

(5/5)
sugarkane  profile image

sugarkane

Vietnam

This was a perfect course, everything was broken into perfect bite sized lessons, the difficulty wasn't merely more work to be done but more interesting logic to be applied

(5/5)
Matthew Rathwell profile image

Matthew Rathwell

United States

easy to understand course by a noob like I

(5/5)
Jan Sajdak profile image

Jan Sajdak

Poland

Incredibly easy to pick up with their step-by-step explanations!

(5/5)
Lundon Kinsolving profile image

Lundon Kinsolving

Land O' Lakes, United States of America

Showing 1-9 of 829

or view more reviews

Mediocrity doesn't cut it anymore

The only way to become a great developer is to write a lot of code

Avoid tutorial hell

by writing a ton of code

Stay motivated with

a game-like curriculum

Build portfolio projects

to prove your skills

Delve deeper

into foundational concepts

Learn flexibly online

without interrupting your life

For 1% the price of college

to minimize your financial risk

Frequently asked Questions

Got questions? We've got answers

Yes. SQL is one of the most self-teachable languages out there because it's small and you get instant feedback on every query. This course has you write SQL against real tables in your browser from the first chapter.