Database Solutions (5 ECTS)
Code: TX00EY31-3002
General information
- Enrollment
- 02.12.2024 - 31.12.2024
- Registration for the implementation has ended.
- Timing
- 01.01.2025 - 16.03.2025
- Implementation has ended.
- Number of ECTS credits allocated
- 5 ECTS
- Mode of delivery
- On-campus
- Unit
- (2019-2024) School of ICT
- Campus
- Karaportti 2
- Teaching languages
- Finnish
- Degree programmes
- Information and Communication Technology
- Course
- TX00EY31
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