Data Management and SQLLaajuus (5 cr)
Code: 4_EFA8040
Credits
5 op
Learning objectives
You understand principles of relational database design and their mechanics
You are familiar with Database Management Systems and areas of usage
You are able to create database design diagrams and implement them to real databases
You are able to use graphical and shell based Database Management Systems
You are able to utilize databases as part of information system
Content
Data management concepts
Designing relational databases
Concept analysis and Entity Relationship-diagrams (ER-diagrams)
Data models
Basics of SQL language
Database Management Systems (eg. MariaDB)
Steps to database based application development
Materials
Electronic materials will be announced at the start of the course
Enrollment
01.08.2024 - 15.09.2024
Timing
30.08.2024 - 31.12.2024
Credits
5 op
Mode of delivery
Contact teaching
Teaching languages
- English
Degree programmes
- Degree Programme in Industrial Management
Teachers
- Markku Kellomäki
- Keijo Kuosmanen
Student groups
-
IM23SPIndustrial Management
Teaching methods
You understand principles of relational database design and their mechanics
You are familiar with Database Management Systems and areas of usage
You are able to create database design diagrams and implement them to real databases
You are able to use graphical and shell based Database Management Systems
You are able to utilize databases as part of information system
Flipped learning is utilized in this course.
Completion of the course is based on personal assignments
Student workload
28h lectures
28h exercises in classroom
68h independent work
Materials
Electronic materials will be announced at the start of the course
Enrollment
01.08.2024 - 15.09.2024
Timing
01.08.2024 - 31.12.2024
Credits
5 op
Mode of delivery
Contact teaching
Teaching languages
- English
Degree programmes
- Degree Programme in Internet of Things
Teachers
- Keijo Kuosmanen
Student groups
-
IT23SPInformation Technology IOT
Teaching methods
You understand principles of relational database design and their mechanics
You are familiar with Database Management Systems and areas of usage
You are able to create database design diagrams and implement them to real databases
You are able to use graphical and shell based Database Management Systems
You are able to utilize databases as part of information system
Flipped learning is utilized in this course.
Completion of the course is based on personal assignments
Student workload
28h lectures
28h exercises in classroom
68h independent work
Materials
Electronic materials will be announced at the start of the course
Enrollment
01.12.2023 - 15.01.2024
Timing
07.01.2024 - 30.04.2024
Credits
5 op
Mode of delivery
Contact teaching
Teaching languages
- English
Teachers
- Keijo Kuosmanen
Student groups
-
EF22SPBachelor Degree Programme in Information Technology IOT
Teaching methods
You understand principles of relational database design and their mechanics
You are familiar with Database Management Systems and areas of usage
You are able to create database design diagrams and implement them to real databases
You are able to use graphical and shell based Database Management Systems
You are able to utilize databases as part of information system
Flipped learning is utilized in this course.
Completion of the course is based on personal assignments
Student workload
28h lectures
28h exercises in classroom
68h independent work
Materials
Electronic materials will be announced at the start of the course
Further information
https://moodle.savonia.fi/course/view.php?id=1244
Enrollment
01.12.2022 - 15.01.2023
Timing
01.01.2023 - 31.07.2023
Credits
5 op
Mode of delivery
Contact teaching
Teaching languages
- English
Teachers
- Markku Kellomäki
Scheduling groups
- Exercise group A (Size: 20. Open UAS: 0.)
- Exercise group B (Size: 20. Open UAS: 0.)
Student groups
-
EF21SPBachelor Degree Programme in Information Technology IOT
Education groups
- Exercise group A
- Exercise group A
Teaching methods
You understand principles of relational database design and their mechanics
You are familiar with Database Management Systems and areas of usage
You are able to create database design diagrams and implement them to real databases
You are able to use graphical and shell based Database Management Systems
You are able to utilize databases as part of information system
Flipped learning is utilized in this course.
Student workload
28h lectures
14h exercises in classroom
93h independent work
Materials
Electronic materials will be announced at the start of the course