 |
15-415 - Database Applications |
 |
| |
15-415 - Database Applications |
|
| Date | Number | Topic | Slides in PDF | Instructor |
| January 13 | L01 | Course Overview & Introduction to Database Applications | Slides | Hammoud |
| January 15 | L02 | The Entity Relationship Model | Slides | Hammoud |
| January 16 | R01 | A Case Study on Requirements Analysis and Conceptual Design | Document | Abed Rabbou |
| January 20 | L03 | The Relational Model | Slides | Hammoud |
| January 22 | L04 | Relational Algebra | Slides | Hammoud |
| January 23 | R02 | A Case Study on Relational Databases and Practicing on Relational Algebra | Document | Hammoud |
| January 27 | L05 | Relational Calculus | Slides | Hammoud |
| January 29 | L06 | SQL - Part I | Slides | Hammoud |
| January 30 | R03 | Practicing Basic SQL Queries, TRC and DRC Expressions, and Using PostgreSQL | Document | Abed Rabbou |
| February 03 | L07 | SQL - Part II | Slides | Hammoud |
| February 05 | L08 | SQL - Part III | Slides | Hammoud |
| February 06 | R04 | A Simple library to connect a Java front-end to a PostgreSQL DBMS | Archive | Abed Rabbou |
| February 10 | N/A | Quiz I | N/A | Hammoud |
| February 12 | L09 | DBMS Internals- Part I: Disks, Disk Space Management & Buffer Management | Slides | Hammoud |
| February 13 | R05 | A Simple GUI using Window Builder - Part I | Archive | Abed Rabbou |
| February 17 | L10 | DBMS Internals- Part II: Files and Access Methods (File Organizations and ISAM Trees) | Slides | Hammoud |
| February 19 | L11 | DBMS Internals- Part III: Tree-Based Indexing (B and B+ Trees) | Slides | Hammoud |
| February 20 | R06 | Practice & Review for Mid-term | N/A | Abed Rabbou |
| February 24 | L12 | DBMS Internals- Part IV: Hash-Based Indexing (Static, Extendible and Linear Hashings) | Slides | Hammoud |
| February 26 | N/A | Midterm Exam | N/A | Hammoud |
| February 27 | R07 | Introduction to Project 2 | Project 3 | Abed Rabbou |
| March 10 | L13 | DBMS Internals- Part V: External Sorting | Slides | Hammoud |
| March 12 | L14 | DBMS Internals- Part VI: Evaluating Relational Operators | Slides | Hammoud |
| March 13 | R08 | Solving the Mid-term Exam | N/A | Abed Rabbou |
| March 17 | L15 | DBMS Internals- Part VII: Evaluating Relational Operators (Cont'd) | Slides | Hammoud |
| March 19 | L16 | DBMS Internals- Part VIII: Evaluating Relational Operators (Cont'd) | Slides | Hammoud |
| March 20 | R09 | Introduction to Project 3 | Project 3 Slides | Abed Rabbou |
| March 24 | L17 | DBMS Internals- Part IX: Query Optimization | Slides | Hammoud |
| March 26 | L18 | DBMS Internals- Part X: Query Optimization (Cont'd) | Slides | Hammoud |
| March 27 | R10 | More on Project 3 | Project 3 Slides | Abed Rabbou |
| April 2 | L19 | DBMS Internals- Part XI: Transaction Management | Slides | Hammoud |
| April 3 | R11 | Quiz II | N/A | Hammoud |
| April 7 | N/A | Student Presentations of Project 3 | N/A | Hammoud |
| April 9 | L20 | DBMS Internals- Part XII: Transaction Management (Cont'd) | Slides | Hammoud |
| April 14 | L21 | DBMS Internals- Part XIII: Transaction Management (Cont'd) & Recovery Management | Slides | Hammoud |
| April 16 | L22 | DBMS Internals- Part XIV: Recovery Management (Cont'd) | Slides | Hammoud |
| April 21 | L23 | NoSQL Databases | Slides | Hammoud |
| April 23 | L24 | Hadoop = HDFS + MapReduce | Slides | Hammoud |
| April 24 | R12 | A Review Session for the Final Exam | N/A | Hammoud |