 |
15-415 - Database Applications |
 |
| |
15-415 - Database Applications |
|
| Date | Number | Topic | Slides in PDF | Instructor |
| January 7 | L01 | Course Overview & Introduction to Database Applications | Slides | Hammoud |
| January 9 | L02 | The Entity Relationship Model | Slides | Yousuf |
| January 10 | R01 | A Case Study on Requirement Analysis and Conceptual Design | Handout | Jabban |
| January 14 | L03 | The Relational Model - Part I | Slides | Hammoud |
| January 16 | L04 | The Relational Model- Part II | Slides | Hammoud |
| January 17 | R02 | Translating ERD to the Relational Model | N/A | Jabban |
| January 21 | L05 | Relational Algebra | Slides | Yousuf |
| January 23 | L06 | Relational Algebra - Continued | N/A | Hammoud |
| January 24 | R03 | Practicing Relational Algebra | Handout | Jabban |
| January 28 | L07 | Relational Calculus | Slides | Hammoud |
| January 30 | L08 | SQL - Part I | Slides | Hammoud |
| January 31 | R04 | Practicing SQL | Handout, Code | Jabban |
| February 04 | L09 | SQL - Part II | Slides | Hammoud |
| February 06 | L10 | SQL - Part III | Slides | Yousuf |
| February 07 | R05 | Django - Part I | Notes, Code | Yousuf |
| February 11 | L11 | Quiz I & ORM | Slides | Yousuf |
| February 14 | R06 | Django - Part II | Notes, Code | Yousuf |
| February 18 | L11 | ORM & Intro to Disks and Files | Slides | Yousuf Hammoud |
| February 20 | L12 | Disks and Files - Part I | Slides | Hammoud |
| February 21 | R07 | Django - Part III | Code | Yousuf |
| February 25 | L13 | Disks and Files - Part II (More on RAID & Disk Management) | Slides | Hammoud |
| February 27 | L14 | Disks and Files - Part III | Slides | Hammoud |
| March 11 | L15 | Tree-Based Indexes | Slides | Hammoud |
| March 14 | R08 | Practicing B+ Trees | Handout | Jabban |
| March 18 | L16 | Tree-Based Indexes (Cont'd) | Slides | Hammoud |
| March 20 | L17 | Hash-Based Indexes & Sorting | Slides | Hammoud |
| March 22 | R09 | P3 Overview | N/A | Yousuf |
| March 25 | L18 | Sorting (Cont'd) & Algorithms for Relational Operations | Slides | Yousuf |
| March 27 | L19 | Algorithms for Relational Operations (Cont'd) | Slides | Yousuf |
| March 29 | L20 | Algorithms for Relational Operations (Cont'd) | Slides | Yousuf |
| April 01 | L21 | Query Optimization | Slides | Hammoud |
| April 03 | L22 | Query Optimization (Cont'd) | Slides | Hammoud |
| April 08 | N/A | Quiz II & a Brief Intro on Transaction Management | N/A | Hammoud |
| April 10 | L23 | Transaction Management- Part I | Slides | Hammoud |
| April 11 | L24 | Transaction Management- Part II | Slides | Hammoud |
| April 15 | L25 | Crash Management - Part I | Slides | Hammoud |
| April 17 | L26 | Crash Management - Part II | Slides | Hammoud |
| April 18 | L27 | NoSQL Databases | Slides | Hammoud |