SQL database code

General information

In this repository you will find all my analytical work related to SQL and visualisation tools such as Power BI or Tableau. The range of topics and datasets is wide, so you can find analytical work from football, healthcare and business.

1. Champions League database - a simple Champions League database covering the seasons from 1991/1992 to 2023/2024. The database contains 7 tables grouped into: teams, squads, seasons, players_list, group_stage, secound_group_stage, knock_out_stage. Each table is describe in a metadata file. The relationship database diagram can be found here

Dataset folder

1. The Champions League dataset contains 7 csv files. The data was obtained from the FBref Champions League website. I cleaned and pre-processed the data into a usable form. The folder also contains: metadata file and database architecture schema.

Project folder

Contains information about the project and additional necessary files.

1. Champions League the historical Europe split - project description and SQL project code

Code folder

Contains MySQL project code

Technology stack

• MySQL
• Visual Code Studio
• Python
• Microsoft Excel
• SQL client - DBeaver

Status

The project is: in progress.