Share 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
