bestcourses is supported by learners. When you buy through links on our website, we may earn an affiliate commission. Learn more

Baseball Database Queries with SQL and dplyr

Explaining the relationship between SQL and dplyr with baseball examples.

4.25 / 5.0
17538 students3 hours 2 minutes

Created by Charles Redmond, offered on Udemy

bestcourses score™

Student feedback

7.1/10

To make sure that we score courses properly, we pay a lot of attention to the reviews students leave on courses and how many students are taking a course in the first place. This course has a total of 17538 students which left 632 reviews at an average rating of 4.25. Impressive!

Course length

9/10

We analyze course length to see if courses cover all important aspects of a topic, taking into account how long the course is compared to the category average. This course has a length of 3 hours 2 minutes, which is pretty short. This might not be a bad thing, but we've found that longer courses are often more detailed & comprehensive. The average course length for this entire category is 5 hours 20 minutes.

Overall score

7.2/10

This course currently has a bestcourses score of 7.2/10, which makes it a great course to learn from. On our entire platform, only 15% of courses achieve this rating!

Description

In this course, we explain the relationship between SQL and the R package dplyr. I will show you how to query a baseball database with SQL in Microsoft Access and then show you how to do exactly the same thing with dplyr in R. We will begin with simple queries, progress to aggregation and grouping, and finish with queries involving joins. By the end of the course, you should be able to use dplyr to explore your own data sets.

At a relaxed pace, it should take about three weeks to complete the course. The course is for beginners in SQL, R, and dplyr. You also do not have to understand very much about baseball. We will be using the Lahman Baseball Database, R, dplyr, and Microsoft Access. I will show you how to install everything.

What you will learn

  • download the Lahman baseball database for Access
  • install dplyr and the Lahman baseball database package in R
  • select, filter, and order with SQL and dplyr
  • group and aggregate with SQL and dplyr
  • perform inner joins with SQL and dplyr

Requirements

  • Students will need to have R and RStudio installed on their own computers. (I will cover how to do this.)
  • It will be best if students also have Microsoft Access, but this is not absolutely necessary.
Udemy logo
Available on

Udemy

With almost 200,000 courses and close to 50 million students, Udemy is one of the most visited online learning platforms. Popular topics include software development, the digital economy, but also more traditional topics like cooking and music.

Frequently asked questions

  • Price: Free
  • Platform: Udemy
  • Language: English
  • 3 hours 2 minutes
Baseball Database Queries with SQL and dplyr thumbnail

bestcourses score: 7.2/10

This course is better than many others in its category.