Advanced Databases (5 cr)
Code: 4A00HB48-3001
General information
Enrolment period
09.06.2025 - 07.09.2025
Timing
01.08.2025 - 31.12.2025
Credits
5 op
Mode of delivery
Contact teaching
Unit
Business Information Systems
Campus
TAMK Main Campus
Teaching languages
- Finnish
Degree programmes
- Degree Programme in Business Information Systems
Teachers
- Jari Aalto
Person in charge
Jari Aalto
Groups
-
24TIKOOT1
Objectives (course unit)
The course objectives of the course are provide skills to design databases (tables), to be able to install and use database management systems, be familiar with the SQL standards, and be able to use advanced features of SQL language.
After completing the course, the student
• Is able to design large databases.
• Is able to install and configure database systems.
• Is able to use advanced features of the SQL language.
• Is familiar with SQL standards.
Content (course unit)
• Database system installation
• Database design and normalization
• Consistency requirements, foreign keys, constraints, etc.
• SQL commands and their advanced features (e.g. transactions)
• SQL standards
Prerequisites (course unit)
Introduction to Programming
Databases
Assessment criteria, satisfactory (1-2) (course unit)
The student is familiar with SQL standards, is able to install and manage database management systems (DBMS), is able to design simple database designs, and use some advanced features of SQL commands.
Assessment criteria, good (3-4) (course unit)
The student is able to apply SQL standards in database designs (e.g. knowledge about non-standard data types), able to install and configure database management systems (DBMS), design moderately complex database solutions, and use moderately advanced features of SQL commands.
Assessment criteria, excellent (5) (course unit)
The student demonstrates a deep understanding of SQL standards by designing cross platform database solutions that are independent of the database management systems (DBMS). The student is able to migrate database solutions from one system to another. The student demonstrates excellent skills in using advanced features of SQL commands.
Assessment scale
0-5