Databases (5 cr)
Code: DA00EK57-3003
General information
- Enrollment
-
08.04.2024 - 21.04.2024
Registration for the implementation has ended.
- Timing
-
02.09.2024 - 31.12.2024
Implementation has ended.
- Number of ECTS credits allocated
- 5 cr
- Local portion
- 0 cr
- Virtual portion
- 5 cr
- 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
- Course
- DA00EK57
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?
Course material
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
Study forms and methods
Individual learning tracks can be discussed with the lecturer
RDI and work-related cooperation
Collaboration with Dataamo-projects database
Student workload
1 credit = 27 hours of work
Evaluation scale
1-5
Assessment methods and criteria
Evaluation is based on graded assignments