Data Management Systems 2Laajuus (5 cr)
Course unit code: IC10026
General information
- Credits
- 5 cr
- Teaching language
- English
- Responsible person
- Jyri Kemppainen, Vastuuopettaja
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