Overview
A complete beginner-to-intermediate SQL course written as a series of posts on this site. Each part builds on the previous, using consistent real-world datasets throughout.
What’s Covered
- Introduction to SQL and Relational Databases
- Basic Queries
- Advanced Operators
- Expressions
- Aggregation Functions
- Multiple Table Queries
- Queries within Queries
- Creating Database Objects
- Maintaining Tables
Datasets Used
All exercises use consistent datasets available for download on each post page.
Tech Stack
- Database — PostgreSQL, MySQL
- Content — Hugo, Markdown