Batting Location Charts with Vagrant and MySQL

Description

In this course, you will learn:-

• On an Ubuntu system, instal MySQL.
• In MySQL, perform basic administration activities.
• To modify the MySQL configuration file, use the vi program.
• Vagrant can be used to forward ports.
• PITCHf/x hit location data can be scraped.
• R can be used to query MySQL.

Syllabus:-

• Creating the Virtual Machine
• Installing MySQL
• Logging in and out of MySQL
• Creating a User
• Granting Privileges
• Changing the Bind Address
• Forwarding the Port
• Loading the R Packages
• Scraping the Data
• Investigating the Tables
• Deciding What Information We Want
• Making the Query
• Modifying the Data Frame
• Beginning the Plot
• Enhancing the Plot
• Getting More Data
• Putting It All Together