Databases (5 cr)
Code: DA00EK57-3004
General information
- Enrollment
-
07.04.2025 - 21.04.2025
Registration for the implementation has begun.
- Timing
-
01.09.2025 - 31.12.2025
The implementation has not yet started.
- 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
- Veijo Vänttinen
- Teacher in charge
- Veijo Vänttinen
- Groups
-
DAKV24SVData analytics, online studies
- Course
- DA00EK57
Realization has 3 reservations. Total duration of reservations is 4 h 30 min.
| Time | Topic | Location |
|---|---|---|
|
Fri 12.09.2025 time 10:40 - 12:10 (1 h 30 min) |
Intro: Tietokannat DA00EK57-3004 |
Etäopetus lukujärjestyksen mukaan
|
|
Fri 19.09.2025 time 10:40 - 12:10 (1 h 30 min) |
Q&A: Tietokannat DA00EK57-3004 |
Etäopetus lukujärjestyksen mukaan
|
|
Fri 03.10.2025 time 10:40 - 12:10 (1 h 30 min) |
Q&A: Tietokannat DA00EK57-3004 |
Etäopetus lukujärjestyksen mukaan
|
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
Studies are based on the materials and learning tasks offered on the course's Learn platform.
Individual learning tracks can be discussed with the lecturer
RDI and work-related cooperation
Possible Collaboration with Dataamo-projects database
Timing of exams and assignments
The course includes 3 - 4 mid-term exams.
Student workload
1 credit = 27 hours of work
Evaluation scale
1-5
Assessment methods and criteria
Evaluation is based on graded assignments