Databases (3 cr)

Code: 4A00HB32-3003

General information

Enrolment period: 07.06.2024 - 04.09.2024; Registration for the implementation has ended.

Timing: 01.08.2024 - 31.12.2024; Implementation has ended.

Credits: 3 cr

Mode of delivery: Contact learning

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: 4A00HB32

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