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
Enrollment
01.10.2021 - 31.10.2021
Timing
10.01.2022 - 25.02.2022
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Distance learning
Campus
Wärtsilä Campus Karjalankatu 3
Teaching languages
- Finnish
Seats
20 - 120
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
-
DTNS21Information Technology (BBA), Full-time Studies, Fall, 2021
Small groups
- Pienryhmä 1
- Pienryhmä 2
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
Evaluation scale
H-5