Database Design Schedule

From Knowledge Kitchen
Jump to: navigation, search


Day Date Topic Reading done Assignment due
1 1/23 Course overview
2 1/25 Spreadsheets as databases Install latest Anaconda
3 1/30 Scrubbing and massaging data Assignment 1
4 2/1 Scrubbing and massaging data
5 2/6 MySQL - single table
6 2/8 MySQL - single table
  • Learning MySQL: Chapter 6, Working With Database Structures (pages 181-217; page 221)
  • MySQL row operations
Assignment 2
7 2/13 MySQL - single table
8 2/15 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/22 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/27 MongoDB CRUD
11 3/1 MongoDB recap
12 3/6 Review Assignment 4
13 3/8 Midterm Exam
14 3/20 Midterm Exam post-mortem
14 3/22 Server-side coding
15 3/27 Data visualization
16 3/29 Database design
17 4/3 MySQL - 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/5 MySQL - multiple tables
19 4/10 HTML Review Assignment 6
20 4/12 PHP & MySQL
21 4/17 PHP & MySQL
22 4/19 Decentralized Databases Assignment 7
23 4/24 APIs
24 4/26 APIs
25 5/1 Exam review
26 5/3 Exam review
27 5/9, 10:00am-11:50am, Room 101 Final Exam - check Official Exam Schedule