Homepage

Advanced databases - Schedule for spring 2022

All lectures are held online on Thursdays (13.1.-21.4.) at 9.15-11.30

Note: please check the material and watch the related video before attending the online lecture! We are following the idea of flipped classroom: thus I can concentrate answering questions and helping you to proceed in your group work.

Date	Themes	Exercises/Quizzes	Due	Additional info/material (video recording)
13.1.	Course introduction	Moodle: quiz 1	20.1.	Objectives of this course, assignments/evaluation and some practical arrangements (30 mins video)
	Learning report	Set your own goals	20.1.	Return it to Moodle (Learning reports folder)
	Assignment: database project	Choose a topic and project group => tell them to the teacher	20.1.	An example solution
	SQL, modelling, and DB implementation test (self-evaluation)	Exercise 1: 1.1. SQL test + 1.2. design and implement a customer database	20.1.	Listen and watch the assignment (An example solution will be shown in Moodle)
20.1.	Database design goals	Moodle: quiz 2	27.1.	Objectives of DB design
	Modelling exercise: Hotel-room-reservation	Exercise 2	27.1.
27.1.	Relational and NoSQL databases	Write your notes to the learning diary		Optional: listen the related video from YouTube
	DBA roles and tasks	Moodle: quiz 3	3.2.	Optional: examine one DBMS, e.g. SQL Server or Oracle
	MySQL administration	Write your notes to the learning diary	3.2.	MySQL Workbench
	Nice-to-know: MariaDB and history of MySQL	Examine MariaDB web site
	Database Analysis	Start your group work
	Some food for thought: Conceptual Modelling	Exercise 3	3.2.	Data modelling video, part 1
3.2.	Logical data modelling			Data modelling video, part 2
	Target World Analysis	Exercise 4 and related quiz 4	10.2.	Analysing data needs; interviews
	Requirements Specification	Create the short req. spec. (SRS) about your topic
10.2.	Normalization (part 1)	Exercise 5	17.2.	Normalization video, part 1
	Normalization (part 2)			Normalization video, part 2
	From UML class diagrams to relational model	Moodle: quiz 5	17.2.	related video / Object-relational mapping
17.2.	Physical DB design and PDM	DB management plan & physical design + Moodle: quiz 6	24.2.	video
	Transaction management, lesson 1	Exercises 1.1-1.7 (+ Moodle: quiz 7)	24.2.	video
	Deploy and use VLE or Install lab environment (DBTech_debian11_2021_11.ova)
24.2.	Transaction management, lesson 2	Exercises 2.1-2.7	10.3.	Use VLE or Install lab environment (DBTech_debian11_2021_11.ova)
	Database Security	Include a security plan for your own database (=> DBMP); Moodle: quiz 8	10.3.
	Midterm course evaluation		24.2. (10.3.)
10.3.	Index Design	Exercises in a virtual machine, e.g. VLE or Debian10_2019_08.ova or older DebianDB_VM6; Moodle: quiz 9	17.3.
	Automating tasks by creating procedures, triggers and functions	Create procedure		Data generation procedure
17.3.	Data warehouse design	Moodle: quiz 10	24.3.	Examine tools and services, DW design video
	Reverse engineering	Exercise: Install and reverse engineer a database
24.3.	Instructions for exam	Document your database project	14./21.4.
	Creating a prototype through ODBC	Create a simple CRUD UI to your database	14./21.4.
	Group work and personal guidance	Write the final report	28.4.
31.3.	Exam, part 1	Data modelling (and database management)		Note: you can do both exams during the same day if you want
7.4.	Exam, part 2	Database management		Note: you can do both exams during the same day if you want
14.4.	Exam return; quidance for group work, the first presentations
21.4.	Presentations	Return all assignments to Moodle	28.4.
	Summary & course evaluation	Give the official feedback for this course	28.4.
28.4.	Re-exam

Last update: 21.3.2022