TOP SONGS SQL CURRICULUM
Your Story Begins
You dream of becoming a famous singer, and to get your foot in the door, you've landed an internship at one of the world's top music labels: Stellar Sound Records.
As a junior data analyst, you'll use SQL to explore hit songs, uncover trends, and help the label make decisions—all while secretly hoping your name ends up on this list one day.

Your Learning Journey
SELECT, DISTINCT, FROM, ORDER BY
WHERE Statements
Advanced WHERE Statements
Aggregates and Group By
Since you have been doing such great work, you've been promoted from intern to Junior Analyst. You're not just pulling data—you're uncovering insights. Whether it's finding the most popular genres or tracking artist releases, your work is influencing what gets produced, promoted, and played. You're becoming a true data star behind the stars.
Tables in lessons
Changing Data
Practice: Putting It All Together
You've picked up a real toolkit—filtering, sorting, grouping, and crunching numbers—and now your manager wants to see it all in action. The asks aren't simple anymore: they mix a filter here, a count there, a summary at the bottom. This is where the basics start to click as one connected skill.
Tables in lessons
Data Transformations
Raw exports rarely match what stakeholders want to read. You're learning to reshape values in the query itself—swapping bad text for good text, turning numbers into friendly categories, and filling gaps—so every spreadsheet looks intentional before it leaves your desk.
Tables in lessons
Reporting with CASE and HAVING
Bonus · AI + data
AI Music Trend Challenge
Download trend data for Stellar Sound's new TikTok channel, work through simple prompt tips and four missions, then design a graphic with your top three picks.
Open challenge