Lectures and Recitations

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