Baseball Database Queries with SQL and dplyr

Explaining the relationship between SQL and dplyr with baseball examples.

4.90 (661 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
18,680
students
3 hours
content
Jun 2015
last update
FREE
regular price

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

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.

Content

Getting Set Up

Introduction
Access Set-up
RStudio Set-up
The Rcpp Package

Basic Queries

SELECT (SQL) and select (dplyr)
ORDER BY (SQL) and arrange (dplyr)
WHERE (SQL) and filter (dplyr)
AND and OR

Grouping and Aggregation

Grouping and Sum in Access SQL
Grouping, Summarize, and Sum in dplyr
Averaging in Access SQL and dplyr
max and min
count (SQL) and n (dplyr)
WHERE vs. HAVING
Batting Average and Mutate (dplyr)
Career Batting Average

Inner Joins

Inner Joins with Access SQL
Inner Joins with dplyr
A Query with an INNER JOIN
Joining on more than one field with SQL in Access
Joining on more than one field with dplyr in R
Joining three tables with SQL in Access
Joining three tables with dplyr in R
Grouping and joining with SQL in Access
Grouping and joining with dplyr in R

Practice Problems

Problem #1 with SQL
Problem #1 with dplyr
Problem #2 with Access
Problem #2 with dplyr
Reading Other Data into R

Screenshots

Baseball Database Queries with SQL and dplyr - Screenshot_01Baseball Database Queries with SQL and dplyr - Screenshot_02Baseball Database Queries with SQL and dplyr - Screenshot_03Baseball Database Queries with SQL and dplyr - Screenshot_04

Reviews

DD
March 13, 2021
This is exactly the connection I needed between R and SQL. I did not know that MS-Access had an SQL view, though I recently learned that it uses jet-SQL. After this course I think I will be able to tackle new challenges at work even though I don't know anything about baseball! Thanks!
Robert
January 26, 2021
so far, so good ... I am a life-long baseball fan and an R fan ... don't watch much of the Access ... FAST forward
Joseph
June 1, 2017
I love his self imposed paced. Its like I not racing to catch up. I also like the fact I can see his face when he's programming. There is something to being able to look at someone when they're walking you through the work.
Giannis
May 1, 2017
If somebody has a small experience in R, this is a great course to learn the dplyr package and make some practice. It is needed though to have some experience in databases as using Access to manipulate data is just an interface to practice SQL
Allen
April 30, 2017
This instructor is the best. Easy going, thorough, knowledgeable and excited about this vital topic (comparison between dplyr and SQL querying. Most instructors would offer the students CSV solutions instead of DB to avoid trouble. But this one is taking the risk and meticulously explains everything in his style. I also like that he is not in a hurry and allows the students to follow his coding on the screen. Again, a lot of instructors on UDEMY don't care much about us and speed up forgetting that we are here, on the other side of the screen. And another very important point! This instructor cares about the legibility. I don't have to strain my eyes to read his code on the screen!! This is a very, very important quality. I just finished taking another UDEMY course (Bootstrap web development). Most students were complaining about tiny fonts, etc. I sent a note but that instructor did not even respond... And, lastly, I can see that my current instructor is trying to pass the knowledge to his students, he is not after big bucks, he is a true teacher. This course if free!! I would love to take more of his courses ( I already took one of his courses on ggplot2 and liked it a lot). Thank you, I give him deserved 5 stars rating
Goede
February 7, 2017
Best teacher I ever had in R and statistics. He explains everything very well, with easy to follow instructions.
Felipe
January 3, 2017
Even though I am not a beginner with sql and dplyr, the Doctor explains both methods really well. As a suggestion, I would like to see dplyr connecting to the lahman's access database directly and do some exercises after extracting the data. Great job though!!!!
Anand
July 30, 2016
Concept of pipes in R has been beautifully explained by comparing with SQL. Wowww........ I had learnt the pipe concept in R from other course, tried surfing the net to get better understanding, but somehow it remained a mystery to me.......until i finally took this course. Now this important concept is absolutely clear to me. Thanks a lot. Your teaching skills are phenomenal. Hats off to you.... :) :) :)
Lingbin
July 9, 2016
This course shows the syntax and structure difference between SQL and R by solving the same problem using two languages. Well organized and easy to understand. Need basic knowledge about SQL and R. Looking forward to more examples.
Jeffrey
July 9, 2016
Great introductory program for learning to use MS Access or the R programming language. The information was useful and well presented. Using baseball stats to teach these programs helped to not only show how to do something, but also why you would do it. So many instructional videos only show you the how, but they fail to show the bigger picture of how a certain task or method relates to your project.
Charles
June 13, 2016
Great gentle intro to SQL and dplyr, highlighting similarities and differences. Each video is short and to the point, showing one particular aspect of a query.
Vikash
May 31, 2016
Thanks for this course. It is a basic course and for beginners. I think from that perspective you have done a great job.
Michal
April 24, 2016
I love the clarity with which everything is explained. The pace is appropriate as well and the subject matter keeps me engaged as well. Explained well even when stuck for a while.
Kamil
April 7, 2016
Very good exercises. I like how the instructor goes from SQL in MS Access to R Studio and shows how to do the exercise in both scripting languages.
Teo
April 1, 2016
Simply great! Totally recommended for all people who want to getting their hands dirty in data science and particularly in cleaning jobs and querying.... You can also go one further step even by exploring more the trends in this db or try to visualize them using ggplot package

Charts

Price

Baseball Database Queries with SQL and dplyr - Price chart

Rating

Baseball Database Queries with SQL and dplyr - Ratings chart

Enrollment distribution

Baseball Database Queries with SQL and dplyr - Distribution chart
524138
udemy ID
6/9/2015
course created date
11/7/2019
course indexed date
Bot
course submited by