Listed as Free on Udemy when checked on 21 October 2026. No coupon or subscription trial is required for the listed lessons. Enrollment needs a Udemy account; availability can change.
About this course
Seeing the same data question answered in two languages can make both easier to understand. Charles Redmond uses the Lahman baseball database to compare SQL queries in Microsoft Access with equivalent operations in R’s dplyr package.
The sequence begins with setup and simple selection, ordering and filtering, then progresses to grouping, aggregation and joins. Later examples combine tables and calculations, and the final section contains worked practice problems plus an introduction to reading other data into R.
| Official course | Baseball Database Queries with SQL and dplyr |
|---|---|
| Created by | Charles Redmond |
| Platform | Udemy |
| Language | English |
| Level | Beginner — Udemy listing |
| Listed duration | 182 minutes; 30 lectures across 5 sections |
| Certificate | Not included with a new free enrollment |
Skills you’ll gain
- Selecting and filtering records
- Grouping and summarizing data
- Joining related tables
- Comparing SQL and dplyr operations
The course is designed for beginners and does not assume extensive baseball knowledge. R and the open-source RStudio Desktop edition provide a free route for the R exercises. Microsoft Access is recommended but explicitly optional in the course requirements; its license is separate from enrollment.
Follow the R examples if you do not have Access, and use the side-by-side SQL explanations to understand the corresponding query logic. Software interfaces and package behavior may have changed since recording, so consult current documentation when a setup step differs. This review did not execute every query or test compatibility with current package versions.
Related courses for your next step
- Add a related skillPlan Useful Data Collection
Focus: Defining useful data requirements · Balancing information value and collection effort
Beginner
- Add a related skillBuild a First Tableau Dashboard
Focus: Loading spreadsheet data into Tableau · Distinguishing dimensions and measures
All Levels
Compare course focus, level and study time
| Course | Level | Focus | Study time |
|---|---|---|---|
| This course — Free SQL and R Course: Query Baseball Data with dplyr | Beginner | Selecting and filtering records · Grouping and summarizing data · Joining related tables | 182 minutes (Udemy listing) |
| Free Data Collection Course: Plan Useful Information, Tools and Resources | Beginner | Defining useful data requirements · Balancing information value and collection effort · Comparing mobile collection approaches | 30 minutes (Udemy listing) |
| Free Tableau Course: Turn Spreadsheet Data into Your First Dashboard | All Levels | Loading spreadsheet data into Tableau · Distinguishing dimensions and measures · Building and formatting common charts | 111 minutes (Udemy listing) |
Frequently asked questions
Must I buy Microsoft Access?
No. The instructor lists Access as helpful but not absolutely necessary; the parallel R and dplyr route can be followed with free open-source tools.
Does the course cover joins?
Yes. It includes inner joins, joins on multiple fields, joining three tables, and examples combining grouping with joins.
Checked on 21 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.
Questions & discussion
Share a useful question or correction. Comments appear after moderation. Please avoid personal or sensitive information.