Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Batting Location Charts with Vagrant and MySQL
Rating: 4.6 out of 5(102 ratings)
15,838 students

Batting Location Charts with Vagrant and MySQL

Use R and MySQL together to create batting location charts from large data sets.
Created byCharles Redmond
Last updated 9/2015
English

What you'll learn

  • install MySQL on a Ubuntu machine.
  • perform basic administrative tasks in MySQL.
  • use the vi program to edit the MySQL configuration file.
  • perform port-forwarding with Vagrant.
  • scrape hit location data from PITCHf/x.
  • query MySQL from R.

Course content

2 sections • 18 lectures • 1h 5m total length

  • Introduction1:03

    In this lecture, I briefly discuss how the course will unfold.

  • Creating the Virtual Machine1:49

    This is a review of the process of installing an Ubuntu virtual machine.

  • Installing MySQL2:39

    After viewing this lecture, you will be able to install MySQL.

  • Logging in and out of MySQL1:13

    After viewing this lecture, you will be able to login and logout of MySQL.

  • Creating a User6:41

    After viewing this lecture, you will be able to create a user in MySQL.

  • Granting Privileges2:12

    After viewing this video, you will be able to grant user privileges in MySQL.

  • Changing the Bind Address5:26

    After viewing this lecture, you will be able to use the vi program to edit the MySQL configuration file to allow MySQL to accept requests from all IP addresses.

  • Forwarding the Port5:12

    After viewing this lecture, you will be able to forward ports via Vagrant.

Requirements

  • Students should have R and RStudio installed.
  • Students should also have VirtualBox and Vagrant installed.
  • It would be best if students have gone through my previous three courses in baseball analytics. This may not, however, be completely necessary.

Description

This course is about working with large sets of PITCHf/x data to create batting location charts. We use R to scrape and visualize the data and MySQL to store the data. The course includes lessons on how to install a virtual Ubuntu machine, how to install MySQL, how to perform basic MySQL administrative tasks, and how to connect R and MySQL.

It would be best if you have some knowledge of R and ggplot. This can be obtained through my previous three courses in baseball analytics. However, it might be possible to follow along without this.

At a relaxed pace, the course should take about two weeks to complete.

Who this course is for:

  • This course is for those who want to learn how to create a hit location chart from PITCHf/x data.
  • The course is also for those who wish to know a little about working with R and MySQL together.
  • The course is NOT for complete beginners in R.

Report abuse