Study Guide

#savoniaUAS

Curricula starting in 2022 and earlier

Technology, Kuopio
Technology, Varkaus
Design, Kuopio
Business, Kuopio
Music and Dance, Kuopio
Tourism and Hospitality
Social Services and Health Care, Kuopio
Social Services and Health Care, Iisalmi
Natural resources, Iisalmi
Multidisciplinary Studies

Savonia's new Study Guide (curriculum starting in 2023 and after) can be found here.

Basis of Education Competence Standards Structure of Studies Development of Expertise Methods and implementation Course Table

Course Description

Code4 EFA8040
NameData Management and SQL
Credits5 ects
ObjectivesYou 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
ContentData 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
RequirementsExercises and exam.
Grading Scale0 - 5
Course materialElectronic materials will be announced at the start of the course
Prerequisites
Other Considerations
Contact
Kellomäki Markku

 

We reserve the right to make changes to the curriculum due to the need to update the content being studied.