 |
15-415 - Database Applications |
 |
| |
15-415 - Database Applications |
|
| Date | Number | Topic | Slides in PDF | Instructor |
| January 11 | L01 | Course Overview & Introduction to Database Applications | Slides | Hammoud |
| January 13 | L02 | The Entity Relationship Model | Slides | Hammoud |
| January 15 | R01 | A Case Study on Requirements Analysis and Conceptual Design | Document | Abed Rabbou |
| January 18 | L03 | The Relational Model | Slides | Hammoud |
| January 20 | L04 | The Relational Model (Cont'd) & Relational Algebra | Slides | Hammoud |
| January 22 | R02 | Translating ERD to the Relational Model | N/A | Abed Rabbou |
| January 25 | L05 | Relational Algebra (Cont'd) | Slides | Hammoud |
| January 27 | L06 | Relational Calculus | Slides | Hammoud |
| January 29 | R03 | Writing Relational Algebra and TRC Expressions | Document | Abed Rabbou |
| February 01 | L07 | SQL - Part I | Slides | Hammoud |
| February 03 | L08 | SQL - Part II | Slides | Hammoud |
| February 5 | R04 | Practicing SQL | SQL Queries Getting Started on PostgreSQL |
Abed Rabbou |
| February 08 | L09 | SQL - Part III | Slides | Hammoud |
| February 12 | R05 | JDBC | DBConnection.java | Abed Rabbou |
| February 15 | L10 | Disks and Files - Part I | Slides | Hammoud |
| February 17 | L11 | Disks and Files - Part II | Slides | Hammoud |
| February 19 | R06 | About Project 2 (HTML, Servlets, Tomcat) | Slides | Rabbou |
| February 22 | L12 | Tree-Based Indexes | Slides | Hammoud |
| February 24 | N/A | Midterm Exam | N/A | Hammoud |
| February 26 | R07 | JSPs with Cookies Support | Login.java | Rabbou |
| March 08 | L13 | Data Warehousing & Data Mining | Slides | Christos Faloutsos |
| March 10 | L14 | Tree-Based Indexes (Cont'd) & Hash-Based Indexes | Slides | Hammoud |
| March 12 | R08 | A Quick Refresher on P2 | NA | Rabbou |
| March 15 | L15 | Hash-Based Indexes (Cont'd) & External Sorting | Slides | Hammoud |
| March 19 | R09 | P2 Student Demos + Introduction to P3 | NA | Rabbou |
| March 22 | L16 | How to Start a Company in Five (maybe not so) Easy Steps- Delivered at QNCC | N/A | Michael Stonebraker |
| March 24 | L17 | External Sorting (Cont'd) & Algorithms for Relational Operations | Slides | Hammoud |
| March 26 | R09 | More on P3: Understanding the Implementation of our B+ Tree | NA | Rabbou |
| March 29 | L18 | Algorithms for Relational Operations (Cont'd) | Slides | Hammoud |
| March 31 | L19 | Algorithms for Relational Operations (Cont'd) | Slides | Hammoud |
| April 05 | L20 | Query Optimization | Slides | Hammoud |
| April 07 | L21 | Query Optimization (Cont'd) | Slides | Hammoud |
| April 12 | L22 | Transaction Management | Slides | Hammoud |
| April 14 | L23 | Transaction Management (Cont'd) | Slides | Hammoud |
| April 16 | L24 | Recovery Management (Introduction) | Slides | Hammoud |
| April 19 | L25 | Recovery Management (Cont'd) | Slides | Hammoud |
| April 21 | L26 | NoSQL Databases and Hadoop | Slides Slides |
Hammoud |
| April 23 | R10 | Hive | Slides(PPT) Slides(PDF) Datasets |
Rabbou |