Integrating SQL into R analytical workflows using duckDB & dbplyr

Summary

In this workshop, we will discuss why you might consider relational databases to store environmental data. We will go over how to insert data in and retrieve data from a database using R and duckDB. We will focus on how to use the R dbplyr package to integrate databases into tidyverse-focused analytical workflows.

This workshop will cover these main points:

• Introduce concepts of a database and discuss why you might want to have/want to use one
• How to integrate the use of a database into an R analytical workflow
• Hands-on exercise using duckDB, dbplyr and how it can be used to learn some SQL basics

Workshop structure

• presentation on databases and data modelling (20min)
• Hands-on coding session (80min)
• Q&A (15min)