Learning 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
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
First SQL Join: Albums and Songs
Sorting the Discography with SQL JOINs
Spot and Fix the SQL Bug
Adding Conditions with SQL INNER JOIN
Mastering SQL Inner Joins
Running a Left Join between Albums and Songs
Exploring Right Joins with Songs and Albums
Troubleshooting a RIGHT JOIN SQL Query
Joining Songs with Albums using LEFT JOIN
Mastering RIGHT JOIN in SQL
Adding Song Popularity to Album Listing
Exploring Albums and Songs with LEFT JOIN
Join Albums with Songs Using LEFT JOIN
Mimicking FULL JOIN in MySQL
Querying Song and Album Names with SQL JOINs
Adding Missing Attributes to SQL Query
Creating SQL INNER JOIN from Scratch
Combining Three Tables with SQL Inner Join
Joining Tables to Gather Song Details
Interested in this course? Learn and practice with Cosmo!
Practice is how you turn knowledge into actual skills.