Database Solutions (5 cr)
Code: TX00EY31-3001
General information
Enrollment
06.05.2024 - 18.08.2024
Timing
19.08.2024 - 13.10.2024
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
School of ICT
Campus
Myllypurontie 1
Teaching languages
- Finnish
Seats
0 - 35
Degree programmes
- Information and Communication Technology
Teachers
- Amir Dirin
Groups
-
TVT22-OOhjelmistotuotanto
Objective
The student masters the principles and key practices of physical database design. The student is able to implement the database in such a way that it is of high quality in terms of structure, performance and data security. He / she is familiar with time-related data storage techniques and understands the principles that govern simultaneous use of a database. He knows the problem field of object-relational mapping and masters its main techniques.
Content
- Database server installation and configuration
- Database indexing
- Query optimization
- Transactions
- Concurrency management techniques
- Storing time-bound data
- Views, triggers, stored procedures, and events
- Access and security
- Database backup
- Object-relational mapping and its technical solutions.
Evaluation scale
0-5
Assessment criteria, satisfactory (1)
The student has achieved the course objectives fairly. The student will be able to identify, define and use the course subject area’s concepts and models. The student has completed the required learning exercises in minimum requirement level.
Assessment criteria, good (3)
The student has achieved the course objectives well, even though the knowledge and skills need improvement on some areas. The student has completed the required learning exercises in good or satisfactory level. The student is able to define the course concepts and models and is able to justify the analysis.
Assessment criteria, excellent (5)
The student has achieved the objectives of the course with excellent marks. The student master commendably the course subject area’s concepts and models. The student has completed the required learning exercises in good or excellent level. The student is able to make justified and fluent analysis.
Assessment criteria, approved/failed
The student has achieved the course objectives. The student will be able to identify, define and use the course subject area’s concepts and models. The student has completed the required learning exercises.
Prerequisites
SQL, Description and Modelling Techniques.