Database Solutions (5 ECTS)
Code: TX00EY31-3003
General information
- Enrollment
- 05.05.2025 - 17.08.2025
-
Enrollment is ongoing
Enroll to the implementation in OMA
- Timing
- 18.08.2025 - 19.10.2025
- The implementation has not yet started.
- Number of ECTS credits allocated
- 5 ECTS
- Mode of delivery
- On-campus
- Unit
- School of ICT and Industrial Management
- Campus
- Myllypurontie 1
- Teaching languages
- Finnish
- Seats
- 0 - 35
- Degree programmes
- Information and Communication Technology
Implementation has 16 reservations. Total duration of reservations is 48 h 0 min.
| Time | Topic | Location |
|---|---|---|
|
Wed 20.08.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3003 |
Online
|
|
Fri 22.08.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3003 |
MPA5023
Oppimistila
|
|
Wed 27.08.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3003 |
Online
|
|
Fri 29.08.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3003 |
MPA5023
Oppimistila
|
|
Wed 03.09.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3003 |
Online
|
|
Fri 05.09.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3003 |
MPA5023
Oppimistila
|
|
Wed 10.09.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3003 |
Online
|
|
Fri 12.09.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3003 |
MPA5023
Oppimistila
|
|
Wed 17.09.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3003 |
Online
|
|
Fri 19.09.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3003 |
MPA5023
Oppimistila
|
|
Wed 24.09.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3003 |
Online
|
|
Fri 26.09.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3003 |
MPA5023
Oppimistila
|
|
Wed 01.10.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3003 |
Online
|
|
Fri 03.10.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3003 |
MPA5023
Oppimistila
|
|
Wed 08.10.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3003 |
Online
|
|
Fri 10.10.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3003 |
MPA5023
Oppimistila
|
Objective
The student
• is proficient in the principles and key practices of physical database design
• is able to implement the database in such a way that it is of high quality in terms of structure, performance and data security
• is familiar with time-related data storage techniques and understands the principles that govern simultaneous use of a database
• knows the problem field of object-relational mapping and knows its key 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 objectives of the course to a satisfactory level
• is able to identify and define the concepts, models and in the subject area of the course
• has completed the learning tasks required for the course to the minimum standard.
Assessment criteria, good (3)
The student
• has achieved the objectives of the course well
• is able to identify, define and use the concepts, models and tools in the subject area of the course
• has completed the learning tasks of the course at a good level.
Assessment criteria, excellent (5)
The student
• has achieved the objectives of the course with excellent marks
• is able to identify, define and use and apply the concepts and models in the subject area of the course in a variety of ways
• has completed the learning tasks of the course at an excellent level and has put considerable own effort into their solutions.
Assessment criteria, approved/failed
The student
• has achieved the objectives of the course
• is able to identify and define the concepts, models and in the subject area of the course
• has completed the learning tasks required for the course.
Qualifications
SQL, Description and Modelling Techniques