YoVDO

Baseball Database Queries with SQL and dplyr

Offered By: Udemy

Tags

SQL Courses R Programming Courses Relational Databases Courses Database Management Courses dplyr Courses

Course Description

Overview

Explaining the relationship between SQL and dplyr with baseball examples.

What you'll 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

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.


Taught by

Charles Redmond

Related Courses

Основы программирования на R
Bioinformatics Institute via Stepik
Анализ данных в R. Часть 2
Bioinformatics Institute via Stepik
Build Data Analysis tools using R and DPLYR
Coursera Project Network via Coursera
Build Data Analysis and Transformation Skills in R using DPLYR
Coursera Project Network via Coursera
Data Manipulation with dplyr in R
Coursera Project Network via Coursera