Udemy
UdemyBaseball Database Queries with SQL and dplyr
4.7(690)19k studentsBEGINNEREnglish
Korshub's take
Learn SQL and dplyr side by side, through one dataset
Rather than teaching SQL and dplyr as separate subjects, this course teaches them in parallel: every query is written first in SQL against Microsoft Access, then rebuilt in R using dplyr, so the connection between the two approaches becomes obvious rather than theoretical.
What's covered
- Simple queries in both SQL and dplyr
- Aggregation and grouping
- Queries involving joins
- Installing and setting up R, dplyr, and Microsoft Access
Who it's for
Complete beginners to SQL, R, and dplyr — no prior baseball knowledge required. The Lahman Baseball Database supplies real, relatable data to query throughout. At a relaxed pace, the material is designed to take about three weeks to work through, ending with the skills to explore your own datasets.
About this course
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.
Price
Free
Advertisement
