Skip to main content

Data Management Systems 2Laajuus (5 cr)

Code: IC10026

Credits

5 op

Teaching language

  • English

Responsible person

  • Jyri Kemppainen

Objective

- you understand various data models and you are able to apply them into efficient and appropriate database design
- you learn to install and upgrade database management systems
- you know how to tune database and database query processing performance
- you are able to manage data security, privacy, and integrity
- you know how to perform data backup and recovery

Content

- Schema on write and schema on read data models and their implementations
- Triggers and routines
- Stored procedures and functions
- Optimization
- Transactions
- Extension of relational database management systems
- Document databases
- Database administration
- Data security
- Large database solutions

Enrollment

01.10.2024 - 31.10.2024

Timing

07.01.2025 - 28.02.2025

Number of ECTS credits allocated

5 op

Mode of delivery

Contact teaching

Campus

Wärtsilä Campus Karjalankatu 3

Teaching languages
  • English
Seats

10 - 60

Degree programmes
  • Degree Programme in Information and Communication Technology
Teachers
  • Jyri Kemppainen
  • Ossi Laakkonen
Teacher in charge

Joni Ranta

Groups
  • ICNS23
    Bachelor of Engineering, Information Technology, Full-time Studies, Fall, 2023

Objective

- you understand various data models and you are able to apply them into efficient and appropriate database design
- you learn to install and upgrade database management systems
- you know how to tune database and database query processing performance
- you are able to manage data security, privacy, and integrity
- you know how to perform data backup and recovery

Content

- Schema on write and schema on read data models and their implementations
- Triggers and routines
- Stored procedures and functions
- Optimization
- Transactions
- Extension of relational database management systems
- Document databases
- Database administration
- Data security
- Large database solutions

Evaluation scale

H-5