Introduction Videos
Introduction to Jupyter Notebooks
Introduction to SQL and Python
Unit 1
Motivation Question
Loading CSV Files
Exploring Data Frames
Creating Subsets
Checking For Inconsistencies
Unit 2
Motivating Question
Creating Functions
Using Loops
Visualizations
Line Chart
Error Messages
Unit 3
Motivating Question
Constructing a Basic Query
Using Conditional Statements
Checking Rows and Duplicates
Using Aggregation Functions
Unit 4
Motivating Question
Joins
Other Joins
Using Aggregation Functions with Joins
Creating and Dropping Tables