CS-A1153 - Databases (summer course), 04.06.2020-03.09.2020
This course space end date is set to 03.09.2020 Search Courses: CS-A1153
Topic outline
-
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
Week 10: Embedding SQL & SQLite in Python (PDF slides), Lecture by Dr. Lukas Ahrenberg, August 6, 2020Week 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), Discussion led by Prof. Nitin Sawhney and Dr. Lukas Ahrenberg, August 20, 2020 Week 13: Project Part II deadline, August 28, 2020 (20:00)Week 14: Final Examination, September 3, 2020 (09:00-12:00)