Skip to content
Courses

Module 10: Applied Projects

Theory is only half the battle. To truly master SQL, you must apply it to messy, complex, and sometimes mysterious datasets. This final module presents three “Capstone” projects designed to simulate real-world data challenges.

The Projects

Section titled “The Projects”
Project 1: The Detective Solving the SQL Murder Mystery using joins and filtering.
Project 2: The Business Analyst Analyzing churn and revenue for a digital music store.
Project 3: The Data Engineer Building a normalized schema from a raw CSV dataset.

How to Approach These Projects

Section titled “How to Approach These Projects”
  1. Understand the Schema: Before writing code, look at the table relationships.
  2. Modular Logic: Use CTEs to break the problem into smaller pieces.
  3. Verify your Results: Don’t just trust the output. Spot-check a few rows to ensure your math is correct.
  4. Optimize: Once it works, check the execution plan. Can it be faster?