Databases (5 cr)
Code: DA00EK57-3003
General information
Enrollment
08.04.2024 - 21.04.2024
Timing
02.09.2024 - 31.12.2024
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Distance learning
Unit
Department of Business
Campus
Ecampus
Teaching languages
- Finnish
Seats
20 - 60
Degree programmes
- Degree Programme in Data Analytics
Teachers
- Väinö Toots
Teacher in charge
Väinö Toots
Groups
-
DAKV23SVData analytics, online 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
Azure SQL database (SQL Server) is used on the course for practicing database queries. The connection is established and queries are made using Azure Data Studio software. Each student will have own login to the database
Yksilölliset oppimisväylät
Individual learning tracks can be discussed with the lecturer
TKI ja työelämäyhteistyö
Collaboration with Dataamo-projects database
Opiskelijan työmäärä
1 credit = 27 hours of work
Evaluation scale
1-5
Assessment methods and criteria
Evaluation is based on graded assignments