Loading...

Data Analytics

752 learners

Mastering SQL Functions and Clauses with Leo Messi

Take your SQL expertise to the next level by harnessing the power of SQL functions. Using data from Messi's career, this course delves into advanced SQL functions and clauses, helping you summarize, count, and differentiate data to gain deeper insights into soccer datasets.

MySQL

See path

5 lessons

25 practices

2 hours

Data Analysis for Insights

Lessons and practices

Lesson 1: Mastering the COUNT Function

Counting Rows in SQL

Counting Rows in Matches Table

Fix the SQL Query

Counting Rows in a Table

Counting Unique Competitions

Lesson 2: Utilizing DISTINCT for Uniqueness Exploration

Extracting Season IDs Query

Finding Unique Season IDs

Fix the Unique Season Query

Unique Match Venues Retrieval

Unique Season Identification Task

Lesson 3: Mastering the SUM Function for Aggregate Calculations

Summing Events by Clubs

Summing Events by Season

Fix the Aggregate Function Query

Summarize Events by Club

Mastering SQL Aggregate Functions

Lesson 4: Analyzing Trends with GROUP BY

Exploring Seasonal Team Performance

Analyzing Seasonal Team Performance

Analyze Team Performance by Seasons

Analyzing Team Match Performance

Counting Events by Match Date for Specific Years

Lesson 5: Applying SQL Aggregate Functions to Soccer Data

Fix SQL Aggregation Query

Fix the Aggregate Query

Calculate Average Trophies Won Per Season

Calculate Total Trophies Won

Aggregate Seasonal Trophies

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.