Data Management SystemsLaajuus (5 cr)
Course unit code: DT10010
General information
- Credits
- 5 cr
- Teaching language
- Finnish
- Responsible person
- Mikko Anttonen, Vastuuopettaja
Objective
- you know the principles of DBMS, base functions and purposes
- you know different kind of DBMSs
- you know how to implement drawing of database based on requirements
- you understand the differences between different data models and you know how to choose the right database for your data model
- you know how to design and implement database correctly.
- you know how to use database as a part of system
- you know how to use 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