Database Solutions (5 cr)
Code: TX00CR58-3016
General information
- Enrollment
-
06.05.2024 - 20.10.2024
Registration for the implementation has ended.
- Timing
-
21.10.2024 - 15.12.2024
Implementation has ended.
- Number of ECTS credits allocated
- 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
- Vesa Ollikainen
- Course
- TX00CR58
Implementation has 15 reservations. Total duration of reservations is 45 h 0 min.
| Time | Topic | Location |
|---|---|---|
|
Thu 24.10.2024 time 13:00 - 16:00 (3 h 0 min) |
Tietokantaratkaisut TX00CR58-3016 |
MPC5014
Oppimistila
|
|
Fri 25.10.2024 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00CR58-3016 |
MPA5023
Oppimistila
|
|
Thu 31.10.2024 time 13:00 - 16:00 (3 h 0 min) |
Tietokantaratkaisut TX00CR58-3016 |
MPC5014
Oppimistila
|
|
Fri 01.11.2024 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00CR58-3016 |
MPA5023
Oppimistila
|
|
Thu 07.11.2024 time 13:00 - 16:00 (3 h 0 min) |
Tietokantaratkaisut TX00CR58-3016 |
MPA5026
Luentosali
|
|
Fri 08.11.2024 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00CR58-3016 |
MPA5023
Oppimistila
|
|
Thu 14.11.2024 time 13:00 - 16:00 (3 h 0 min) |
Tietokantaratkaisut TX00CR58-3016 |
https://metropolia.zoom.us/j/68054508762
|
|
Fri 15.11.2024 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00CR58-3016 |
https://metropolia.zoom.us/j/62865598564
|
|
Thu 21.11.2024 time 13:00 - 16:00 (3 h 0 min) |
Tietokantaratkaisut TX00CR58-3016 |
https://metropolia.zoom.us/j/68054508762
|
|
Fri 22.11.2024 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00CR58-3016 |
https://metropolia.zoom.us/j/62865598564
|
|
Thu 28.11.2024 time 13:00 - 16:00 (3 h 0 min) |
Tietokantaratkaisut TX00CR58-3016 |
https://metropolia.zoom.us/j/68054508762
|
|
Fri 29.11.2024 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00CR58-3016 |
https://metropolia.zoom.us/j/62865598564
|
|
Thu 05.12.2024 time 13:00 - 16:00 (3 h 0 min) |
Tietokantaratkaisut TX00CR58-3016 |
https://metropolia.zoom.us/j/68054508762
|
|
Thu 12.12.2024 time 13:00 - 16:00 (3 h 0 min) |
Tietokantaratkaisut TX00CR58-3016 |
MPA5026
Luentosali
|
|
Fri 13.12.2024 time 09:00 - 12:00 (3 h 0 min) |
Tietokantaratkaisut TX00CR58-3016 |
MPA5023
Oppimistila
|
Objective
Upon completing the course the student knows the principles and key practices in logical and physical database design. He/she is able to model the structure and dependencies of data. The student is able to design a relational database both on database-first and code-first basis. He/she can implement a database in such a way that its structure, performance and security are of high standards. The student is familiar with challenges in object-relational mapping, and he/she masters the key related technologies. The student understands the principles of database concurrency control.
Content
Data-first and code-first database design, normalization of databases, installation and configuration of a database server, indexing, query optimization, views, triggers, user privileges, security, backup policies, object-relational mapping and its technical solutions, means of concurrency control.
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 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.
Qualifications
Basics of object-oriented programming.
Basic SQL knowledge.
Objective
Upon completing the course the student knows the principles and key practices in logical and physical database design. He/she is able to model the structure and dependencies of data. The student is able to design a relational database both on database-first and code-first basis. He/she can implement a database in such a way that its structure, performance and security are of high standards. The student is familiar with challenges in object-relational mapping, and he/she masters the key related technologies. The student understands the principles of database concurrency control.
Content
Data-first and code-first database design, normalization of databases, installation and configuration of a database server, indexing, query optimization, views, triggers, user privileges, security, backup policies, object-relational mapping and its technical solutions, means of concurrency control.
Qualifications
Basics of object-oriented programming.
Basic SQL knowledge.
Execution methods
In-class tuition.
Accomplishment methods
Assignments.
Project work.
Exam.