Mastering SQL Functions and Clauses with Taylor Swift
Elevate your SQL skills to the next level with the power of SQL functions while exploring Taylor Swift's discography. This course is perfectly crafted for learners who have grasped the basics of SQL and are ready to discover how functions can enhance data analysis and reporting. Dive into the world of counting, summarizing, and unique identifying features of data with a musical twist.
Lessons and practices
Lesson 1: Mastering the COUNT Function
Counting Songs in a Specific Album
Changing Album Selection for Song Count
Solving the Song Count Mystery
Determining Song Count in Specific Album
Counting Songs in Swift's Discography
Lesson 2: Unveiling Uniqueness: Exploring DISTINCT in SQL
Fetch All Track Numbers
Mastering DISTINCT Keyword in SQL
Fixing Distinct Keyword Bug in SQL Query
Fetching Distinct Songs from a Specific Album
Identifying Unique Albums in Discography
Lesson 3: Summing Up Musical Durations with SQL's SUM Function
Total Duration of Songs from a Specified Album
Total Duration of Songs from Specific Album
Fixing a Mistaken SQL Query
Calculating Total Song Duration for a Specific Album
Sums and Songs: Total Album Durations
Lesson 4: Analyzing Trends with SQL's GROUP BY Clause
Grouping Songs by Album ID
Fixing the Group By Bug
Grouping Songs by AlbumID in SQL
Grouping Albums by Release Date
Analyzing Album Trends with SQL
Lesson 5: Mastering Aggregation: Calculating Totals and Averages in SQL
Fixing a Faulty Aggregate Query
Debugging Aggregate Query in SQL
Calculating Average Song Duration per Album
Popularity Aggregate Across Albums
Completing a Comprehensive Aggregate Query
Interested in this course? Learn and practice with Cosmo!
Practice is how you turn knowledge into actual skills.