Topic outline

  • Course schedule consists of:
    • 1 Online Learning Session per week
    • 3-4 exercise sessions per week until mid August (TAs will both have 2 weeks off in July)
    • 2 deadlines for exercises and 2 deadlines for project
    • 1 final exam
    • TA help sessions for project groups (check Group project page)

    There are some exceptions but all the details are listed here.

    Weekly Schedule with Online Learning Sessions and Exercises


    Week 1 (June 01–07)
    Readings: U & W: 1.1-1.2 & 2.1-2.2.7
    Thu 04 Jun 10:15-12:00 Topic: Introduction & Understanding Relational Models
    Lecture by Prof. Nitin Sawhney
    Week 2 (June 08–14) 
    Readings: U & W: 2.2, 2.4, 6.1 - 6.2
    Tue 09 Jun 16:15-18:00 Exercise session
    Thu 11 Jun 10:15-12:00 Topic: Relational Algebra & SQL basics
    Lecture by Dr. Lukas Ahrenberg
    Thu 11 Jun 14:15-16:00 Exercise session
    Fri 12 Jun 10:15-12:00 Exercise session
    Week 3 (June 15–21) 
    Readings: U & W: 4.7, 4.2, 4.8, 3.1-3.3.1
    Tue 16 Jun 16:15-18:00 Exercise session
    Thu 18 Jun 10:15-12:00 Topic: UML Modeling & Relational Diagrams
    Lecture by Prof. Nitin Sawhney
    Thu 18 Jun 14:15-16:00 Exercise session
    Week 4 (June 22–28)
    Readings: U & W: 3.3.2-3.4, 3.6
    Tue 23 Jun 16:15-18:00 Exercise session
    Thu 25 Jun 10:15-12:00 Topic: Functional Dependencies & Boyce-Codd Normal Form
    Lecture by Dr. Lukas Ahrenberg
    Thu 25 Jun 14:15-16:00 Exercise session
    Fri 26 Jun 10:15-12:00 Exercise session
    Week 5 (June 29 – July 05) 
    Readings: U & W: 6.3-6.4
    Tue 30 Jun 16:15-18:00 Exercise session
    Thu 02 Jul 10:15-12:00 Topic: SQL Queries & Aggregation Operations
    Lecture by Prof. Nitin Sawhney
    Thu 02 Jul 14:15-16:00 Exercise session
    Fri 03 Jul 10:15-12:00 Exercise session
    Week 6 (July 06–12) 
    Readings: U & W: 2.3, 6.5, 7.1-7.4, 8.1-8.2
    Thu 09 Jul 10:15-12:00 Topic: Defining SQL Tables, Integrity Constraints & Views
    Lecture by Prof. Nitin Sawhney
    Thu 09 Jul 14:15-16:00 Exercise session
    Fri 10 Jul 10:15-12:00 Exercise session
    Week 7 (July 13–19)

    No lectures or exercise sessions
    Week 8 (July 20–26) 
    Readings: U & W: 1.2.4, 6.6, 8.3, 8.4
    Tue 21 Jul 16:15-18:00 Exercise session
    Thu 23 Jul 10:15-12:00 Topic: Indexes and their Usage, Transactions
    Lecture by Dr. Lukas Ahrenberg
    Thu 23 Jul 14:15-16:00 Exercise session
    Week 9 (July 27 – Aug 02)
    Readings: U & W: 7.5
    Mon 27 Jul 14:15-16:00 Exercise session (Ville)
    Tue 28 Jul 16:15-18:00 Exercise session (Etna)
    Thu 30 Jul 10:15-12:00 Topic: Triggers
    Lecture by Dr. Lukas Ahrenberg
    Thu 30 Jul 14:15-16:00 Exercise session (Etna)
    Fri 31 Jul 10:15-12:00 Exercise session (Ville)
    Week 10 (Aug 03–09)
    Mon 03 Aug 14:15-16:00 Exercise session (Ville)
    Tue 04 Aug 10:00 Deadline of exercise rounds 1, 2 and 3
    Tue 04 Aug 16:15-18:00 Exercise session (Ville)
    Thu 06 Aug 10:15-12:00 Topic: Embedding SQL + Python
    Lecture by Dr. Lukas Ahrenberg
    Thu 06 Aug 14:15-16:00 Exercise session (Etna)
    Fri 07 Aug 10:15-12:00 Exercise session (Etna)
    Fri 07 Aug 20:00 Project Part I deadline
    Week 11 (Aug 10–16)
    Mon 10 Aug 14:15-16:00 Exercise session (Ville)
    Tue 11 Aug 16:15-18:00 Exercise session (Ville)
    Wed 12 Aug 10:00 Deadline of exercise rounds 4 and 5
    Thu 13 Aug 10:15-12:00 Topic: No-SQL Databases
    Lecture by Prof. Keijo Heljanko
    Thu 13 Aug 14:15-16:00 Exercise session (Etna)
    Fri 14 Aug 10:15-12:00 Exercise session (Etna)
    Week 12 (Aug 17–23)
    Thu 20 Aug 10:15-11:45 Topic: Course Summary Review
    Led by Prof. Nitin Sawhney and Dr. Lukas Ahrenberg
    Week 13 (Aug 24–30)
    TBA TA help sessions for project groups (book a slot here)
    Fri 28 Aug 20:00 Project Part II deadline
    Week 14 (Aug 31 – Sep 06)
    Thu 03 Sep 09:00-12:00 Final Examination