 |
15-415 - Database Applications |
 |
| |
15-415 - Database Applications |
|
| Date | Number | Topic | Slides in PDF | Instructor |
| January 10 | L01 | Course Overview & Introduction to Database Applications | Slides | Hammoud |
| January 12 | L02 | The Entity Relationship Model | Slides | Hammoud |
| January 14 | R01 | A Case Study on Requirements Analysis and Conceptual Design | Handout | Jabban |
| January 17 | L03 | The Relational Model- Part I | Slides | Hammoud |
| January 19 | L04 | The Relational Model- Part II | Slides | Hammoud |
| January 21 | R02 | Translating ERD to the Relational Model | N/A | Jabban |
| January 24 | L05 | Relational Algebra | Slides | Hammoud |
| January 26 | L06 | Relational Calculus | Slides | Hammoud |
| January 28 | R03 | Writing Relational Algebra and TRC Expressions | Document | Jabban |
| January 31 | L07 | SQL - Part I | Slides | Hammoud |
| February 02 | L08 | SQL - Part II | Slides | Hammoud |
| February 04 | R04 | Practicing SQL | PostgreSQL & SQL | Jabban |
| February 07 | L09 | SQL - Part III | Slides | Hammoud |
| February 11 | R05 | Quiz I | N/A | Hammoud and Jabban |
| February 14 | L10 | JDBC | Slides From L09 | Hammoud |
| February 16 | L11 | Disks and Files - Part I | Slides | Hammoud |
| February 18 | R06 | Practicing on JDBC | DBConnection.java JDBC Jar File |
Jabban |
| February 21 | L12 | Disks and Files - Part II | Slides | Hammoud |
| February 25 | R07 | Project 2 (HTML, Servlets, Tomcat) | Slides | Jabban |
| March 06 | L13 | Tree-Based Indexes | Slides | Hammoud |
| March 08 | L14 | Tree-Based Indexes (Cont'd) | Slides From L13 | Hammoud |
| March 10 | R08 | More on P2: Cookies & Recommendations | Slides | Jabban |
| March 13 | L15 | Tree-Based Indexes (Cont'd) & Hash-Based Indexes | Slides | Hammoud |
| March 15 | L16 | Hash-Based Indexes (Cont'd) & External Sorting | Slides | Hammoud |
| March 17 | R09 | P3 Overview | Slides | Jabban |
| March 20 | N/A | P2 Students' Presentations | N/A | Hammoud & Jabban |
| March 22 | L17 | External Sorting (Cont'd) & Algorithms for Relational Operations | Slides | Hammoud |
| March 25 | R10 | More on P3: Understanding the Implementation of our B+ Tree | N/A | Jabban |
| March 27 | L18 | Algorithms for Relational Operations (Cont'd) | Slides | Hammoud |
| March 29 | L19 | Algorithms for Relational Operations (Cont'd) | Slides | Hammoud |
| March 31 | L20 | Query Optimization | Slides | Hammoud |
| April 03 | L21 | Query Optimization (Cont'd) | Slides | Hammoud |
| April 10 | L22 | Transaction Management | Slides | Hammoud |
| April 12 | L23 | Transaction Management (Cont'd) | Slides | Hammoud |
| April 14 | L24 | Recovery Management (Introduction) | Slides | Hammoud |
| April 17 | L25 | Recovery Management (Cont'd) | Slides | Hammoud |
| April 19 | L26 | NoSQL Databases and Hadoop | Slides Slides |
Hammoud |