Database Solutions (5 cr)
Code: TX00EY31-3001
General information
- Enrollment
-
06.05.2024 - 18.08.2024
Registration for the implementation has ended.
- Timing
-
19.08.2024 - 13.10.2024
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
- Teachers
- Amir Dirin
- Course
- TX00EY31
Implementation has 16 reservations. Total duration of reservations is 48 h 0 min.
| Time | Topic | Location |
|---|---|---|
|
Mon 19.08.2024 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3001 |
MPA5027
Oppimistila
|
|
Tue 20.08.2024 time 13:00 - 16:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3001 |
MPA5027
Oppimistila
|
|
Mon 26.08.2024 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3001 |
MPA5027
Oppimistila
|
|
Tue 27.08.2024 time 13:00 - 16:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3001 |
MPA5027
Oppimistila
|
|
Mon 02.09.2024 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3001 |
MPA5027
Oppimistila
|
|
Tue 03.09.2024 time 13:00 - 16:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3001 |
MPA5027
Oppimistila
|
|
Mon 09.09.2024 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3001 |
MPA5027
Oppimistila
|
|
Tue 10.09.2024 time 13:00 - 16:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3001 |
MPA5027
Oppimistila
|
|
Mon 16.09.2024 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3001 |
MPA5027
Oppimistila
|
|
Tue 17.09.2024 time 13:00 - 16:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3001 |
MPA5027
Oppimistila
|
|
Mon 23.09.2024 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3001 |
MPA5027
Oppimistila
|
|
Tue 24.09.2024 time 13:00 - 16:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3001 |
MPA5027
Oppimistila
|
|
Mon 30.09.2024 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3001 |
MPA5027
Oppimistila
|
|
Tue 01.10.2024 time 13:00 - 16:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3001 |
MPA5027
Oppimistila
|
|
Mon 07.10.2024 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3001 |
MPA5027
Oppimistila
|
|
Tue 08.10.2024 time 13:00 - 16:00 (3 h 0 min) |
Tietokantaratkaisut TX00EY31-3001 |
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