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

CodeSignal

Learning SQL Joins with Leo Messi

via CodeSignal

Go to class Write review

Overview

Explore the dynamic world of SQL Joins by analyzing data from Messi's soccer career. This course will demonstrate how to connect different tables to reveal the in-depth narratives of Messi's matches, competitions, and performance MatchEvents.

Syllabus

  • Unit 1: Learning SQL Joins with Leo Messi
    • Change to Find Away Matches
    • Fix Errors in SQL Joins
    • Adding Matchday Condition
    • Find Matches Against French Clubs
    • Joining Tables for Home Matches
  • Unit 2: Exploring INNER JOIN with Messi's Match Data
    • Exploring Matches and Events Relationships with SQL INNER JOIN
    • Filtering and Ordering Matches Data with SQL INNER JOIN
    • Debugging SQL Query to Fetch Specific Matches
    • Filtering Matches by Match date
    • Unveiling the Matches and Events with INNER JOIN
  • Unit 3: Understanding Advanced SQL Joins with Messi's Match Data
    • Exploring Left Joins with Leo Messi's Matches Data
    • Exploring RIGHT JOIN in SQL
    • Correcting the RIGHT JOIN Query
    • Linking Players and Teams with LEFT JOIN
    • SQL Query Using LEFT JOIN to Match Players with Their Teams
  • Unit 4: SQL FULL JOIN Mastery with Messi's Matches
    • Exploring Matches and Match Events
    • Simulating FULL JOIN
    • Full Roster Exploration with SQL Full Join
    • Emulating FULL JOIN in PostgreSQL
    • Full Join in Soccer Data

Reviews

Start your review of Learning SQL Joins with Leo Messi

Go to class

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.