Data Management SystemsLaajuus (5 cr)
Course unit code: LTD6036
General information
- Credits
- 5 cr
- 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
Execution methods
Pre-recorded theory lectures and voluntary weekly exercises.
Accomplishment methods
Exercises, project work (50%) and exam (50%).