UNCF/Excelencia Module 1: Introduction to SQL & R



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.

The data documentation pertaining to the public data used in this module contains an in-depth description of the variables and tables you will analyze.

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