Weekly Schedule
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 |