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