Database Design Schedule

Day	Date	Topic	Reading done	Assignment due
1	1/22	Course overview	Student FAQ
2	1/24	Spreadsheets as databases	Relational database terminology An overview of Excel's database functions Databases in Microsoft Excel	Install latest Anaconda
3	1/29	Scrubbing and massaging data	Files in Python Text files in Python Reading and parsing CSV files in Python	Assignment 1
4	1/31	Scrubbing and massaging data	The big dirt on big data Data cleansing Data munging in Python
5	2/5	SQL - single table	Learning MySQL: Chapter 5, Basic SQL (pages 135-156;163-177) MySQL table operations Single table design considerations
6	2/7	SQL - single table	Learning MySQL: Chapter 6, Working With Database Structures (pages 181-217; page 221) MySQL row operations	Assignment 2
7	2/12	SQL - single table	Learning MySQL: Chapter 7, Advanced Querying (pages 223-236) Accessing MySQL on the i6 server MySQL CRUD workshop
8	2/14	Next generation databases	MongoDB: Chapter 1, Introduction Chapter 2, Getting Started (pages 7-18, 22-23) MongoDB: Chapter 3, Creating, Updating and Deleting Documents (pages 29-33) Next generation databases
9	2/21	MongoDB CRUD	MongoDB: Chapter 4, Querying (pages 53-59; 68-69) MongoDB: Chapter 7, Aggregation (pages 127-129) Setting up MongoDB	Assignment 3
10	2/26	MongoDB CRUD	Basic MongoDB CRUD
11	2/28	MongoDB recap	MongoDB CRUD workshop
12	3/5	Review	Database Design midterm exam review Midterm exam sample questions	Assignment 4
13	3/7	Midterm Exam
14	3/19	Midterm Exam post-mortem	Sending data from client to server
14	3/21	No class
14	3/26	Server-side coding	Learning MySQL: Chapter 13, Web Database Applications Server-side coding in Python
15	3/28	Server-side coding	Debugging server-side Python code LAMP App Workshop
16	4/2	Database design	Learning MySQL: Chapter 4, Modeling and Designing Databases Database normalization Entity Relationship Diagrams
17	4/4	SQL - multiple tables	Learning MySQL: Chapter 8, Doing More With MySQL (pages 281-285) Learning MySQL: Chapter 5, Joining Two Tables (pages 156 -162) Learning MySQL: Chapter 7, Advanced Querying (pages 237-266) MySQL inner joins	Assignment 5
18	4/9	SQL - multiple tables	Left, Right, and Reflexive Joins
19	4/11	HTML Review	Introduction to HTML 5 Elements of HTML style	Assignment 6
20	4/16	Python and pandas	Jupyter notebooks Using pandas for data analysis
21	4/18	Python and pandas	10 minutes to pandas
22	4/23	Data visualization	Introduction to data visualization Charting in Python with Bokeh	Assignment 7
23	4/25	APIs	Twitter API Facebook API NPR API
24	4/30	Decentralized Databases	Blockchain overview	Assignment 8
25	5/2	TBD
26	5/7	Exam review	Final exam review
27	5/9, 10:00am-11:50am, Room 101	Final Exam - check Official Exam Schedule