Databases Course Home
Welcome to this introductory course on Databases offered online (in English) during the summer (June 4 - Sept 3, 2020). The course covers the basics of information management including relational models, design principles of databases, and database theory.
Instructors: Prof. Nitin Sawhney and Dr. Lukas Ahrenberg
Teaching Assistants: Etna Lindy and Ville Vuorenmaa
Online Learning Sessions: Thursdays 10:15 - 11:45 via Zoom and Slack (for access login to the
Platforms section)
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),
Lecture 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 slides) and Transactions (PDF slides), Lectures by Dr. Lukas Ahrenberg, July 23, 2020