Getting started with databases from R

In this first half of the book, we will explore how to work with databases from R. In the following chapters, you’ll see that when working with data held in a relational database, we can leverage various open-source R packages to perform tidyverse-style data analyses.

• In 1  A first analysis using data in a database we will perform a simple data analysis from start to finish using a table in a database.
• In 2  Core verbs for analytic pipelines utilising a database we will see in more detail how familiar dplyr functions can be used to combine data spread across different tables in a database into an analytic dataset for further analysis in R.
• In 3  Supported expressions for database queries we will see how we can perform more complex data manipulation via translation of R code into SQL specific to the database management system being used.
• In 4  Building analytic pipelines for a data model we will see how we can build data pipelines by creating a data model in R to represent the relational database we’re working with and creating functions and methods to work with it.