Sports teams collect data, a ton of it. In order to make this data readily accessible, they usually store it in large structured databases. Data scientists and analysts are able to pull this data by using Structured Query Language (SQL).
If you want a job in sports analytics, you should at least have a basic understanding of SQL. More than likely, you will be working with this skill-set every day on the job.
I put together the following video to help you learn the basics of SQL for data science or sports analytics. In the video we use Microsoft SQL Server to host our database and we use Microsoft SQL Server Management Studio to write our queries. We spin up Lahman’s Baseball database and perform a few of the different types of queries that you would use on the job.
You will learn:
- Basic SQL Clauses (SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY)
- Modifiers
- Aggregation
- Joins
- Subqueries
- Views
