![]() |
15-415 - Database Applications |
![]() |
Week | Session | Date | Topic | Type | Course work |
1 | 1 | 12 Jan | Administrivia and Introduction | Lecture |
|
| 2 | 14 Jan | The Entity-Relationship Model | Lecture | Start PS1 |
| 3 | 16 Jan | Case study on Entity Relationship Diagram | Recitation |
|
2 | 4 | 19 Jan | The Relational Model | Lecture |
|
| 5 | 21 Jan | The Relational Model (Continued) | Lecture |
|
| 6 | 23 Jan | Case study on Relational Algebra | Recitation |
|
3 | 7 | 26 Jan | Relational Algebra | Lecture | |
| 8 | 28 Jan | Relational Calculus | Lecture | End PS1 |
| --- | 29 Jan | -- | -- | Start PS2 |
| 9 | 30 Jan | Hands-on Relational Algebra | Recitation |
|
4 | 10 | 2 Feb | The SQL Query Language (Part I) | Lecture |
|
| 11 | 4 Feb | The SQL Query Language (Part II) | Lecture |
|
| 12 | 6 Feb | Hands-on PostgreSQL | Recitation | |
5 | 13 | 9 Feb | The SQL Query Language (Part III) | Lecture | Start P1 |
|
| 11 Feb | Sports Day | No Class |
|
|
| 12 Feb | -- | -- | End PS2 |
| 14 | 13 Feb | TRC expressions and Quiz I review | Recitation | |
6 | 15 | 16 Feb | SQL - Discussion | Lecture |
|
| 16 | 18 Feb | Quiz I & SQL Wrap Up | Lecture |
|
| 17 | 20 Feb | Introduction to ORM | Recitation |
|
7 | 18 | 23 Feb | Intro to Disks and Files (Part I) | Lecture |
|
| 19 | 25 Feb | Disks & Files - Part II (More on RAID & Disk Management) | Lecture | End P1 |
| 20 | 27 Feb | Django & PostgreSQL Introduction | Recitation | Start P2 |
Spring Break March 1 - 5 | |||||
8 | 21 | 8 Mar | Midterm | Exam 1 |
|
| 22 | 10 Mar | Class Cancelled | Lecture |
|
| 23 | 12 Mar | Django (User Profiles) | Recitation | |
-- | 13 Mar | -- | -- | Start PS3 | |
9 | 24 | 15 Mar | Disks & Files Part II | Lecture |
|
| 25 | 17 Mar | File Organizations and Indexing | Lecture |
|
| 26 | 19 Mar | More on Django | Recitation |
|
10 | 27 | 22 Mar | Tree-Based Indexing Schemes | Lecture | |
| 28 | 24 Mar | External Sorting (Continued) | N/A |
|
|
| 25 Mar | -- | -- | End P2 |
| 29 | 26 Mar | Understanding B+ Trees | Recitation | |
11 | 30 | 29 Mar | Tree-Based Indexing Schemes (Part II) |
|
|
-- | 30 Mar | -- | -- | Start P3 | |
| 31 | 31 Mar | More on Storing | Lecture | End PS3 |
| 32 | 2 Apr | P3 Overview | Recitation |
|
12 | 33 | 5 Apr | Algorithms for Relational Operations | Lecture | |
| 34 | 7 Apr | Algorithms for Relational Operations (Part II) | Lecture | Start PS4 |
| 35 | 9 Apr | QueryOptimization | Lecture |
|
13 | 36 | 12 Apr | Query Optimization (Part II) | Lecture |
|
| 37 | 14 Apr | Transaction Management | Lecture |
|
-- | 15 Apr | -- | -- | End PS4 | |
| 38 | 16 Apr | TBA | Lecture | Start PS5 |
-- | 18 Apr | -- | -- | End P3 | |
14 | 39 | 19 Apr | Logging and Recovery (Part I) | Lecture | |
| 40 | 21 Apr | Logging and Recovery (Part II) | Lecture |
|
| 41 | 23 Apr | NoSQL Databases & Hadoop | Lecture | End PS5 |
| 42 | TBA | Final | Exam 2 |
|