Loading...

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

See path

5 lessons

25 practices

2 hours

Data Analysis for Insights

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

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.

From our community

Hear what our customers have to say about CodeSignal Learn

I'm impressed by the quality and can't stop recommending it. It's also a lot of fun!

Francisco Aguilar Meléndez

Data Scientist

+11

I love that it's personalized. When I'm stuck, I don't have to hope my Google searches come out successful. The AI mentor Cosmo knows exactly what I need.

Faith Yim

Software Engineer

+14

It's an amazing product and exceeded my expectations, helping me prepare for my job interviews. Hands-on learning requires you to actually know what you are doing.