Data Management Systems (5 cr)
Code: DT10010-3001
General information
- Enrollment
- 01.10.2022 - 31.10.2022
- Registration for the implementation has ended.
- Timing
- 01.01.2023 - 28.05.2023
- Implementation has ended.
- Number of ECTS credits allocated
- 5 cr
- Local portion
- 5 cr
- Mode of delivery
- Contact learning
- Unit
- Tradenomi / Tietojenkäsittely (DD)
- Teaching languages
- Finnish
- 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
-
DTNS22Information Technology (BBA), Full-time Studies, Fall, 2022
- Small groups
- Pienryhmä 1
- Pienryhmä 2
- Course
- DT10010
Evaluation scale
H-5
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
Location and time
- 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
Teaching methods
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