Code First Girls - Data & SQL Project - The CrossFit Open

In October 2023 I started an 8-week introductory course for Data & SQL with Code First Girls.

During the course we used MySQL and WorkBench to cover:

• Database creation, structure and management
• Queries with conditions, group by, having & subqueries
• Joins & unions
• Transactions
• Views
• Stored functions & procedures
• Events & triggers
• Data visualisation

I am an enthusiastic CrossFitter, so I built my project database around the CF Open using joins and views to show athletes and gyms how they rank across the workouts and overall. For the final session of the course I submitted my SQL code and presented my project to the group remotely, I used Tableau for the data visualisation that runs alongside snapshots of the actual code.

Final presentation can be viewed here https://docs.google.com/presentation/d/1EQZ7mSnykNyDI5uMbFtXvbWbwlHKMyMBWq8wsBk3nzQ/edit?usp=share_link