Loading...

Data Analytics

754 learners

Getting Started with SQL with Leo Messi

Dive into the fascinating world of SQL using soccer legend Leo Messi's illustrious career data as your playground. This course will help you master SQL from the ground up, teaching you how to query databases effectively, uncover hidden patterns, and drive insightful data analysis.

MySQL

See path

5 lessons

26 practices

2 hours

Data Querying and Retrieval

Lessons and practices

Lesson 1: Introduction to Databases, SQL and Writing First Query

Running Your First SQL Queries

Unveiling all Records from a Seasons Table

Unveiling Specific Season Details

Unveiling the database's tables

Exploring Database Tables with SQL

Lesson 2: Navigating the SQL SELECT Statement

Selecting Specific Columns in SQL

Select and Rename Columns

Fix the SQL Query

Renaming Columns with SQL

Navigating Advanced SQL Queries

Lesson 3: Application of WHERE Clause

Select Matches After 2005

Selecting Specific Matches Using SQL

Filtering Soccer Matches Effortlessly

Fix the SQL Query Bug

Selecting Matches by Year

Lesson 4: Mastering SELECT Statements with Logical Operators

Refine Match Data Selection

Refine Your SQL Queries

Refine Match Data Selection

Fetch Match Events by Duration

Fetch Messi's Matches

Lesson 5: Understanding ORDER BY Clause for Sorting Data

Ordering Match Results by Date

Sorting Match Records by ID

Sorting Match Results Ascending

Sort Match Results Numerically

Sorting Match Results Correctly

Sorting Match Data by Date

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.