Topic outline

  • Weekly Schedule



    Week 1 (April 18–24)
    Recommended readings: U & W: 1.1-1.2, 2.1-2.2, 2.4, 6.1-6.3
    Tue 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