Data Management and SQLLaajuus (5 op)
Tunnus: 4_EFA8040
Laajuus
5 op
Osaamistavoitteet
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
Sisältö
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
Oppimateriaalit
Electronic materials will be announced at the start of the course
Ilmoittautumisaika
01.08.2024 - 15.09.2024
Ajoitus
30.08.2024 - 31.12.2024
Laajuus
5 op
Toteutustapa
Lähiopetus
Yksikkö
Kansainväliset AMK-koulutukset
Toimipiste
Varkauden kampus
Opetuskielet
- Englanti
Tutkinto-ohjelma
- Degree Programme in Industrial Management
Opettaja
- Markku Kellomäki
- Keijo Kuosmanen
Opiskelijaryhmät
-
IM23SPIndustrial Management
Toteutuksen kuvaus
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 and a final exam
Opiskelijan ajankäyttö
28h lectures
28h exercises in classroom
68h independent work
Oppimateriaali ja suositeltava kirjallisuus
Electronic materials will be announced at the start of the course
Ilmoittautumisaika
01.08.2024 - 15.09.2024
Ajoitus
01.08.2024 - 31.12.2024
Laajuus
5 op
Toteutustapa
Lähiopetus
Yksikkö
Kansainväliset AMK-koulutukset
Toimipiste
Microkadun kampus
Opetuskielet
- Englanti
Tutkinto-ohjelma
- Degree Programme in Internet of Things
Opettaja
- Keijo Kuosmanen
Opiskelijaryhmät
-
IT23SPInformation Technology IOT
Toteutuksen kuvaus
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 and a final exam
Opiskelijan ajankäyttö
28h lectures
28h exercises in classroom
68h independent work
Oppimateriaali ja suositeltava kirjallisuus
Electronic materials will be announced at the start of the course
Ilmoittautumisaika
01.12.2023 - 15.01.2024
Ajoitus
07.01.2024 - 30.04.2024
Laajuus
5 op
Toteutustapa
Lähiopetus
Yksikkö
Kansainväliset AMK-koulutukset
Toimipiste
Microkadun kampus
Opetuskielet
- Englanti
Opettaja
- Keijo Kuosmanen
Opiskelijaryhmät
-
EF22SPBachelor Degree Programme in Information Technology IOT
Toteutuksen kuvaus
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 and a final exam
Opiskelijan ajankäyttö
28h lectures
28h exercises in classroom
68h independent work
Oppimateriaali ja suositeltava kirjallisuus
Electronic materials will be announced at the start of the course
Lisätietoja opiskelijoille
https://moodle.savonia.fi/course/view.php?id=1244
Ilmoittautumisaika
01.12.2022 - 15.01.2023
Ajoitus
01.01.2023 - 31.07.2023
Laajuus
5 op
Toteutustapa
Lähiopetus
Yksikkö
Kansainväliset AMK-koulutukset
Toimipiste
Microkadun kampus
Opetuskielet
- Englanti
Opettaja
- Markku Kellomäki
Ajoitusryhmät
- Exercise group A (Koko: 20. Avoin AMK: 0.)
- Exercise group B (Koko: 20. Avoin AMK: 0.)
Opiskelijaryhmät
-
EF21SPBachelor Degree Programme in Information Technology IOT
Koulutusryhmat
- Exercise group A
- Exercise group B
Toteutuksen kuvaus
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.
Opiskelijan ajankäyttö
28h lectures
14h exercises in classroom
93h independent work
Oppimateriaali ja suositeltava kirjallisuus
Electronic materials will be announced at the start of the course