Data Management SystemsLaajuus (5 cr)
Code: LTD6036
Credits
5 op
Teaching language
- Finnish
Responsible person
- Mikko Anttonen
- Joni Ranta
- Jyri Kemppainen
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