Learning SQL Joins with Taylor Swift

Journey into SQL with Taylor SwiftLearning SQL Joins with Taylor Swift

Dive into the world of SQL Joins guided by the unforgettable hits of Taylor Swift. This course is designed to expand your data analysis skills by exploring the concept of table joins. With Taylor's discography as a backdrop, learn how to uncover intricate relationships within a database. This course blends the love for music with the thrill of data discovery.

Lessons and practices

Lesson 1: Joining the Charts: Exploring SQL JOINs

Exploring All Entries in the Songs Table

Filter Songs by their Popularity

Debugging SQL Queries for Song Duration Filtering

Discovering Danceable Tracks

Top 5 Most Popular Songs

Lesson 2: Linking Albums to Songs with INNER JOIN

First SQL Join: Albums and Songs

Sorting the Discography with SQL JOINs

Spot and Fix the SQL Bug

Adding Conditions with SQL INNER JOIN