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.
Lessons and practices
Counting Rows in SQL
Counting Rows in Matches Table
Fix the SQL Query
Counting Rows in a Table
Counting Unique Competitions
Extracting Season IDs Query
Finding Unique Season IDs
Fix the Unique Season Query
Unique Match Venues Retrieval
Unique Season Identification Task
Summing Events by Clubs
Summing Events by Season
Fix the Aggregate Function Query
Summarize Events by Club
Mastering SQL Aggregate Functions
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
Fix SQL Aggregation Query
Fix the Aggregate Query
Calculate Average Trophies Won Per Season
Calculate Total Trophies Won
Aggregate Seasonal Trophies
Interested in this course? Learn and practice with Cosmo!
Practice is how you turn knowledge into actual skills.