Data Management SystemsLaajuus (5 cr)

Objective

Student
- knows the principles of DBMS, base functions and purposes
- knows different kind of DBMSs
- can implement drawing of database based on requirements
- understands different kind of database models and can choose DBMS for model
- can implement database that works
- can make use of database as a part of system
- can implement different kind of database systems

Content

- SQL-language basics (queries, DML- and DDL -commands)
- normalizing
- data models
- DBMSs, especially for PostgreSQL, MySQL/MariaDB, Oracle, MS SQL Server
- going through small database application development

Execution methods

Pre-recorded theory lectures and voluntary weekly exercises.

Accomplishment methods

Exercises, project work (50%) and exam (50%).