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

Learn SQL

An interactive online course

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 material

113 challenges

and quizzes

Certificate

of completion

A key part of the

back-end career path

Avoid tutorial hell

by writing a ton of code

Learn flexibly online

without interrupting your life

What will you learn?

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

Taught By

Lane Wagner
Allan Lires

Lane and Allan have 18+ years of coding experience between them. Lane is a senior back-end engineer who has worked as a hiring manager and head of engineering. He is the founder and lead instructor of Boot.dev.