Opinto-opas
Opinto-opas
Vuonna 2022 alkavat ja sitä aiemmat koulutukset
Savonian uuden opinto-oppaan (2023 ja tämän jälkeen alkavat koulutukset) löydät täältä.
Basis of Education | Competence Standards | Structure of Studies | Development of Expertise | Methods and implementation | Course Table |
EF21SP Bachelor Degree Programme in Information Technology (Internet of Things)
Course Description
Code | 4 EFA8040 |
Name | Data Management and SQL |
Credits | 5 cr |
Credits in Foreign Language | 5 cr |
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 |
Requirements | Exercises and exam. |
Grading Scale | 0 - 5 |
Course material | Electronic materials will be announced at the start of the course |
Prerequisites | |
Other considerations | |
Contact | Kellomäki Markku |
<< Takaisin opintojaksotaulukkoon
Pidätämme oikeuden opetussuunnitelmien muutoksiin mm. opiskeltavien sisältöjen päivitystarpeiden takia.