Date | DOW | Events | Lecture # | Lecture Notes | Readings | Due | |
---|---|---|---|---|---|---|---|
17-Jan-18 | Wed | 1 | Logistics and Introduction | Chapter 1, 2 | |||
22-Jan-18 | Mon | 2 | Database Model and Introduction to SQL Notebook:Lecture 2 | Chapter 2, 6 | |||
24-Jan-18 | Wed | 3 | Introduction to SQL (part 2) Introduction to SQL (part 3) Notebook:Lecture 2 recap Notebook:Lecture 3 | Chapter 2, 6 | |||
29-Jan-18 | Mon | 4 | Introduction to SQL (part 4) Notebook:Lecture 4 | Chapter 5, 6, and 7 | |||
31-Jan-18 | Wed | 5 | No New Slides | ||||
5-Feb-18 | Mon | 6 | Introduction to SQL (last) | ||||
7-Feb-18 | Wed | 7 | ER Diagram | Chapter 3 | |||
12-Feb-18 | Mon | 8 | ER Diagram (part 2) | ||||
14-Feb-18 | Wed | 9 | ER Diagram (part 3) | Chapter 9 | |||
19-Feb-18 | Mon | 10 | ER Diagram to Relation Mapping Database Design Part 1(FDs, Anomalies) | Chapter 14, 15 | |||
21-Feb-18 | Wed | 11 | Database Design Part 2 (Closure, Super Key, Key) | ||||
26-Feb-18 | Mon | 12 | Database Design Part 3 (2NF, 3NF, BCNF) | ||||
28-Feb-18 | Wed | 13 | Database Design Part 4 (BCNF Decomposition, Cover, Minimal Cover) | ||||
5-Mar-18 | Mon | 14 | Relational Algebra and Midterm Review | ||||
7-Mar-18 | Wed | MidTerm | |||||
12-Mar-18 | Mon | Spring Recess | |||||
14-Mar-18 | Wed | Spring Recess | |||||
19-Mar-18 | Mon | 15 | HTML, PHP, and MySQL Quiz8 | Chapter 16, 17 | |||
21-Mar-18 | Wed | 16 | File Structures | Chapter 16 and 17 (Refer slides) | |||
26-Mar-18 | Mon | 17 | File Structures and Indexing | Chapter 16 and 17 (Refer slides) | |||
28-Mar-18 | Wed | 18 | Indexing | ||||
2-Apr-18 | Mon | 19 | Query Processing (Sorting and Join) | ||||
4-Apr-18 | Wed | 20 | No New slides | ||||
9-Apr-18 | Mon | Last day to drop/S/F | 21 | HashMap and Query optimization | |||
11-Apr-18 | Wed | 22 | MongoDb | Chapter 20 and 21||||
16-Apr-18 | Mon | 23 | Transactions_1 | Chapter 20, 21, and 22 | |||
18-Apr-18 | Wed | 24 | Transactions_2 | ||||
23-Apr-18 | Mon | 25 | No New Lecture Slides Spark Spark_Tutorial1 Spark_Tutorial2 talesOfTwoCities File to Start With | ||||
25-Apr-18 | Wed | 26 | Transactions_Last | ||||
30-Apr-18 | Mon | Last Lecture | 27 | Final Review | |||
6-May-18 | Sun | Final |