Learn SQL
Lane is a back-end engineer and the lead instructor of Boot.dev. He has taught over one million students worldwide.
boot.dev About this 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.
What you'll learn
Chapter 1. Introduction
Learn about the basics of SQL and how it came to be
Chapter 2. Tables
Create new tables and learn how to structure data efficiently
Chapter 3. Constraints
Learn how to keep data accurate and up to date
Chapter 4. CRUD
Create, read, update and delete information from a SQL database
Chapter 5. Basic Queries
Practice additional clauses and features that SQL offers for more flexible querying
Chapter 6. Structuring
Learn how to order and limit the data returned in large query sets
Chapter 7. Aggregations
Learn how to run powerful calculations on entire datasets
Chapter 8. Subqueries
Practice the advanced technique of nesting queries inside one another
Chapter 9. Normalization
Learn how to normalize a database in order to keep it's data consistent and accurate
Chapter 10. Joins
Practice joining multiple tables together in order to power real world usecases
Chapter 11. Performance
Learn how to keep databases running fast and efficient in production
