TX 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

Reminder: Please follow these steps after loading the SQL 1 notebook:

  1. Within Binder (JupyterLab), click on the Help drop-down

  2. Click on 'Launch Classic Notebook'

  3. Navigate to the launched window and open SQL_1.ipynb

  4. Re-run the cells (results are being displayed here)

unit 4

Joins: Using SQL in R

Videos

SQL 2 Notebook

Notebook on how to use SQL with R

Reminder: Please follow these steps after loading the SQL 2 notebook:

  1. Within Binder (JupyterLab), click on the Help drop-down

  2. Click on 'Launch Classic Notebook'

  3. Navigate to the launched window and open SQL_1.ipynb

  4. Re-run the cells (results are being displayed here)