Siirry suoraan sisältöön

Data Management Systems 2Laajuus (5 op)

Tunnus: IC10026

Laajuus

5 op

Opetuskieli

  • englanti

Vastuuhenkilö

  • Jyri Kemppainen

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
  • ICNS23
    Insinöö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