DatabasesLaajuus (3 cr)
Code: 4A00HB32
Credits
3 op
Objectives
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
• 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)
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)
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)
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.
Enrolment period
09.06.2025 - 07.09.2025
Timing
01.08.2025 - 31.12.2025
Credits
3 op
Mode of delivery
Contact teaching
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
Groups
-
25TIKO1
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
Enrolment period
09.06.2025 - 07.09.2025
Timing
01.08.2025 - 31.12.2025
Credits
3 op
Mode of delivery
Contact teaching
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
Groups
-
25TIKO2
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
Enrolment period
09.06.2025 - 07.09.2025
Timing
01.08.2025 - 31.12.2025
Credits
3 op
Mode of delivery
Contact teaching
Unit
Business Information Systems
Campus
TAMK Main Campus
Teaching languages
- Finnish
Degree programmes
- Degree Programme in Business Information Systems
Teachers
- Anne-Mari Stenbacka
Person in charge
Anne-Mari Stenbacka
Groups
-
25TIKO3
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
Enrolment period
07.06.2024 - 23.10.2024
Timing
23.10.2024 - 13.12.2024
Credits
3 op
Mode of delivery
Contact teaching
Campus
TAMK Main Campus
Teaching languages
- Finnish
Degree programmes
- Degree Programme in Business Information Systems
Teachers
- Anne-Mari Stenbacka
Person in charge
Anne-Mari Stenbacka
Groups
-
24TIKO2
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
Enrolment period
07.06.2024 - 04.09.2024
Timing
01.08.2024 - 31.12.2024
Credits
3 op
Mode of delivery
Contact teaching
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
Groups
-
24TIKO3
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