Databases (5 cr)
Code: DA00EK57-3001
General information
Enrollment
06.04.2022 - 22.04.2022
Timing
29.08.2022 - 31.12.2022
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Department of Business
Campus
Kouvola Campus
Teaching languages
- Finnish
Seats
20 - 40
Degree programmes
- Degree Programme in Data Analytics
Teachers
- Väinö Toots
Groups
-
DAKV21SPData-analytics, full-time studies
Objective
You can describe a relational database.
You can collect data from business databases for analyzing with SQL-language.
You know the basics of the data warehouse.
Content
How to use databases?
How to collect data from business databases with SQL-language?
How to take advantage of data warehouse in business intelligence?
Opiskelumateriaali
Web materials
Yksilölliset oppimisväylät
Individual learning tracks can be discussed about with the lecturer
TKI ja työelämäyhteistyö
The course may have assignments made for companies or assignments agreed individually with students.
Opiskelijan työmäärä
1 cr = 27 hours work
Toteutuksen osien kuvaus
Kurssilla opetellaan tietokantojen perusteita sekä SQL-kyselykieltä.
SQL-kielessä kurssi kattaa peruskomennot, laskemisen kyselyssä, ryhmittelyn, usean taulun kyselyt sekä alikyselyt.
Evaluation scale
1-5
Assessment methods and criteria
Evaluation according given exercises and projects.