Databases & SQL Fundamentals

A from-zero course in relational databases and SQL — tables, querying, filtering, joining, and designing a simple schema, one small concept at a time, using real SQLite.

Course content

1. 1. What Is a Database? Why SQL?
2. 2. Creating a Table
3. 3. Inserting Data
4. 4. Glossary
5. 5. Querying with SELECT
6. 6. Filtering with WHERE
7. 7. Sorting and Limiting Results
8. 8. Updating and Deleting Data
9. 9. NULL and Missing Data
10. 10. Aggregate Functions
11. 11. Grouping Data
12. 12. Primary Keys
13. 13. Foreign Keys and Relationships
14. 14. Inner Joins
15. 15. Left Joins
16. 16. Joining Three Tables
17. 17. Designing a Simple Schema
18. 18. Capstone: Building a Small Database