R SQL Fundamentals

REGISTRATION NOTES

Click register and then use your @berkeley.edu or @lbl.gov email address.
If you have trouble, you may need to log out of Zoom and log back in.
For help read more here: https://dlab.berkeley.edu/zoom-troubleshooting-tips

Location: Remote via Zoom.

Recordings: This D-Lab workshop will be recorded and made available to UC Berkeley participants for a limited time. Your registration for the event indicates your consent to having any images, comments and chat messages included as part of the video recording materials that are made available.

Start Time: D-Lab workshops start 10 minutes after the scheduled start time (“Berkeley Time”). We will admit all participants from the waiting room at that time.

Date & Time: This workshop runs from 3pm-5pm on:

• Monday, April 28

Description

In this workshop, we provide an introduction to using SQL to query and retrieve data from relational databases in R. First, we’ll cover what relational databases and SQL are. Then, we’ll use different packages in R to navigate relational databases using SQL.

SQL is a viable option for anyone working with a large dataset. For this reason, SQL is a must-skill if you intend to work with big data or data-intensive organizations. The workshop aims to demonstrate that SQL is easy to learn, if you already know how to use the dplyr package in R. This will be a very hands-on workshop, with live coding.

After this workshop, you will be able to:

• Explain what a relational database is and why we would want to use it.

• Access and query a database using SQL.

• Use DBI and dbplyr to query data from a relational database.

Prerequisites: Prior experience with R Fundamentals, R Data Wrangling, and R Data Visualization is assumed. No background knowledge in SQL required.