SQL Masterclass

Training Ground Guru is the go-to destination for insights into the teams behind the teams in professional football. We provide training and insights from experts working in professional football.

Training Ground Guru

Our SQL for Data Analysis Masterclass will provide an introduction to accessing and manipulating datasets in the context of football and player performance.Data is valuable and SQL (Structured Query Language) makes navigating it a lot easier. SQL (often pronounced sequel) is a programming language that communicates with databases and is essential for anyone looking to get away from clunky Excel-based reporting and fully utilise Big Data.Whether this data is stored in a local database, SQL server or in the cloud, the language will help you to store, retrieve, manage and manipulate data.This course will provide a working knowledge of this highly-productive language within a football context. SQL isn’t just for power users of data such as Data Scientists and Data Analysts, it can enable anyone looking to leverage their data to have better access and to find the answers they need. This can include coaches, recruitment analysts, performance analysts, sports scientists, Heads of Recruitment and more. For £30 you will get:Video masterclass delivered by Edd Webster. During two-and-a-half hours (two one hour sessions with a 30-minute break in between), Edd will take you through the application of data analysis with SQL in a follow-along session. This will include:<ul><li>Introduction to the basics of SQL/ explanation of exactly what databases are.</li><li>Key concepts.</li><li>How to create a new database and tables of player performance data. </li><li>Techniques to manipulate data into the form you require by retrieving records in the tables. This includes how to select records, filter for specific conditions, rename fields, join separate datasets based on a unique identifier, order data and group and aggregate based on certain conditions. </li><li>More advanced data management commands, including how to modify an existing database and table, how to delete an entire table or view of a table, and how to insert, modify and delete certain records.</li></ul>In advance of the session you will receive:<ul><li>Data (csv): Two real match datasets including a play-by-play dataset of industry standard event data, as well as an aggregated summary of player stats for the season. </li><li>Code Notes (PDF): The code to use during the session, which can be easily reviewed afterwards in a concise, clear document consolidating the topics discussed.</li><li>Further learning materials: Details of both free and paid tutorials and courses, practice questions and recommended next steps.</li></ul>Edd Webster is a Data Scientist with the LEGO Group with five years’ professional experience of data analysis. Before LEGO, he worked with West Ham and City Football Group, where he helped the clubs leverage their commercial data through analysis.

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

SQL Masterclass

More events from Training Ground Guru

Discover more events from Training Ground Guru, from Sports & Fitness to other experiences you might love.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.

SQL Masterclass

More events from Training Ground Guru

Discover more events from Training Ground Guru, from Sports & Fitness to other experiences you might love.

More Sports & Fitness events

Browse more Sports & Fitness events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.