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 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 44,960 students in the Learn SQL course

Read reviews of their learning experiences

A great overview of how SQL queries work and how to create/maintain tables

(5/5)
Ben Hubner profile image

Ben Hubner

United States

with the youtube introduction walkthrough, this was fun to do

(5/5)
Clark H profile image

Clark H

United States

Terrific education made terribly fun!

(5/5)
Tony Chinnici profile image

Tony Chinnici

United States

love it

(5/5)
kyler profile image

kyler

Da Nang, Vietnam

Due to PTSD from having to provide support for Google Cloud Bigquery customers with insane SQL queries dozens and dozens of lines long with petabytes of data scattered across storage lake shards across the world, I really REALLY hate dealing with SQL. That being said, this course was surprisingly breezy and over with quickly. I'd still rather reach for a NoSQL solution if I can help it, but maybe that's just the devops engineer in me coming out.

(4/5)
Garrett Anderson profile image

Garrett Anderson

United States

SQL was my first real jaunt into programming and this course made it feel like I actually had a chance at learning the material. 10/10 would recommend.

(5/5)
Jesse Dias profile image

Jesse Dias

United States

nice

(5/5)
Berry Smoothie profile image

Berry Smoothie

Kazakhstan

noice!!!!

(5/5)
Ambuj Seth profile image

Ambuj Seth

Lucknow, India

One of the best things I like about the course is that it levels up your skills in every exercise with the necessary knowledge.

(5/5)
Raj Kumar Sunar profile image

Raj Kumar Sunar

United Kingdom

Showing 1-9 of 541

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