Data Science & Analytics

9,050 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

Course details

Mastering the COUNT Function

Preview

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

Previous Course Next Course: Advanced Query Techniques and Conditional Logic in SQL

Turn screen time into skills time

Practice anytime, anywhere with our mobile app.

Join the 1M+ learners on CodeSignal

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

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.

Alex Bush

Full Stack Engineer

I'm really impressed by the AI tutor Cosmo's feedback about my code. It's honestly kind of insane to me that it's so targeted and specific.

Abbey Helterbran

Tech consultant

I tried Leetcode but it was too disorganized. CodeSignal covers all the topics I'm interested in and is way more structured.

Jonathan Miller

Senior Machine Learning Engineer

+12

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

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.

Alex Bush

Full Stack Engineer

I'm really impressed by the AI tutor Cosmo's feedback about my code. It's honestly kind of insane to me that it's so targeted and specific.

Abbey Helterbran

Tech consultant

I tried Leetcode but it was too disorganized. CodeSignal covers all the topics I'm interested in and is way more structured.

Jonathan Miller

Senior Machine Learning Engineer

+12

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

Mastering SQL Functions and Clauses with Taylor Swift

Course details

Unit 15 practices19 min

Unit 25 practices19 min

Unit 35 practices19 min

Unit 45 practices19 min

Unit 55 practices19 min

Turn screen time into skills time

Join the 1M+ learners on CodeSignal

From our community

From our community