Any necessary updates to the schedule will be documented here.
WEEK |
DATE |
TOPIC |
MATERIALS |
TASKS DUE |
---|---|---|---|---|
1 |
1/16 |
MLK DAY – No class |
||
1
|
1/18 |
Course Intro |
PowerPoint: |
|
1 |
1/20 |
The Information Architecture of an Organization |
PowerPoint: |
|
2 |
1/23 |
Understanding Database Schemas: Normalization, primary/foreign keys, joins |
PowerPoint: |
|
2 |
1/25 |
In-class activity 1: Creating database schema |
Resources: |
ICA #1 due tonight at 11:59 pm |
2
|
1/27 |
Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE (Make sure you’ve reviewed the guide for setting up a connection in MySQL Workbench and reviewed the MySQL PowerPoint deck!) |
PowerPoint: |
Assignment 1: Assignment #1 – Database Schemas_MWB.docx (due Monday 2/6, 11:59 PM) |
3 |
1/30 |
Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE |
PowerPoint: SQL Slide deck (Basic) |
|
3 |
2/1 |
Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE |
PowerPoint: SQL Slide deck (Basic) |
|
3 |
2/3 |
In-class activity 2: Pen and Paper exercise |
||
4 |
2/6 |
Getting data out of RDMS: Joining tables |
PowerPoint:
|
Assignment 1 is due by the end of the day |
4
|
2/8 |
In-class activity 3: Working with SQL, part 1 |
Resources: ICA #3 – SQL – Basic Queries.docx |
|
4 |
2/10 |
Getting data out of RDMS: Subselects |
PowerPoint: SQL Slide deck (Basic) Assignment: |
|
5 |
2/13 |
Getting data out of RDMS: Subselects (Continued) |
PowerPoint:
|
|
5 |
2/15 |
In-class activity 4: Working with SQL, part 2 |
ICA #4 – SQL Part 2 – Advanced Queries.docx | Assignment 2: SQL #1 (due Wednesday 2/15, 11:59 PM) |
5 |
2/17 |
Review of ICA #4 |
Assignment: |
|
6 |
2/20 |
Semi-structured data |
PowerPoint:
|
|
6 |
2/22 |
In-class activity 5: Working with semi-structured data |
ICA #5 – Working with Semi-Structured Data.docx | Assignment 3: SQL #2 (due Wednesday 2/22, 11:59 PM) |
6
|
2/24 |
Review for Exam 1 |
Exam 1 Study Guide.pdf | |
7 |
2/27 |
Exam 1 |
||
7 |
3/1 |
Getting data out of NoSQL: PROJECT, MATCH, SORT, LIMIT and GROUP |
PowerPoint: |
|
7 |
3/3 |
TBD |
|
|
8 |
3/6 |
NO CLASS – Spring Break |
||
8 |
3/8 |
NO CLASS – Spring Break |
||
8 |
3/10 |
NO CLASS – Spring Break |
||
9 |
3/13 |
Getting data out of NoSQL: PROJECT, MATCH, SORT, LIMIT and GROUP |
PowerPoint: (same as before break!) |
|
9 |
3/15 |
In-class activity 6: Working with NoSQL, part 1 |
ICA #6 – NoSQL Part 1.docx | |
9
|
3/17 |
Exam 1 review and start Assignment 4 |
Assignment 4 |
|
10 |
3/20 |
Getting data out of NoSQL: How to query nested document and array, JOIN |
PowerPoint: |
|
10 |
3/22 |
In-class activity 7: Working with NoSQL, part 2 |
Assignment 4: NoSQL #1 (due Wednesday 3/22, 11:59 PM) | |
10 |
3/24 |
Reconciling Data: The extract, transform, load process (ETL) |
PowerPoint: Assignment 5 |
|
11
|
3/27 |
Principles of Data Visualization |
PowerPoint: |
|
11 |
3/29 |
In-class activity 8: Getting familiar with Python and Jupyter Part 1 |
For ICA #8: |
Assignment 5: NoSQL #2 (due Wednesday 3/29, 11:59 PM) |
11 |
3/31 |
In-class activity 9: Data Visualization |
For ICA #9: |
|
12 |
4/3 |
Review for Exam 2 |
Exam 2 Study Guide.pdf Exam 2 Study Guide PowerPoint:
|
|
12 |
4/5 |
Exam 2 |
|
|
12 |
4/7 |
In-class activity 10: Getting familiar with Python and Jupyter Part 2 |
Resource file for ICA 10 |
|
13 |
4/10 |
Classification using Decision Trees |
PowerPoint: |
|
13
|
4/12 |
In-class activity 11: Decision trees in Python |
ICA resources: ICA11.zip Assignment 6 resources: assignment6.zip |
|
13 |
4/14 |
ICA 11 (again!) |
|
|
14 |
4/17 |
Review |
Assignment 6: Decision Trees (due Tuesday 4/18, 11:59 PM) |
|
14 |
4/19 |
Analysis Scenario: Identifying similar customers (clustering and segmentation) |
PowerPoint: |
|
14 |
4/21 |
In-class activity 12: Clustering and Segmentation in Python |
Resource: Assignment: |
|
15 |
4/24 |
Analysis Scenario: What products are purchased together? (Association Rules) |
PowerPoint: |
Assignment 7: Clustering (due Tuesday 4/25, 11:59 PM) |
15 |
4/26 |
In-class activity 13: Association Rule Mining in Python |
In Class Activity: Assignment: |
|
15 |
4/28 |
In-class activity 14: Computing Confidence, Support, and Lift |
In Class Activity: |
|
16 |
5/1 |
Review for Exam 3 |
PowerPoint: |
Assignment 8: Association Rules (due Monday 5/1, 11:59 PM) |
Exam 3 – Monday 5/8 1:00-3:00, Alter A035