Best practices for working with databases

March 30, 2018 Edgar Ruiz

Download Materials

Abstract
Get the most out of joining R forces with database forces. We will review key concepts, share the latest in R packages, and demo useful techniques. In this webinar, we will demonstrate a pragmatic approach for pairing R with databases. You will learn to use R’s familiar dplyr syntax to perform queries. We will also share the latest in R packages that aid with visualization and running predictions in-database. The webinar will focus on general principles and best practices; we will avoid technical details related to specific data store implementations.

About the speaker

Edgar Ruiz 
Solutions Engineer, RStudio

Edgar is the author and administrator of the https://db.rstudio.com web site, and current administrator of the [sparklyr] web site: https://spark.rstudio.com. Author of the Data Science in Spark with sparklyr cheatsheet. Co-author of the dbplyr package and creator of the dbplot package.

About the Author

Edgar Ruiz

Edgar Ruiz is a solutions engineer at RStudio with a background in deploying enterprise reporting and business intelligence solutions. He is the author of multiple articles and blog posts sharing analytics insights and server infrastructure for data science. Edgar is the author and administrator of the https://db.rstudio.com web site, and current administrator of the sparklyr web site: https://spark.rstudio.com. Co-author of the dbplyr package, and creator of the dbplot, tidypredict and modeldb package.

Follow on Twitter Follow on Linkedin Visit Website More Content by Edgar Ruiz
Previous Video
Administration of Shiny Server Pro: share Shiny apps, secure user access, monitor resource utilization
Administration of Shiny Server Pro: share Shiny apps, secure user access, monitor resource utilization

Next Video
Scaling Shiny apps with asynchronous programming
Scaling Shiny apps with asynchronous programming

Asynchronous programming offers a way to offload certain classes of long-running operations from the main R...