 |
15-415 - Database Applications |
 |
| |
15-415 - Database Applications |
|
| Date | Topic | Readings | Slides in PDF |
| January 12 | Administrivia and Introduction | Syllabus, R&G C1 | Slides |
| January 14 | The Entity-Relationship Model | R&G C2 | Slides |
| January 16 | Case study on Entity Relationship Diagram | Notes from TA | Handout |
| January 19 | The Relational Model | R&G C3 | Slides |
| January 21 | The Relational Model (Continued) | R&G C3 | Slides |
| January 23 | Case study on Relational Algebra | Notes from TA | Handout |
| January 26 | Relational Algebra | R&G C4.2 | Slides |
| January 28 | Relational Calculus | R&G C4.3 | Slides |
| January 30 | Hands-on Relational Algebra & TRC Expressions | Notes from TA | Handout, Tables |
| February 2 | The SQL Query Language (Part I) | N/A | Slides |
| February 4 | The SQL Query Language (Part II) | R&G C5 | Slides |
| February 6 | Hands-on PostgreSQL | Notes from TA | Handout, Code |
| February 9 | The SQL Query Language (Part III) | R&G C5 | Slides |
| February 13 | TRC & Quiz I Review | Notes from TA | Exercises |
| February 16 | SQL - Discussion | Notes from the Instructor | N/A |
| February 18 | SQL - Wrap up | Notes from the Instructor | N/A |
| February 20 | Introduction to ORM | Notes from TA | Slides |
| February 23 | Intro to Disks and Files | Notes from the instructor | Slides |
| February 25 | More on Disks and Files | Notes from the instructor | N/A |
| February 27 | Django | Notes from TA | N/A |
| March 12 | Django Part II | Notes from TA | Handout |
| March 15 | Disks & Files Part II | R&G C11 | Slides |
| March 17 | Tree-Based Indexes | R&G C12 & C13 | Slides |
| March 19 | More on Django | Notes from TA | Handout , Recording |
| March 22 | Tree-Based Indexes Part II | R&G C12 & C13 | N/A |
| March 24 | Tree-Based Indexes Part III | R&G C12 & C14 | Slides |
| March 26 | Understanding B+ Trees | Notes from TA | Slides |
| March 29 | Hash-Based-Indexing-and-Sorting | Notes | Slides |
| March 31 | More on Sorting | R&G C15 | N/A |
| April 2 | P3 Overview | Notes from TA | Slides |
| April 5 | Algorithms for Relational Operations | R&G C15 | Slides |
| April 7 | Algorithms for Relational Operations (Part II) | R&G C16 | Slides |
| April 9 | Query Optimization | -- | Slides |
| April 12 | Query Optimization (Part II) | R&G C16 | Slides |
| April 14 | Query Optimization | R&G C18 | Slides |
| April 16 | Transaction Management | -- | Slides |
| April 19 | Transaction Management (Part II) | -- | Slides |
| April 21 | Crash Management | -- | Slides |
| April 23 | Crash Management (Part II) | Notes from the instructor | Slides |