Batting Location Charts with Vagrant and MySQL

Batting Location Charts with Vagrant and MySQL, available at Free, has an average rating of 4.6, with 18 lectures, based on 100 reviews, and has 15609 subscribers.

You will learn about 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. This course is ideal for individuals who are This course is for those who want to learn how to create a hit location chart from PITCHf/x data. or The course is also for those who wish to know a little about working with R and MySQL together. or The course is NOT for complete beginners in R. It is particularly useful for This course is for those who want to learn how to create a hit location chart from PITCHf/x data. or The course is also for those who wish to know a little about working with R and MySQL together. or The course is NOT for complete beginners in R.

Enroll now: Batting Location Charts with Vagrant and MySQL

Summary

Title: Batting Location Charts with Vagrant and MySQL

Price: Free

Average Rating: 4.6

Number of Lectures: 18

Number of Published Lectures: 18

Number of Curriculum Items: 18

Number of Published Curriculum Objects: 18

Original Price: Free

Quality Status: approved

Status: Live

What You Will 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.

Who Should Attend

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.

Target Audiences

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.

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.

Course Curriculum

Chapter 1: Setting up MySQL

Lecture 1: Introduction

Lecture 2: Creating the Virtual Machine

Lecture 3: Installing MySQL

Lecture 4: Logging in and out of MySQL

Lecture 5: Creating a User

Lecture 6: Granting Privileges

Lecture 7: Changing the Bind Address

Lecture 8: Forwarding the Port

Chapter 2: Visualization with R

Lecture 1: Loading the R Packages

Lecture 2: Scraping the Data

Lecture 3: Investigating the Tables

Lecture 4: Deciding What Information We Want

Lecture 5: Making the Query

Lecture 6: Modifying the Data Frame

Lecture 7: Beginning the Plot

Lecture 8: Enhancing the Plot

Lecture 9: Getting More Data

Lecture 10: Putting It All Together

Instructors

Charles Redmond
Professor at Mercyhurst University

Rating Distribution

1 stars: 1 votes
2 stars: 1 votes
3 stars: 9 votes
4 stars: 27 votes
5 stars: 62 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu