Working with Databases in R
Learn how to connect R to MySQL, PostgreSQL, and SQLite databases using DBI and dplyr, and build a mini app that queries and visualizes data.
Get Started!
85
Course Details
Language: R
Duration: 4 weeks
Difficulty: medium
Category: Programming
Certificate: Yes
Requirements
Basic understanding of R
Content
01Introduction to Databases in R
1 Chapters - 0/1 Completed
01
Introduction to Databases in R
1 Chapters - 0/1 Completed
Understanding Relational Databases
02Environment Setup
2 Chapters - 0/2 Completed
02
Environment Setup
2 Chapters - 0/2 Completed
Setting Up R and Packages
Installing Database Systems
03Exploring Databases with R
1 Chapters - 0/1 Completed
03
Exploring Databases with R
1 Chapters - 0/1 Completed
Exploring the Database
04Querying with SQL in R
2 Chapters - 0/2 Completed
04
Querying with SQL in R
2 Chapters - 0/2 Completed
Basic SQL Queries Using dbGetQuery()
Parameterized Queries and Safety
05Working with Databases Using dplyr
2 Chapters - 0/2 Completed
05
Working with Databases Using dplyr
2 Chapters - 0/2 Completed
Introduction to dplyr for Databases
dplyr Operations on Remote Tables
06Visualizing Data from Databases
2 Chapters - 0/2 Completed
06
Visualizing Data from Databases
2 Chapters - 0/2 Completed