R SQL Fundamentals

In this workshop, we provide an introduction to using SQL to query and retrieve data from relational databases in R. First, we’ll cover what relational databases and SQL are. Then, we’ll use different packages in R to navigate relational databases using SQL.

If you are not familiar with material in R Fundamentals, R Data Wrangling, and R Data Visualization, we recommend attending those workshops first.

After this workshop, you will be able to:

1. Explain what a relational database is and why we would want to use it.
2. Access and query a database using SQL.
3. Use DBI and dbplyr to query data from a relational database.

This workshop does not cover the following:

• Read and conduct basic data operations in R. These are covered in R Fundamentals.
• Wrangle data for basic data analysis using R. These are covered in R Data Wrangling.