Date | DOW | Events | Lecture # | Lecture Notes | Readings | Due | |
---|---|---|---|---|---|---|---|
30-Aug-17 | Wed | 1 | Logistics and Database Basics | Chapter 1, 2 | |||
04-Sep-17 | Mon | Labor Day | |||||
06-Sep-17 | Wed | 2 | Database Model and SQL Notebook:Lecture 2 | Chapter 2, 6 | |||
11-Sep-17 | Mon | 3 | SQL (part 2) SQL (part 3) Notebook:Lecture 2 Recap Notebook:Lecture 3 | Chapter 6, 7 | |||
13-Sep-17 | Wed | 4 | SQL (part 4) Notebook: Lecture 4 | Chapter 5, 6, 7 | |||
18-Sep-17 | Mon | 5 | SQL (Lecture 3and4 Recap) | ||||
20-Sep-17 | Wed | 6 | SQL (Chapter 7) | Chapter 3 and 4 (Entity Relationship) | |||
25-Sep-17 | Mon | 7 | ER Diagram (Chapter 3) | Chapter 3 (Can Skip: 3.8) Chapter 4 (Recommended but not required) | |||
27-Sep-17 | Wed | 8 | ER Diagram (Chapter 3) | Chapter 9, 14, 15, 8 | |||
02-Oct-17 | Mon | 9 | No new slides | ||||
04-Oct-17 | Wed | 10 | Database Design | ||||
09-Oct-17 | Mon | Fall Recess | |||||
11-Oct-17 | Wed | 11 | Database Design Part 2 | Chapter 8 | |||
16-Oct-17 | Mon | 12 | Database Design Part 3 | Chapter 8 | |||
18-Oct-17 | Wed | 13 | Relational Algebara | ||||
23-Oct-17 | Mon | 14 | Midterm Review | ||||
25-Oct-17 | Wed | MT | |||||
30-Oct-17 | Mon | 15 | PHP+MySQL Quiz 6 | ||||
01-Nov-17 | Wed | 16 | I/O Model and External Sorting | ||||
06-Nov-17 | Mon | 17 | I/O Model and Indexing | ||||
08-Nov-17 | Wed | 18 | No new slides | ||||
13-Nov-17 | Mon | 19 | Query Optimization | ||||
15-Nov-17 | Wed | 20 | MongoDB and Query Optimization | ||||
20-Nov-17 | Mon | 21 | MongoDB demo | ||||
22-Nov-17 | Wed | ThanksGiving | |||||
27-Nov-17 | Mon | 22 | Query Optimization | ||||
29-Nov-17 | Wed | 23 | Transactions (AD) | ||||
04-Dec-17 | Mon | 24 | Transactions (CI)/td> | ||||
06-Dec-17 | Wed | 25 | No new slides Poster Guidelines | ||||
11-Dec-17 | Mon | Poster Session | 26 | ||||
13-Dec-17 | Wed | 27 | Final Review | ||||
18-Dec-17 | Mon | ||||||
20-Dec-17 | Wed | ||||||
25-Dec-17 | Mon |