Accessing SQL Databases in R: Three Approaches

Here, three approaches to access SQL databases from R are introduced:
- the DBI package in combination with a database-specific backend package,
- the dbplyr approach which translates dplyr code to SQL in the background,
- embedding SQL code in R Markdown documents (Notebooks)
Bonus section: Best practices, e. g. securing database credentials (several options), and more package recommendations.
Credit goes to the RStudio team for providing free access to so many resources, both in general and specifically for database connections in R. See db.rstudio.com.
Disclaimer: I'm not affiliated with RStudio.
Slides can be found here:
github.com/fjodor/data-import...
Contact me, e. g. to discuss (online) R workshops / trainings / webinars:
LinkedIn: / wolfriepl
Twitter: / statistikindd
Xing: www.xing.com/profile/Wolf_Riepl
Facebook: / statistikdresden
statistik-dresden.de/kontakt
R Workshops: statistik-dresden.de/r-schulu...
Blog (German, translate option): statistik-dresden.de/statisti...
Playlist: Music chart history
• Music Chart History

[@deyvismejia7529]

i'm learning sql but want to do everything in R for convenience. this was very informative as i've seen many other videos show different approaches and packages

[@bjorndabearkhers]

Very helpful, thank you!

[@waynemontgomery7369]

This is a good overview.

[@nkristianschmidt]

yes, tidyverse is a bit challenging if one is used to R and sql