Databases and SQL (5cr)

Code: 5G00HF75-3001

General information

Enrolment period: 01.01.2026 - 22.02.2026; Registration for introductions has not started yet.

Timing: 01.01.2026 - 10.05.2026; The implementation has not yet started.

Credits: 5 cr

Campus: TAMK Main Campus

Teaching languages: Finnish

Seats: 0 - 50

Teachers: Esa Parkkila

Person in charge: Esa Parkkila

Groups: VAO
Optional Professional Studies

Course: 5G00HF75

Objectives (course unit)

The student is familiar with the design and implementation of relational databases.

The student understands the role of databases as a technical data repository and learns to retrieve data from a database

The student is able to export data from a database, which can be further processed using, for example, data analytics or artificial intelligence methods.

The student learns the SQL query language, which is used to process data in relational databases. The student is able to add, read, update and delete data in databases.

Content (course unit)

Design and implementation of relational databases and the SQL language. Relational database management system, its operation and data processing using it.

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

The student is able to design and implement a relational database and perform SQL queries on the database.

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

The student is able to design and implement a relational database and perform SQL queries on the database. The student is able to take data snapshots from the database.

Assessment criteria, excellent (5) (course unit)

The student is able to design and implement a relational database and perform a variety of SQL queries on the database. The student is able to take data snapshots from the database based on SQL queries.

Assessment scale

0-5