Databases and SQL (5cr)
Code: DA00EZ79-3001
General information
- Enrollment
- 10.11.2025 - 21.11.2025
- Registration for introductions has not started yet.
- Timing
- 12.01.2026 - 31.12.2026
- 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 - 200
- Degree programmes
- Degree Programme in Data Analytics
- Teachers
- Veijo Vänttinen
- Teacher in charge
- Veijo Vänttinen
- Groups
-
DAKV25SVData analytics, online studies
- Course
- DA00EZ79
Unfortunately, no reservations were found for the realization Databases and SQL DA00EZ79-3001. It's possible that the reservations have not yet been published or that the realization is intended to be completed independently.
Objective
You understand the operating principles and purposes of relational databases.
You are able to search, filter, and parse data in a relational database using the SQL language.
You recognise the uses and possibilities of the SQL language.
Content
What are the operating principles of relational databases?
How do you make a connection to a relational database?
How can the SQL language be used to search for and modify the data needed for analysis?
Evaluation
Students can
a. use professional vocabulary systematically
c. identify interrelated tasks
e. use the key models, methods, software and techniques of the data analytics
Course material
The material required for the course is provided on the Learn platform. For example, Google's Collaboration platform can be used as a development environment.
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
The course has one project assignment that can involve business collaboration.
Timing of exams and assignments
The course has 3 - 4 assessed assignments.
Student workload
1 credit = 27 hours of work
Course part description
The course consists of three parts:
- SQL queries
- data modeling
- project work
Evaluation scale
1-5
Assessment methods and criteria
The course assessment is based on assessed assignments.