NCSES Module 1: Introduction to SQL & R
The Introduction to SQL and R module is self-paced, delivered online and through the ADRF, and has weekly discussion sessions. You will not need to install any specific software. However, you do need to create an ADRF account as all notebooks needed for this course are located in the ADRF. 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. The documentation is also available for you inside the ADRF.
Pre-work
unit 1: Introduction to r and data frames
R-1 Notebook: Link to ADRF
Unit 2: Joins, Aggregations, and Visualizations
R-2 Notebook: Link to ADRF
unit 3: Introduction to sql
SQL-1 Notebook: Link to ADRF
unit 4: Joins; Using SQL in R
SQL-2 Notebook: Link to ADRF