Database SolutionsLaajuus (5 cr)

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

Qualifications

SQL, Description and Modelling Techniques

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.