A two-day workshop. We will cover how to connect to and analyze data that exists outside of R. For databases, we will focus on the dplyr, DBI and odbc packages. For Big Data clusters, we will also learn how to use the sparklyr package to run models inside Spark and return the results to R. These packages enable us to use the same dplyr verbs inside R but are translated to SQL queries. We also will review recommendations for connection settings, security best practices and deployment options. Throughout the workshop, we will take advantage of RStudio’s professional tools such as RStudio Server Pro, the new professional data connectors, and RStudio Connect.
You should take this workshop if you want to learn how to use R with databases, such as SQL Server, Oracle, or PostgreSQL, and/or other scalable external data sources, such as Hadoop clusters with Hive and Spark.
-
Workbook R Notebooks - RMarkdown files at the top of the repository. They contain scaffold exercises for the students to practice during the class.
-
Full workbook - A version of the exercise chapters with all of the code completed is available under the
bookfolder. They are available as html files created by thebookdownpackage. -
Presentation deck - The PDF version of the deck that compliments the exercises. It is under
assets/presentation_deck.