Databases
| Structure Type: | Study unit |
|---|---|
| Code: | DU00BS06 |
| Curriculum: | TK 2025 |
| Level: | Bachelor of Business Administration |
| Year of Study: | 1 (2025-2026) |
| Semester: | Autumn |
| Credits: | 5 cr |
| Responsible Teacher: | Ulvinen, Tero |
| Language of Instruction: | Finnish |
Learning Outcomes
The aim of the course is to give basic skills for making database queries and maintaining a relational database.
Upon completion of the course the student
• understands the operating principle of relational databases,
the meaning of tables and columns, and their dependencies.
• can make queries to the tables of a relational database using
the SQL language.
• can design and implement a simple relational database using
a database program and the SQL language.
Student's Workload
135 hours
Prerequisites / Recommended Optional Courses
-
Contents
• Basic usage of a database program
• Operating principle of a relational database (tables and
columns)
• The basics of the SQL query language and making queries
• Using SQL functions
• Design and implementation of the tables and joins in a simple
database
Mode of Delivery / Planned Learning Activities and Teaching Methods
Online Learning
Assessment Criteria
The course is assessed on a scale of 0 to 5.
1-2:
The student can use a database program and make simple queries to a pre-made relational database using the SQL
language.
3-4:
The student can use a database program and make simple queries to a pre-made relational database using the SQL
language. The student can join tables in queries and use some SQL functions
5:
The student can use a database program and make simple queries to a pre-made relational database using the SQL
language. The student can join tables in queries and use some SQL functions. The student can design and implement a simple
relational databse using a database program and the SQL language.