Topic outline

  • The lectures will take place in Zoom at 16:15-18:00 on Tuesdays. The zoom sessions will be recorded, and the video lectures will be published on this page, along with the lecture slides.

    Week 1: Introduction to Databases, Relational Algebra and SQL, lectures by Prof. Nitin Sawhney, Prof. Barbara Keller and Sami El-Mahgary, April 20, 2021. Lecture Slides (PDF)



    Week 2: Unified Modeling Language (UML) Part I, Functional Dependencies & Normal Forms Part I and Defining SQL Tables, Integrity Constraints and Views, lectures by Prof. Nitin Sawhney, Prof. Barbara Keller and Sami El-Mahgary, April 27, 2021. Lecture Slides (PDF)



    Week 3: Unified Modeling Language (UML) Part II, Functional Dependencies & Normal Forms Part II and Advanced SQL and Aggregation, lectures by Prof. Nitin Sawhney, Prof. Barbara Keller and Sami El-Mahgary, May 4, 2021. Lecture Slides (PDF)



    Week 4: Views, Indexes, Transactions and Triggers, lectures by Prof. Nitin Sawhney and Prof. Barbara Keller, May 11, 2021. Lecture Slides (PDF)



    Week 5: Data Cleaning and Data Analysis, lectures by Sami El-Mahgary, May 18, 2021. Lecture Slides (PDF)