Topic outline

  • __________________________________________________________________________________________________________________________
    Week 1 (April 25 - 30)
    Recommended readings: U & W: 1.1-1.2, 2.1-2.2, 2.4, 6.1-6.3
    -------------------------------------------------------------------------------------------------------------------------------
    Tue 25/04
    16:15-18:00
    R008/326,
    Otakaari 4
    Lecture

    Introduction to the course and teaching staff
    (Linh Tran & Khanh Ha)

    Model:
     
    Introduction to Databases and Relational Models
    (Prof. Nitin Sawhney)

    Theory: 
    Introduction to Relational Algebra
    (Hieu Pham & Hiep Nguyen)

    Application: 
    Introduction to SQL
    (Marko Ikävalko & Minh Dinh)

    Wed 26/04
    10:15-12:00

    Exercise session (Minh Dinh & Hiep Nguyen)
    Thu 27/04
    10:15-12:00
    T5 - A133,
    CS building
    or Zoom
    Exercise session (Marko Ikävalko & Hieu Pham)
    Fri 28/04
    10:15-12:00

    Exercise session (Linh Tran & Khanh Ha)
    __________________________________________________________________________________________________________________________
    Week 2 (May 02 – 07) 
    Recommended readings: U & W: 4.7, 3.1-3.2, 2.3, 7.1-7.4, 8.1-8.2
    -------------------------------------------------------------------------------------------------------------------------------
    Tue 02/05
    16:15-18:00R011/A305 (Ke1), Kemian Tekniikka  Lecture

    Model:
     
    UML Modeling & Relational Diagrams - Part I
    (Prof. Nitin Sawhney)

    Theory: 
    Functional Dependencies & Normal Forms I
    (Hiep Nguyen, Khanh Ha)

    Application: 
    Defining SQL Tables, Integrity Constraints, and Views 
    (Linh Tran, Minh Dinh)

    Wed 03/05
    18:00 A+ Homework 1 deadline at 18:00
    Wed 03/05
    10:15-12:00     Exercise session (Minh Dinh & Hiep Nguyen)
    Thu 04/05
    10:15-12:00 T5 - A133,
    CS building
    or Zoom
    Exercise session (Marko Ikävalko & Hieu Pham)
    Fri 05/05
    10:15-12:00    Exercise session (Linh Tran & Khanh Ha)
    __________________________________________________________________________________________________________________________
    Week 3 (May 09 – May 14) 
    Recommended readings: U & W: 4.8, 3.3-3.6, 6.4.3-6.4.7
    -------------------------------------------------------------------------------------------------------------------------------
    Tue 09/05
    16:15-18:00 R011/A305 (Ke1), Kemian Tekniikka
    Lecture

    Model:
     
    UML Modeling & Relational Diagrams - Part II
    (Prof. Nitin Sawhney, Marko Ikävalko)

    Theory: 
    Functional Dependencies & Normal Forms II
    (Hiep Nguyen, Khanh Ha)

    Application: 
    Advanced SQL and Aggregation
    (Minh Dinh, Hieu Pham)

    Wed 10/05 
    18:00 A+ Homework 2 deadline at 18:00

    Wed 10/05
    10:15-12:00     Exercise session (Minh Dinh & Hiep Nguyen)
    Thu 11/05
    10:15-12:00 T5 - A133,
    CS building
    or Zoom
    Exercise session (Marko Ikävalko & Hieu Pham)
    Fri 12/05
    10:15-12:00    Exercise session (Linh Tran & Khanh Ha)
    __________________________________________________________________________________________________________________________
    Week 4 (May 16 – May 21) 
    Recommended readings: U & W: 8.1-8.4, 1.2.4, 6.6, 7.5
    -------------------------------------------------------------------------------------------------------------------------------
    Mon 15/05
    18:00    A+ Project Part I deadline at 18:00

    Tue 16/05
    16:15-18:00 R011/A305 (Ke1), Kemian Tekniikka
    Lecture

    Indices(Hieu Pham, Hiep Nguyen)

    Transactions (Linh Tran, Khanh Ha)

    Triggers (Minh Dinh)

    Wed 17/05 
    18:00 A+ Homework 3 deadline at 18:00
    Wed 17/05
    10:15-12:00     Exercise session (Minh Dinh & Hiep Nguyen)
    Thu 18/05
    10:15-12:00 T5 - A133,
    CS building
    or Zoom
    Exercise session (Marko Ikävalko & Hieu Pham)
    Fri 19/05
    10:15-12:00     Exercise session (Linh Tran & Khanh Ha)
    __________________________________________________________________________________________________________________________
    Week 5 (May 23 – May 28) 
    Recommended readings: Badia: 1.5, 3.3.2, 3.3.3, 3.4.16.2.2
    -------------------------------------------------------------------------------------------------------------------------------
    Tue 23/05
    16:15-18:00 R011/A305 (Ke1), Kemian Tekniikka
    Lecture

    Data Cleaning and Analysis with SQL in Python (Minh Dinh & Khanh Ha)

    Using PostgreSQL for advanced applications (Hieu Pham)

    Visualization (Linh Tran)

    Wed 24/05
    18:00 A+ Homework 4 deadline at 18:00
    Wed 24/05
    10:15-12:00     Exercise session (Minh Dinh & Hiep Nguyen)
    Thu 25/05
    10:15-12:00 T5 - A133,
    CS building
    or Zoom
    Exercise session (Marko Ikävalko & Hieu Pham)
    Fri 26/05
    10:15-12:00    Exercise session (Linh Tran & Khanh Ha)
    __________________________________________________________________________________________________________________________
    Week 6 (May 30 – June 4)
    -------------------------------------------------------------------------------------------------------------------------------
    Mon 29/05 18:00 A+ Project Part II deadline at 18:00

    Tue 30/05
    16:15-18:00 R011/A305 (Ke1), Kemian Tekniikka

    Lecture

    Course wrap-up & reflection

    Project presentations & Feedback (Option 1)

    Wed 31/05 
    18:00 A+ Homework 5 deadline at 18:00
    Wed 31/05
    10:15-12:00     Exercise session (Minh Dinh & Hiep Nguyen)
    Thu 1/06
    10:15-12:00 T5 - A133,
    CS building
    or Zoom
    Exercise session (Marko Ikävalko & Hieu Pham)
    Fri 2/06
    10:15-12:00    Exercise session (Linh Tran & Khanh Ha)
    __________________________________________________________________________________________________________________________
    Week 7 (Jun 6 - Jun 11)
    -------------------------------------------------------------------------------------------------------------------------------
    Tue 06/06
    16:15-18:00
    Online via Zoom Project Presentations & Feedback (Option 2)
    __________________________________________________________________________________________________________________________
    Week 8  (Jun 12 - Jun 18)
    -------------------------------------------------------------------------------------------------------------------------------
    Mon 12/06
    18:00 A+ Project Part III deadline at 18:00
    Fri 16/06 
    18:00 A+ Project deliverable package deadline at 18:00
     
     Note: If you have questions or notice any inconsistencies in the weekly schedule, contact the TAs through Slack or emails.