CS-A1153 - Databases (summer course), 04.06.2020-03.09.2020
This course space end date is set to 03.09.2020 Search Courses: CS-A1153
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.7Thu 04 Jun 10:15-12:00 Topic: Introduction & Understanding Relational Models
Lecture by Prof. Nitin SawhneyWeek 2 (June 08–14)
Readings: U & W: 2.2, 2.4, 6.1 - 6.2Tue 09 Jun 16:15-18:00 Exercise session Thu 11 Jun 10:15-12:00 Topic: Relational Algebra & SQL basics
Lecture by Dr. Lukas AhrenbergThu 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.1Tue 16 Jun 16:15-18:00 Exercise session Thu 18 Jun 10:15-12:00 Topic: UML Modeling & Relational Diagrams
Lecture by Prof. Nitin SawhneyThu 18 Jun 14:15-16:00 Exercise session Week 4 (June 22–28)
Readings: U & W: 3.3.2-3.4, 3.6Tue 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.4Tue 30 Jun 16:15-18:00 Exercise session Thu 02 Jul 10:15-12:00 Topic: SQL Queries & Aggregation Operations
Lecture by Prof. Nitin SawhneyThu 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.2Thu 09 Jul 10:15-12:00 Topic: Defining SQL Tables, Integrity Constraints & Views
Lecture by Prof. Nitin SawhneyThu 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.4Tue 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 AhrenbergThu 23 Jul 14:15-16:00 Exercise session Week 9 (July 27 – Aug 02)
Readings: U & W: 7.5Mon 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 AhrenbergThu 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 AhrenbergThu 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 HeljankoThu 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 AhrenbergWeek 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