Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

CodeSignal

Mastering SQL Functions and Clauses with Leo Messi

via CodeSignal

Overview

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.

Syllabus

  • 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

Reviews

Start your review of Mastering SQL Functions and Clauses with Leo Messi

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.