CA ADAPT Class

Module 1: Introduction to SQL & R

Home Module 1 Pre-Module 2 Module 2 Pre-Module 3 Module 3

Presentation/Report Resources Contacts

The Introduction to SQL and R is self-paced, delivered online and has weekly discussion sessions. You will not need to install any specific software or create an account on any technology platforms to complete the introductory material. We expect the content to take no more than 4 hours per week.

Zoom Meeting Schedule

11:00 AM - 12:00 PM PT

Unit 1: May 13

Unit 2: May 20

Unit 3: May 27

Unit 4: June 3

Pre-work

Introduction to Programming

Introduction Videos

unit 1

Introduction to R and Data Frames Videos

R-1 Notebook

Unit 2

Functions, Loops, and Visualizations Videos

R-2 Notebook

unit 3

Introduction to SQL Videos

SQL 1 Notebook

unit 4

Joins: Using SQL in R Videos

SQL 2 Notebook

Notebook on how to use SQL with R