![]() |
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 |