CS-A1153 - Databases, Lecture, 19.4.2022-7.6.2022
This course space end date is set to 07.06.2022 Search Courses: CS-A1153
Topic outline
-
Week 1 (April 18–24)
Recommended readings: U & W: 1.1-1.2, 2.1-2.2, 2.4, 6.1-6.3Tue 19/04 16:15-18:00 R030/C202 T1 - Konemiehentie 2
(CS building)Lecture
Model: Introduction to Databases and Relational Models (Prof. Nitin Sawhney & Patrik Jüngling)
Theory: Introduction to Relational Algebra (Sophie Truong & Linh Ngo)
Application: Introduction to SQL (Long Nguyen & Atreya Ray)
Wed 20/04 10:15-12:00 Zoom Exercise session (Atreya Ray & Long Nguyen) Thu 21/04 10:15-12:00 Zoom Exercise session (Patrik Jüngling & Linh Ngo) Fri 22/04 10:15-12:00 Zoom Exercise session (Ezra Lim & Sophie Truong) Week 2 (April 25 – May 01)
Recommended readings: U & W: 4.7, 3.1-3.2, 2.3, 7.1-7.4, 8.1-8.2
Tue 26/04 16:15-18:00 R030/C202 T1 - Konemiehentie 2
(CS building)Lecture
Model: UML Modeling & Relational Diagrams - Part I(Prof. Nitin Sawhney)
Theory: Functional Dependencies & Normal Forms I (Patrik Jüngling & Ezra Lim)
Application: Defining SQL Tables, Integrity Constraints, and Views (Sophie Truong & Atreya Ray)
Wed 27/04 18:00 A+ Homework 1 deadline at 18:00 Wed 27/04 10:15-12:00 Zoom Exercise session (Atreya Ray & Long Nguyen) Thu 28/04 10:15-12:00 Zoom Exercise session (Patrik Jüngling & Linh Ngo)
Fri 29/04 10:15-12:00 Zoom Exercise session (Ezra Lim & Sophie Truong)
Week 3 (May 02 – May 08)
Recommended readings: U & W: 4.8, 3.3-3.6, 6.4.3-6.4.7
Tue 03/05 16:15-18:00 R030/C202 T1 - Konemiehentie 2
(CS building)Lecture
Model: UML Modeling & Relational Diagrams - Part II(Prof. Nitin Sawhney)
Theory: Functional Dependencies & Normal Forms II (Patrik Jüngling & Ezra Lim)
Application: Advanced SQL and Aggregation (Sophie Truong & Linh Ngo)
Wed 04/05 18:00 A+ Homework 2 deadline at 18:00 Wed 04/05 10:15-12:00 Zoom Exercise session (Atreya Ray & Long Nguyen) Thu 05/05 10:15-12:00 Zoom Exercise session (Patrik Jüngling & Linh Ngo)
Fri 06/05 10:15-12:00 Zoom Exercise session (Ezra Lim & Sophie Truong)
Week 4 (May 09 – May 15)
Recommended readings: U & W: 8.1-8.4, 1.2.4, 6.6, 7.5
Mon 09/05 18:00 A+ Project Part I deadline at 18:00 Tue 10/05 16:15-18:00 R030/C202 T1 - Konemiehentie 2
(CS building)Lecture
Indices(Prof. Nitin Sawhney & Ezra Lim)
Transactions (Patrik Jüngling)
Triggers (Sophie Truong)
Wed 11/05 18:00 A+ Homework 3 deadline at 18:00 Wed 11/05 10:15-12:00 Zoom Exercise session (Atreya Ray & Long Nguyen) Thu 12/05 10:15-12:00 Zoom Exercise session (Patrik Jüngling & Linh Ngo)
Fri 13/05 10:15-12:00 Zoom Exercise session (Ezra Lim & Sophie Truong)
Week 5 (May 16 – May 22)
Recommended readings: Badia: 1.5, 3.3.2, 3.3.3, 3.4.1, 6.2.2
Tue 17/05 16:15-18:00 R030/C202 T1 - Konemiehentie 2
(CS building)Lecture
Data Cleaning and Analysis with SQL in Python (Linh Ngo, Atreya Ray)
Introduction to using PostgreSQL (Ezra Lim, Sophie Truong)
Wed 18/05 18:00 A+ Homework 4 deadline at 18:00 Wed 18/05 10:15-12:00 Zoom Exercise session (Atreya Ray & Long Nguyen) Thu 19/05 10:15-12:00 Zoom Exercise session (Patrik Jüngling & Linh Ngo)
Fri 20/05 10:15-12:00 Zoom Exercise session (Ezra Lim & Sophie Truong)
Week 6 (May 23 – May 29)
Mon 23/05 18:00 A+ Project Part II deadline at 18:00 Tue 24/05 16:15-18:00 R030/C202 T1 - Konemiehentie 2
(CS building)Lecture
Course wrap-up & reflection
Project presentation & Discussion (Option 1)
Wed 25/05 18:00 A+ Homework 5 deadline at 18:00 Wed 25/05 10:15-12:00 Zoom Exercise session (Atreya Ray & Long Nguyen) Thu 26/05 10:15-12:00 Zoom Exercise session (Patrik Jüngling & Linh Ngo)
Fri 27/05 10:15-12:00 Zoom Exercise session (Ezra Lim & Sophie Truong)
Week 7 (May 30 – Jun 05)
Tue 31/05 16:15-18:00 R001/U270 U8 - Otakaari 1
(Undergrad Centre)Project presentation & Discussion (Option 2) Week 8 - 9 (Jun 06 – Jun 13)
Mon 06/06 18:00 A+ Project Part III deadline at 18:00 Mon 13/06 18:00 A+ Project deliverable package deadline at 18:00