Topic outline

  • Week 1: Introduction to Databases and Understanding Relational Models (PDF Slides) Lecture by Prof. Nitin Sawhney, June 4, 2020

    Week 2: Relational Algebra (PDF Slides) & SQL Basics (PDF Slides), Lectures by Dr. Lukas Ahrenberg, June 9, 2020

    Week 3: Unified Modeling Language - Part I (PDF slides) and Part II (PDF slides) , Lectures by Prof. Nitin Sawhney, June 18, 2020

    Week 4: Functional Dependencies & Normal Forms (BCNF, 4NF) (PDF slides), Lecture by  Dr. Lukas Ahrenberg, June 25, 2020

    Week 5: SQL Queries & Aggregation Operations (PDF Slides), Lecture by Prof. Nitin Sawhney, July 2, 2020

    Week 6: Defining SQL Tables, Integrity Constraints and Views (PDF Slides), Lecture by Prof. Nitin Sawhney, July 9, 2020

    Week 7 (July 13–19): No lectures or exercise sessions

    Week 8: Indexes (PDF slidesand Transactions (PDF slides), Lectures by Dr. Lukas Ahrenberg, July 23, 2020

    Week 9: Triggers (PDF slides), Lecture by Dr. Lukas Ahrenberg, July 30, 2020

    Week 10: Embedding SQL & SQLite in Python (PDF Slides), Lecture by Dr. Lukas Ahrenberg, August 6, 2020

    Week 11: NoSQL Databases, Lecture by Prof. Keijo Heljanko, Department of Computer Science, University of Helsinki, May 11, 2020

    Week 12: Database Course Summary Review (PDF slides)Prof. Nitin Sawhney and Dr. Lukas Ahrenberg, August 20, 2020