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

Learn SQL

Learn the fundamentals of Structured Query Language (SQL), the most popular way to interact with database systems like MySQL, PostgreSQL, and SQLite.

What will you learn?

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 40,171 students in the Learn SQL course

Read reviews of their learning experiences

It's awesome!

(5/5)
Prathamesh Anvekar profile image

Prathamesh Anvekar

India

awesome, real quick recap

(5/5)
Joseph profile image

Joseph

Argentina

Great for people who are starting out our have fragmented knowledge about backend this puts it all in one place

(5/5)
Sameer Pagar profile image

Sameer Pagar

India

Basic, straightforward and useful. A very good eat-your-vegetables kind of course.

(4/5)
Duncan Watt profile image

Duncan Watt

Canada

Good Intro in SQL

(5/5)
Aleksandre Mesarkishvili profile image

Aleksandre Mesarkishvili

Georgia

I feel like normalization is a bit of a speedrun. For me personally it was little bit more abstract so I needed to invest extra time, but the presenters do a great way of presenting, I just had to reread a lot.

(5/5)
Konstantin Krstić profile image

Konstantin Krstić

Pančevo, Serbia

gut gut

(5/5)
Petr Konopa profile image

Petr Konopa

Czechia

Great!

(4/5)
Stanisław Oziemczuk profile image

Stanisław Oziemczuk

Poland

it's a fun way to learn SQL in a day or two

(5/5)
Utsav Shankar profile image

Utsav Shankar

Singapore

Showing 1-9 of 459

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! It's free to create an account and start learning. You'll get all the immersive and interactive features for free for a few chapters. After that, if you still haven't paid for a membership, you'll be in read-only (content only) mode.

Platform

Boot.dev on X/TwitterBoot.dev on YouTubeBoot.dev on LinkedInBoot.dev on InstagramBoot.dev on TikTokBackend Banter Podcast

Languages

Subjects

Support

Pricing

Community

boot.dev
© Boot.dev