Topic outline

  • Weekly Schedule


    ____________________________________________________________________________________________________________________________
    Week         Date                 Time                                       Location         Content
    ____________________________________________________________________________________________________________________________
    1    Tue - 09/04 16:15 - 18:00 U4 Introduction, Relational Algebra
    U & W: 1.1-1.2, 2.1-2.2, 2.4
       Wed - 10/04 10:15 - 12:00 T5 H01
       Thu - 11/04 TU5 H02
       Fri - 12/04 TU7 H03
    ____________________________________________________________________________________________________________________________

    2    Tue - 16/04 16:15 - 18:00 U4 Intro to SQL, SQL Tables
    U & W: 2.3, 6.1-6.5
       -
    		- No exercise session (Exam week)
       - - No exercise session (Exam week)
       - - No exercise session (Exam week)
    ____________________________________________________________________________________________________________________________

    3    Tue - 23/04 16.00 A+ Homework Round 1 (W1+W2) submission
       Tue - 23/04 16:15 - 18:00 U4 Functional Dependencies, Normal Forms
    U & W: 3.1-3.6
       Wed - 24/04 10:15 - 12:00 T5 H01
       Thu - 25/04 T6 H02
       Fri - 26/04 T5 H03
    ____________________________________________________________________________________________________________________________

    4    Tue - 30/04 16.00 A+ Homework Round 2 (W3), submission
       Tue - 30/04 16:15 - 18:00 U4 UML Modeling
    U & W: 4.7-4.8
       Thu - 02/05 12:15 - 14:00 T5 H01
       Thu - 02/05 10:15 - 12:00 T6 H02
       Fri - 03/05 10:15 - 12:00 T5 H03
    ____________________________________________________________________________________________________________________________

    5    Mon - 06/05 9.00 A+ Project Part I, open
       Tue - 07/05 16.00 A+ Homework Round 3 (W4), submission
       Tue - 07/05 16:15 - 18:00 U4 Constraints, Views, Aggregation
    U & W: 7.1-7.5, 8.1-8.2
       Wed - 08/05 10:15 - 12:00 T5 H01
       Fri - 10/05 12:15 - 14:00 T5 H02
       Fri - 10/05 10:15 - 12:00 T5 H03
    ____________________________________________________________________________________________________________________________

    6    Tue - 14/05 16.00 A+ Homework Round 4 (W5), submission
       Tue - 14/05 16:15 - 18:00 U4 Transactions, Indicies, Triggers
    U & W: 6.6, 8.3-8.4
       Wed - 15/05 10:15 - 12:00 T5 H01
       Thu - 16/05 TU7 H02
       Fri - 17/05 T5 H03
       Sun - 19/05 21.00 A+  
    ____________________________________________________________________________________________________________________________

    7    Mon - 20/05 9.00 A+ Project Part II, open
       Tue - 21/05 16.00 A+ Homework Round 5 (W6), submission
       Tue - 21/05 16:15 - 18:00 U4 Using PostgreSQL, Advanced Transactions & Data Cleaning
    B: 4.1, 4.2.I, 4.3.I
       Wed - 22/05 10:15 - 12:00 T5 H01 (Data Cleaning, B: 3.3, 3.4.1)
       Thu - 23/05 T6 H02 (Data Cleaning, B: 3.3, 3.4.1)
       Fri - 24/05 T5 H03 (Data Cleaning, B: 3.3, 3.4.1)
    ____________________________________________________________________________________________________________________________

    8    Tue - 28/05 16.00 A+ Homework Round 6 (W5), submission
       Tue - 28/05 16:15 - 18:00 Health Technology, F239a Data Visualization & Analysis, Python Libraries & Web Interfaces
    U & W: 10.2, 10.4
       Wed - 29/05 10:15 - 12:00 T5 H01
       Thu - 30/05 T6 H02
       Fri - 31/05 T5 H03
    ____________________________________________________________________________________________________________________________

    9    Tue - 04/06 16:15 - 18:00 Online NoSQL: Guest Lecture by Prof. Keijo Heljanko, University of Helsinki
    -
       Wed - 05/06 10:15 - 12:00 T6 H01
       Thu - 06/06 T6 H02
       Fri - 07/06 T5 H03
       Fri - 07/06 21.00 A+  
    ____________________________________________________________________________________________________________________________

    10    Tue - 11/06 16:15 - 18:00 Online Reflection + Presentation
    -
       Fri - 14/06 21.00 A+  
    ____________________________________________________________________________________________________________________________

◄ Previous section
Tutorials and Guides