Integrating SQL into R analytical workflows using duckDB & dbplyr

When: 7th March 2024, 1700-1830 UTC (convert to local time)

Where: Register to receive the Zoom link: https://events.humanitix.com/integrating-sql-into-r-analytical-workflows-using-dbplyr

Summary

In this workshop, we will discuss why you might consider a relational database to store environmental data. We will go over how to insert data in and retrieve data from a database using R and duckDB](https://duckdb.org/). 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

• 15min presentation on databases and data modelling
• Hands-on coding session

OSF archive

Presentation PDF archive