Data Management Systems 2Laajuus (5 cr)
Code: IC10026
Credits
5 op
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
-
ICNS23Bachelor 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