Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Learn SQL

Go to class Write review

Overview

Stuck in Tutorial Hell? Learn Backend Dev the Right Way

Boot.dev teaches Python, SQL & Go through projects you won't want to stop. 25% off with code CLASSCENTRAL.

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.

Syllabus

Introduction

Learn about the basics of SQL and how it came to be

Tables

Create new tables and learn how to structure data efficiently

Constraints

Learn how to keep data accurate and up to date

CRUD

Create, read, update and delete information from a SQL database

Basic Queries

Practice additional clauses and features that SQL offers for more flexible querying

Structuring

Learn how to order and limit the data returned in large query sets

Aggregations

Learn how to run powerful calculations on entire datasets

Subqueries

Practice the advanced technique of nesting queries inside one another

Normalization

Learn how to normalize a database in order to keep it's data consistent and accurate

Joins

Practice joining multiple tables together in order to power real world usecases

Performance

Learn how to keep databases running fast and efficient in production

Taught by

Lane Wagner, Theo, Allan, Matt, and Hunter

Reviews

4.8 rating at Boot.dev based on 1468 ratings

Start your review of Learn SQL