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 databases like MySQL, PostgreSQL, and SQLite.

Take Course in Guest Mode
Lane

Author

Lane is a back-end engineer and the lead instructor of Boot.dev. He has taught over one million students worldwide, on Boot.dev, FreeCodeCamp, YouTube and the Backend Banter podcast. Lane worked as a backend engineer writing Go, Python and TypeScript, then moved into engineering management and a couple of years later left to build Boot.dev full-time.

Allan

Maintainer

Sarah

Maintainer

Matt

Maintainer

Hunter

Maintainer

Learn SQL

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

30 Hours

of interactive content

132 Addicting

lessons and quizzes

Earn a certificate

of completion

A key part of

the back-end track

Avoid tutorial hell

by writing a ton of code

Learn online

to not interrupt life

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

Frequently asked Questions

Got questions? We've got answers

It's completely up to you. The time it will take you to be "job ready" will depend on how much you already know, how often you study, and how long you study for. That said, the backend career path takes many people about 12 months.

Absolutely! If you built it, use it. You'll build several personal projects while completing our curriculum, and our final course about finding jobs will show you how to construct a job-ready portfolio.

We're not a $10,000 bootcamp.

We're not a $50,000 university degree.

We are a self-paced, gamified online learning platform for back-end web development. You can learn with us for the price of a gym membership.

You can demo the first few chapters of each course with full interactivity, but after that you'll be in "guest mode" or "read only" mode. In guest mode you won't be able to complete lessons, take quizzes, or do the interactive parts of the courses.

As a paid member you get access to everything.

You can read all about our methodology here. In a nutshell, we're laser focused on teaching backend-development, which is somewhat of a rarity in online learning. We're also focused on solving what we believe is the hardest problem with online learning: boredom.

If you prefer coding rather than watching, and your struggle with online learning is staying motivated and engaged, we think you'll like learning with us.

We absolutely hate dark patterns, so we've made it easy to cancel your subscription any time. You can cancel your membership any time from your settings and you won't be billed again.

If for any reason you feel you aren't getting enough value out of the platform, we don't want your money. We have a simple return policy. Just contact us within 30 days of your purchase you're entitled to a full refund.

Yes! We believe in being as fair as possible to learners around the world, and that means pricing that reflects respective earning power.

If you're seeing pricing in anything other than USD, then you're already seeing discounted pricing for your country. If you're not seeing discounted pricing, but you are from a country with lower purchasing power, please let us know and we'll get you a discount.

Absolutely! We have team plans that let your manager pay for your membership and those of your team, while managing billing all in one place. To get started just check out the teams page. You'll need to be logged in.

For sure, just check out the gifts page. You'll be able to purchase a redeemable code that you can give to a friend.

Enter your code on the redemption page to activate your membership.

This is almost always because your bank is rejecting international transactions (we are based in the United States and use Stripe for payments). You should be able to contact the customer service department of your credit card company or your Bank and get the transactions approved or your card unlocked.