Data Analytics
4120 learners
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.
MySQL
5 lessons
25 practices
2 hours
Data Analysis for Insights
Lessons and practices
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
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
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
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
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
Meet Cosmo:
The smartest AI guide in the universe
Our built-in AI guide and tutor, Cosmo, prompts you with challenges that are built just for you and unblocks you when you get stuck.

Join the 1M+ learners on CodeSignal
Be a part of our community of 1M+ users who develop and demonstrate their skills on CodeSignal