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.

Illustration for your journey at Stellar Sound Records

Your Learning Journey

Module 1

SELECT, DISTINCT, FROM, ORDER BY

5 Lessons

It's your first week at Stellar Sound Records, and you're eager to prove yourself. Your manager hands you a login to the music database and says, 'Let's see what you can do!' Time to dig into the data and show them you've got star potential—even behind the scenes.

Tables in lessons

top_songs
Module 2

WHERE Statements

5 Lessons

Now that you've mastered the basics, you're trusted with more specific tasks. The team needs help finding songs for marketing campaigns, playlists, and artist highlights. You're learning that asking the right questions—just like writing a hit song—is everything.

Tables in lessons

top_songs
Module 3

Advanced WHERE Statements

5 Lessons

The work is getting more detailed. You're analyzing patterns, filtering across different dates and keywords, and helping teams curate niche content. Every new skill gets you closer to understanding how data drives decisions in the music industry.

Tables in lessons

top_songs
Module 4

Aggregates and Group By

5 Lessons

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

top_songs
Module 5

Changing Data

5 Lessons

The label is launching a new artist scouting program, and you're the first to get the chance to build the database from scratch. You'll create tables, insert rows, update records, and delete data—all the skills you've learned so far, in practice.

Tables in lessons

new_artists
Module 6

Practice: Putting It All Together

5 Lessons

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

top_songs
Module 7

Joins: Chart Data Meets Label Metadata

5 Lessons

The team needs help finding songs for marketing campaigns, playlists, and artist highlights. You're learning that asking the right questions—just like writing a hit song—is everything.

Tables in lessons

album_infotop_songs
Module 8

Data Transformations

5 Lessons

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

album_infotop_songs
Module 9

Filtering and Reporting with Joins

5 Lessons

The catalog keeps growing, and teams need faster answers from their data. You’re learning how to combine tables, filter the right rows, and build reports that help Stellar Sound make decisions quickly.

Tables in lessons

album_infotop_songs
Module 10

Reporting with CASE and HAVING

5 Lessons

You're not just answering questions anymore—you're shaping the stories Stellar Sound tells. Your reports power newsletters, marketing posters, and the slides leadership shows in boardrooms. A few clever rows of SQL turn into the headlines everyone reads.

Tables in lessons

top_songs

Bonus · AI + data

AI Music Trend Challenge

Launch a Stellar Sound TikTok channel—prompts, four missions, then a launch graphic.

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