This page will be updated as the semester progresses and the topics may change. Lecture slides will be posted the evening before each class. Homeworks will be available as they are assigned and solutions posted after they have been graded.
Week | Date | Materials | References | Assignments & Scripts |
---|---|---|---|---|
1 | 1/13 | Introduction and Course Material | Chapter 1 | |
2 | 1/20 | Database Concepts | Chapter 2 | |
3 | 1/25 | Entity-Relationship Model | Chapter 3 | |
1/27 | Relational Model | Chapters 5, 9 | ||
4 | 2/1 | Relational Algebra | Chapter 8 | |
2/3 | Relational Algebra & Calculus | Chapter 8 | ||
5 | 2/8 | SQL - Part 1 | Chapter 6 | |
2/10 | SQL - Part 2 | Chapters 6, 7 | ||
6 | 2/15 | SQL - Part 3 | Chapters 6, 7 | |
2/17 | SQL - Part 4 | Chapters 6, 7 | ||
7 | 2/22 | MySQL Stored Procedures | ||
2/24 | JDBC (Java / SQL Programming) | Chapter 10 | ||
8 | 2/29 | Review | ||
3/2 | Midterm | |||
9 | 3/7 + 3/9 | Spring Break! | ||
10 | 3/14 | Database Design - Part 1 | Chapter 14 | |
3/16 | Database Design - Part 2 | Chapter 14, 15 | ||
11 | 3/21 | Data Storage | Chapter 16 | |
3/23 | Indexing - Part 1 | Chapters 16, 17 | ||
12 | 3/28 | Indexing - Part 2 | Chapter 17 | |
3/30 | Query Processing & Query Optimization | Chapters 18, 19 | ||
13 | 4/4 | Query Optimization - Part 2 | Chapter 19 | |
4/6 | Transaction Management & Concurrency Control | Chapters 20, 21 | ||
14 | 4/11 | PHP (Web Programming) | Chapter 11 | |
4/13 | Big Data Systems | Chapters 23, 25 | ||
15 | 4/18 | NoSQL | Chapter 24 | |
4/20 | Review | |||
16 | 4/25 | Last day: Elastic Search + MEAN Stack |