This is my personal SQL learning journal from the Masterschool Data Analytics program. It includes hands-on exercises, challenges, and practice notebooks organized by sprint. Each notebook reflects a different stage in my learning journey—from basic queries to advanced data manipulation.
Learn the basics of SQL, including query structure and filtering data. Understand how to apply conditions and multiple filters to refine queries.
| Notebook | Type | Topic | Dataset(s) |
|---|---|---|---|
| Notebook 01 | Lecture | Introduction to SQL | Chinook |
| Notebook 02 | Lecture | SQL Practice | British Airways |
| Notebook 03 | Challenge | British Airways I | British Airways |
Work with aggregations to summarize data effectively. Learn how to create custom columns and apply sorting techniques.
| Notebook | Type | Topic | Dataset(s) |
|---|---|---|---|
| Notebook 04 | Lecture | SQL Practice | Chinook |
| Notebook 05 | Lecture | Aggregation | Chinook |
| Notebook 06 | Lecture | Group by | Chinook |
| Notebook 07 | Lecture | Intro to JOINS | Chinook |
| Notebook 08 | Challenge | Meta Revenue I | Meta |
| Notebook 09 | Challenge | Meta Revenue II | Meta |
| Notebook 10 | Challenge | British Airways II | British Airways |
Master JOIN operations to combine columns from different tables. Use UNION operations to merge datasets.
| Notebook | Type | Topic | Dataset(s) |
|---|---|---|---|
| Notebook 11 | Lecture | JOINS: A Closer Look | Chinook |
| Notebook 12 | Lecture | UNION, EXCEPT & INTERSECT | Chinook |
| Notebook 13 | Lecture | SQL Practice | Chinook |
| Notebook 14 | Lecture | Business Cases | Nike |
| Notebook 15 | Challenge | Nike I | Nike |
| Notebook 16 | Challenge | Nike II | Nike |
Sprint 4 centers around the Unicorn Project, a multi-part case study that integrates SQL, spreadsheets, and Tableau to simulate real-world data analytics work. The full Unicorn Project is documented in a separate repository: Unicorn Performance Analysis.
This sprint also includes targeted practice notebooks focused on core SQL concepts.
| Notebook | Type | Topic | Dataset(s) |
|---|---|---|---|
| Notebook 17 | Challenge | British Airways III | British Airways |
| Notebook 18 | Challenge | Meta Revenue III | Meta |
| Notebook 19 | Challenge | Nike III | Nike |
Work with multiple joins to extract and combine information from different sources. Develop strategies for structuring complex queries effectively.
| Notebook | Type | Topic | Dataset(s) |
|---|---|---|---|
| Notebook 20 | Lecture | Multiple Joins | Advanced British Airways |
| Notebook 21 | Lecture | Left Join & Missing Keys | Advanced British Airways |
| Notebook 22 | Lecture | Subqueries | Advanced British Airways |
| Notebook 23 | Lecture | SQL Practice | Chinook |
| Notebook 24 | Exercises | Multi Joins in Actions | Advanced British Airways |
| Notebook 25 | Challenge | British Airways I | Advanced British Airways |
| Notebook 26 | Challenge | British Airways II | Advanced British Airways |
Handle messy text data, date manipulation, and numerical transformations. Learn how to use WITH statements and subqueries for better query organization.
| Notebook | Type | Topic | Dataset(s) |
|---|---|---|---|
| Notebook 27 | Lecture | Handling Messy Data Pt 1 | Advanced Meta |
| Notebook 28 | Lecture | Handling Messy Data Pt 2 | Advanced Meta |
| Notebook 29 | Lecture | Windows Functions | Advanced Nike |
| Notebook 30 | Lecture | WITH Statements & CTEs | Advanced Nike |
| Notebook 31 | Exercises | WITH Statements & Subqueries | Advanced Nike |
| Notebook 32 | Challenge | Meta I | Advanced Meta |
| Notebook 33 | Challenge | Nike I | Advanced Nike |
| Notebook 34 | Challenge | Meta II | Advanced Meta |
| Notebook 35 | Challenge | Nike II | Advanced Nike |
| Notebook 36 | Challenge | Nike III | Advanced Nike |