Database Solutions (5 ECTS)
Code: TX00CR58-3011
General information
- Enrollment
- 20.12.2021 - 06.03.2022
- Registration for the implementation has ended.
- Timing
- 14.03.2022 - 08.05.2022
- Implementation has ended.
- Number of ECTS credits allocated
- 5 ECTS
- Mode of delivery
- On-campus
- Unit
- (2019-2024) School of ICT
- Campus
- Myllypurontie 1
- Teaching languages
- English
- Seats
- 20 - 40
- Degree programmes
- Information and Communication Technology
- Teachers
- Vesa Ollikainen
- Course
- TX00CR58
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.
Further information
Course is open for all who meet the prerequisites.
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.
Execution methods
In-class tuition.
Accomplishment methods
Assignments.
Project work.
Exam.