Udemy

Free R and MySQL Course: Query Baseball Data and Build Hit-Location Charts

Charles Redmond uses baseball hit locations to connect database storage with statistical visualization. R handles analysis and plotting while MySQL stores the records, making the course a concrete example of moving selected data from a database into a chart.

Free learning access

Listed as Free on Udemy when checked on 24 October 2026. No coupon or subscription trial is required for the listed lessons. Enrollment needs a Udemy account; availability can change.

About this course

Charles Redmond uses baseball hit locations to connect database storage with statistical visualization. R handles analysis and plotting while MySQL stores the records, making the course a concrete example of moving selected data from a database into a chart.

The listing contains 18 lectures in two sections and 65 minutes of video. It is intermediate material: the source explicitly says it is not for complete R beginners and recommends familiarity with R and ggplot, ideally from the instructor's preceding baseball-analytics courses.

Official course Batting Location Charts with Vagrant and MySQL
Created by Charles Redmond
Platform Udemy
Language English
Level Intermediate — Udemy listing
Listed duration 65 minutes; 18 lectures across 2 sections
Certificate Not included with a new free enrollment

Skills you’ll gain

  • Describe a workflow linking a local virtual machine, MySQL and R.
  • Understand basic database login, user and privilege tasks in the demonstrated setup.
  • Select data with a query and reshape the resulting data frame for plotting.
  • Use visual encodings to distinguish types of baseball hits on a location chart.

The first section creates an Ubuntu virtual machine, installs MySQL and introduces database administration. It includes editing a configuration file with vi and forwarding a port through Vagrant. The second section loads R packages, obtains PITCHf/x data, investigates tables and decides what information to query before constructing and enhancing the plot.

The visualization lessons distinguish hit outcomes through chart properties and eventually repeat the workflow with more data. This is sports-data analysis, not betting advice. The viewing time is also not the expected project time: the description suggests a relaxed two-week pace for setup, experiments and practice.

The course dates from 2015 and expects R, RStudio, VirtualBox and Vagrant to be installed. Its original data-scraping endpoints and package behavior have not been verified as currently reproducible. R and MySQL Community are freely available; an existing local installation with a small authorized sample dataset can support query-and-plot practice, but it is an adaptation rather than the exact recorded PITCHf/x pipeline.

Keep database experiments isolated from production systems. In particular, the lesson about accepting connections from all IP addresses is not a safe default for an internet-exposed database; restrict access to the local lab and use appropriate permissions. The course also demonstrates deleting a database, so work only with disposable training data and backups. These boundaries matter as much as reproducing the chart.

The R Project: Read about the free environment for data manipulation and graphics. MySQL Community Server: Obtain the community database software and check supported installation options.

Enroll Now ↗

Related courses for your next step

  • Add a related skillFree SQL Course

    Focus: Creating tables and inserting records in a practice database · Filtering rows with conditions and expressions

    Beginner

  • Add a related skillFree Metabase Course

    Focus: Building questions with graphical filters and summaries · Joining tables and adding calculated columns

    Intermediate

Compare course focus, level and study time
Compare the published course outlines. A lower level is a preparation option, not a required prerequisite.
Course Level Focus Study time
This course — Free R and MySQL Course: Query Baseball Data and Build Hit-Location Charts Intermediate Describe a workflow linking a local virtual machine, MySQL and R. · Understand basic database login, user and privilege tasks in the demonstrated setup. · Select data with a query and reshape the resulting data frame for plotting. 65 minutes (Udemy listing)
Free SQL Course: Build Tables, Join Data and Write Subqueries Beginner Creating tables and inserting records in a practice database · Filtering rows with conditions and expressions · Combining related data with joins 108 minutes (Udemy listing)
Free Metabase Course: Questions, SQL and Interactive Dashboards Intermediate Building questions with graphical filters and summaries · Joining tables and adding calculated columns · Using the native SQL query editor 66 minutes (Udemy listing)

Frequently asked questions

Is this an introduction to R from zero?

No. Prior familiarity with R and ggplot is recommended, and the source explicitly excludes complete R beginners from its intended audience.

Is the original baseball-data scraper guaranteed to work today?

No. The older endpoints and packages have not been live-tested. A local sample dataset can support conceptual practice but changes the recorded workflow.

Should I expose MySQL publicly to follow the connection lesson?

No. Keep the exercise inside a controlled local lab and limit access; the tutorial's broad bind-address setting is not a production security recommendation.

Checked on 24 October 2026 using the public course details and syllabus. Coursya has not watched every lesson or tested full playback. New free enrollments do not include a Udemy completion certificate, instructor Q&A or direct messages.

Share this course

Questions & discussion

Share a useful question or correction. Comments appear after moderation. Please avoid personal or sensitive information.

Add to the discussion

Your email address will not be published. Required fields are marked *