Data Management Systems 2Laajuus (5 op)
Tunnus: IC10026
Laajuus
5 op
Osaamistavoitteet
- 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
Sisältö
- 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
Ilmoittautumisaika
01.10.2024 - 31.10.2024
Ajoitus
07.01.2025 - 28.02.2025
Opintopistemäärä
5 op
Toteutustapa
Lähiopetus
Yksikkö
Insinöörikoulutus / Information Technology (IC)
Toimipiste
Wärtsilä-kampus Karjalankatu 3 (WÄR)
Opetuskielet
- Englanti
Paikat
10 - 60
Koulutus
- Degree Programme in Information and Communication Technology
Opettaja
- Jyri Kemppainen
- Ossi Laakkonen
Vastuuopettaja
Joni Ranta
Ryhmät
-
ICNS23Insinööri (AMK), Information Technology, päivä, syksy, 2023
Tavoitteet
- 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
Sisältö
- 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
Arviointiasteikko
H-5