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.

Browse Lessons (read-only)

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 47,218 students in the Learn SQL course

Read reviews of their learning experiences

Great for new learners

(5/5)
Hanssel Nuñez profile image

Hanssel Nuñez

Managua

This is a very good course for begginers. As with other courses it was very intuitive and kept always wanting to come back for the next lesson.

(4/5)
Muhammad Usman Hussain profile image

Muhammad Usman Hussain

Mannheim, Germany

Very easy to follow and concepts were well explained. When there were aspects of the lesson I didn't understand I used their built-in AI chatbot to help me simplify explanations with examples which further enriched the learning experience.

(5/5)
Esther Devadas profile image

Esther Devadas

United States

As a professional software engineer with 2 years of experience, this was a bit rudimentary. I would love more. Basics like ACID was not covered. I think there could be a second course focused on interview prep in which you practice a lot of sql queries--getting into stuff like Window Functions. And another course getting deeper on real world developer problems and integration of sql databases. I would love to see an example of how to use the the EXPLAIN function to debug or optimize a query

(4/5)
CamillevanGinkel  profile image

CamillevanGinkel

Salt Lake City, UT

That's a very good course

(5/5)
Mohamed El-Abiad profile image

Mohamed El-Abiad

Egypt

big up ting

(5/5)
Abdullah Shahad profile image

Abdullah Shahad

Bangladesh

Bootdev continues to put my college courses to absolute shame. Very nice stuff!

(5/5)
Isaac Rosdail profile image

Isaac Rosdail

Asgard, Yggdrasil

Good course, could've had more practical implementations of creating a database from scratch.

(4/5)
Nofil Khan profile image

Nofil Khan

Pakistan

Great course, I was already very familiar with SQL but this course really got me to tie everything together.

(5/5)
Eduard  profile image

Eduard

Romania

Showing 1-9 of 563

Browse Lessons (read-only)

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.