Database Solutions (5 cr)
Code: TX00EY31-3006
General information
- Enrollment
-
02.12.2024 - 14.01.2025
Registration for the implementation has ended.
- Timing
-
13.01.2025 - 16.03.2025
Implementation has ended.
- Number of ECTS credits allocated
- 5 cr
- Local portion
- 5 cr
- Mode of delivery
- On-campus
- Unit
- (2019-2024) School of ICT
- 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 |
|---|---|---|
|
Mon 13.01.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3006 |
MPA5027
Oppimistila
|
|
Thu 16.01.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3006 |
MPA5027
Oppimistila
|
|
Mon 20.01.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3006 |
MPA5027
Oppimistila
|
|
Thu 23.01.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3006 |
MPA5027
Oppimistila
|
|
Mon 27.01.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3006 |
MPA5027
Oppimistila
|
|
Thu 30.01.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3006 |
MPA5027
Oppimistila
|
|
Mon 03.02.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3006 |
MPA5027
Oppimistila
|
|
Thu 06.02.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3006 |
MPA5027
Oppimistila
|
|
Mon 10.02.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3006 |
MPA5027
Oppimistila
|
|
Thu 13.02.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3006 |
MPA5027
Oppimistila
|
|
Mon 24.02.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3006 |
MPA5027
Oppimistila
|
|
Thu 27.02.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3006 |
MPA5027
Oppimistila
|
|
Mon 03.03.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3006 |
MPA5027
Oppimistila
|
|
Thu 06.03.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3006 |
MPA5027
Oppimistila
|
|
Mon 10.03.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3006 |
MPA5027
Oppimistila
|
|
Thu 13.03.2025 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3006 |
MPA5027
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