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.

What will you learn?

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.

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 39,827 students in the Learn SQL course

Read reviews of their learning experiences

Great intro course!

(5/5)
Mick Rubashkin profile image

Mick Rubashkin

Spain

Great course for quickly learning the fundamentals of SQL

(5/5)
Zeke Howey profile image

Zeke Howey

United States

.

(5/5)
Alex Leijen profile image

Alex Leijen

Netherlands

make me a data analysis one pleaseeee

(5/5)
Cherithasilp Sopa profile image

Cherithasilp Sopa

Thailand

Even if you're not interested in backend development, take this course. If you work a desk job, there is a very high chance that SQL is powering something you work on. Knowing how that works unlocks a lot of opportunities to improve your quality of life at work as well as learn a skill that you can put on a resume for anywhere you want to go next.

(5/5)
John McLeish profile image

John McLeish

Australia

Might get tough but that is manageable with countless tries and "sort of brute forcing" haha. Best of luck to you all!

(5/5)
Ruud3 profile image

Ruud3

Estonia

A great course that's easy to understand and feel accomplished while doing it.

(5/5)
Jason Granzow profile image

Jason Granzow

United States of America

Other than SQL and DB fundamentals, the course will teach you to read properly. 10/10 as always.

(5/5)
Musa Abdulrofihi profile image

Musa Abdulrofihi

Nigeria

Don't think twice to join boot.dev if you want to learn coding by getting your hands dirty! ;)

(5/5)
Vivek Mitra profile image

Vivek Mitra

Sydney

Showing 1-9 of 448

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