WEEK | DATES | TOPIC | TASKS DUE | MATERIALS |
---|---|---|---|---|
1 | 8/23 |
– Course Introduction and Syllabus |
||
8/25 |
Understanding Database Schemas: Normalization, primary/foreign keys, joins |
|
|
|
2 | 8/30 | In-class exercise #01: Creating database schema |
|
|
9/1 |
Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE |
|||
3 |
9/6 |
In-class exercise #02: Pen and Paper exercise |
Assignment 1: Database schema |
|
9/8 |
Getting data out of RDMS: Joining tables In-class exercise #03: Working with SQL, part 1 |
|||
4 | 9/13 |
In-class exercise #03: Working with SQL, part 1 Getting data out of RDMS: Subselects |
|
|
9/15 |
In-class exercise #04: Working with SQL, part 2 |
Assignment 2: SQL #1 |
||
5 | 9/20 |
In-class exercise #04: Working with SQL, part 2 |
|
|
9/22 |
Review for Exam 1 |
Assignment 3: SQL #2 |
||
6 | 9/27 | Exam 1 |
|
|
9/29 |
Semi-structured data In-class exercise #05: Working with semi-structured data |
|
|
|
7 | 10/4 |
Getting data out of NoSQL: PROJECT, MATCH, SORT, LIMIT and GROUP |
||
10/6 | In-class exercise #06: Working with NoSQL, part 1 |
|
||
8 | 10/11 |
In-class exercise #06: Working with NoSQL, part 1 |
|
|
10/13 |
Getting data out of NoSQL: How to query nested document and array, JOIN In-class exercise #07: Working with NoSQL, part 2 |
Assignment 4: NoSQL #1 (Due on Monday 10/17 at 11.59pm) |
||
9 | 10/18 |
Reconciling Data: The extract, transform, load process (ETL) |
|
|
10/20 |
Principles of Data Visualization In-class exercise #8: Data Visualization |
|
||
10 | 10/25 |
Review for Exam 2 |
Assignment 5: NoSQL #2 |
|
10/27 | Exam 2 |
|
||
11 | 11/1 |
Introduction to Advanced Analytics and Python In-class exercise #9: Getting familiar with Python and Jupyter Part 1 |
||
11/3 | In-class exercise #10: Getting familiar with Python and Jupyter Part 2 |
|
|
|
12 | 11/8 |
Classification using Decision Trees |
|
|
11/10 |
In-class exercise #11: Decision trees in Python |
|
|
|
13 | 11/15 |
Analysis Scenario: Identifying similar customers (clustering and segmentation) |
|
|
11/17 |
In-class exercise #12: Clustering and Segmentation in Python |
|
|
|
14 | 11/22 | THANKSGIVING |
|
|
15 |
11/29 |
Analysis Scenario: What products are purchased together? (Association Rules) In-class exercise #13: Computing Confidence, Support, and Lift Review for Exam 3 |
Assignment 6 Due: Decision Trees Assignment 7 Due: Clustering |
|
12/1 |
Exam 3 |
|