21 Databases

Learning objectives:

  • We are going to learn the basics of the Data Base Interface (DBI) package: how to use it to connect to a database and then retrieve data with a SQL.

  • We are going to learn how to use dbplyr to translate dplyr code to SQL