Skip to main content

Databases (5 cr)

Code: 4A00HH76-3002

General information


Enrolment period
08.06.2026 - 06.09.2026
Registration for introductions has not started yet.
Timing
01.08.2026 - 31.12.2026
The implementation has not yet started.
Credits
5 cr
Unit
Business Information Systems
Campus
TAMK Main Campus
Teaching languages
Finnish
Degree programmes
Degree Programme in Business Information Systems
Teachers
Jere Käpyaho
Person in charge
Jere Käpyaho
Course
4A00HH76

Objectives (course unit)

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.

Content (course unit)

• 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

Assessment criteria, satisfactory (1-2) (course unit)

The student can use a database program and make simple queries to a pre-made relational database using the SQL language.

Assessment criteria, good (3-4) (course unit)

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.

Assessment criteria, excellent (5) (course unit)

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.

Assessment scale

0-5

Go back to top of page