SQL for Sports Analytics

sql for sports analytics
sql for sports analytics

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:

  1. Basic SQL Clauses (SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY)
  2. Modifiers
  3. Aggregation
  4. Joins
  5. Subqueries
  6. Views
About Ken Jee 12 Articles
Ken is one of the founders of Playing Numbers. He has worked in sports analytics for the last 5 years focusing primarily on golf and basketball. He founded playing numbers to help others learn about the field he loves.

Be the first to comment

Leave a Reply