Databases (5 cr)
Code: DA00EK57-3001
General information
- Enrollment
- 06.04.2022 - 22.04.2022
- Registration for the implementation has ended.
- Timing
- 29.08.2022 - 31.12.2022
- Implementation has ended.
- Number of ECTS credits allocated
- 5 cr
- Local portion
- 5 cr
- Mode of delivery
- Contact learning
- Unit
- Department of Business
- Campus
- Kouvola Campus
- Teaching languages
- Finnish
- Seats
- 20 - 40
- Degree programmes
- Degree Programme in Data Analytics
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?
Evaluation
Students can
use professional vocabulary systematically.
identify interrelated tasks.
use the key models, methods, software and techniques of the professional field.
Course material
Web materials
Study forms and methods
Individual learning tracks can be discussed about with the lecturer
RDI and work-related cooperation
The course may have assignments made for companies or assignments agreed individually with students.
Student workload
1 cr = 27 hours work
Course part description
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.