Data Management Systems (5 cr)
Code: DT10010-3002
General information
Enrollment
01.10.2023 - 31.10.2023
Timing
08.01.2024 - 11.03.2024
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Campus
Wärtsilä Campus Karjalankatu 3
Teaching languages
- Finnish
Seats
10 - 90
Degree programmes
- Degree Programme in Business Information Technology
Teachers
- Mika Matveinen
- Mikko Anttonen
Teacher in charge
Mikko Anttonen
Scheduling groups
- Pienryhmä 1 (Size: 50. Open UAS: 0.)
- Pienryhmä 2 (Size: 50. Open UAS: 0.)
Groups
-
DTNS23Information Technology (BBA), Full-time Studies, Fall, 2023
Small groups
- Excercise Team 1
- Excercise Team 2
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
Evaluation scale
H-5