Skip to main content

Database ProgrammingLaajuus (3 cr)

Code: KTVP063

Credits

3 op

Objective

Students will be able to design the structure of a relational model based database and create software which uses it.

Content

Relational database design
SQL queries
Programming interface

Assessment criteria, excellent (5)

The students are able to apply their learning to different tasks in a variety of ways.

Assessment criteria, good (3)

The students are able to use the methods they learn during the course appropriately.

Assessment criteria, satisfactory (1)

The students know and are proficient in the basic concepts of the course.

en
Enrollment

30.12.2024 - 26.01.2025

Timing

01.01.2025 - 31.07.2025

Number of ECTS credits allocated

3 op

Mode of delivery

Contact teaching

Unit

Teknologia

Teaching languages
  • Finnish
Degree programmes
  • Bachelor’s Degree in Business Information Technology
Teachers
  • Janne Remes
Groups
  • TTK23SPO
    TTK23SPO
  • TTK23SP
    TTK23SP

Objective

Students will be able to design the structure of a relational model based database and create software which uses it.

Content

Relational database design
SQL queries
Programming interface

Evaluation scale

0 - 5

Assessment criteria, excellent (5)

The students are able to apply their learning to different tasks in a variety of ways.

Assessment criteria, good (3)

The students are able to use the methods they learn during the course appropriately.

Assessment criteria, satisfactory (1)

The students know and are proficient in the basic concepts of the course.

Prerequisites

Tietokantojen perusteet

en
Enrollment

01.12.2023 - 31.01.2024

Timing

01.01.2024 - 31.07.2024

Number of ECTS credits allocated

3 op

Mode of delivery

Contact teaching

Unit

Teknologia

Teaching languages
  • English
Degree programmes
  • Bachelor’s Degree in Business Information Technology
Teachers
  • Janne Remes
Groups
  • TTK22SPO
    TTK22SPO

Objective

Students will be able to design the structure of a relational model based database and create software which uses it.

Content

Relational database design
SQL queries
Programming interface

Evaluation scale

0 - 5

Assessment criteria, excellent (5)

The students are able to apply their learning to different tasks in a variety of ways.

Assessment criteria, good (3)

The students are able to use the methods they learn during the course appropriately.

Assessment criteria, satisfactory (1)

The students know and are proficient in the basic concepts of the course.

Prerequisites

Tietokantojen perusteet

en
Enrollment

01.12.2023 - 31.01.2024

Timing

01.01.2024 - 31.07.2024

Number of ECTS credits allocated

3 op

Mode of delivery

Contact teaching

Unit

Teknologia

Teaching languages
  • Finnish
Degree programmes
  • Bachelor’s Degree in Business Information Technology
Teachers
  • Vesa Vaihoja
Groups
  • TTK22SPORaahe
    TTK22SPORaahe
  • TTK22SPRaahe
    TTK22SPRaahe

Objective

Students will be able to design the structure of a relational model based database and create software which uses it.

Content

Relational database design
SQL queries
Programming interface

Evaluation scale

0 - 5

Assessment criteria, excellent (5)

The students are able to apply their learning to different tasks in a variety of ways.

Assessment criteria, good (3)

The students are able to use the methods they learn during the course appropriately.

Assessment criteria, satisfactory (1)

The students know and are proficient in the basic concepts of the course.

Prerequisites

Tietokantojen perusteet

en
Enrollment

02.12.2022 - 31.01.2023

Timing

01.01.2023 - 31.07.2023

Number of ECTS credits allocated

3 op

Mode of delivery

Contact teaching

Unit

Teknologia

Teaching languages
  • Finnish
Degree programmes
  • Bachelor’s Degree in Business Information Technology
Teachers
  • Vesa Vaihoja
Groups
  • TTK21SPORaa
    TTK21SPORaa

Objective

Students will be able to design the structure of a relational model based database and create software which uses it.

Content

Relational database design
SQL queries
Programming interface

Evaluation scale

0 - 5

Assessment criteria, excellent (5)

The students are able to apply their learning to different tasks in a variety of ways.

Assessment criteria, good (3)

The students are able to use the methods they learn during the course appropriately.

Assessment criteria, satisfactory (1)

The students know and are proficient in the basic concepts of the course.

Prerequisites

Tietokantojen perusteet

en
Enrollment

02.12.2022 - 31.01.2023

Timing

01.01.2023 - 31.07.2023

Number of ECTS credits allocated

3 op

Mode of delivery

Contact teaching

Unit

Teknologia

Teaching languages
  • English
  • Finnish
Degree programmes
  • Bachelor’s Degree in Business Information Technology
Teachers
  • Janne Remes
Groups
  • TTK21SPO
    TTK21SPO

Objective

Students will be able to design the structure of a relational model based database and create software which uses it.

Content

Relational database design
SQL queries
Programming interface

Evaluation scale

0 - 5

Assessment criteria, excellent (5)

The students are able to apply their learning to different tasks in a variety of ways.

Assessment criteria, good (3)

The students are able to use the methods they learn during the course appropriately.

Assessment criteria, satisfactory (1)

The students know and are proficient in the basic concepts of the course.

Prerequisites

Tietokantojen perusteet

en
Enrollment

02.12.2021 - 31.01.2022

Timing

01.01.2022 - 31.07.2022

Number of ECTS credits allocated

3 op

Mode of delivery

Contact teaching

Unit

Teknologia

Teaching languages
  • Finnish
Degree programmes
  • Bachelor’s Degree in Business Information Technology
Teachers
  • Vesa Vaihoja
Groups
  • TTK20SPRaahe
    TTK20SPRaahe

Objective

Students will be able to design the structure of a relational model based database and create software which uses it.

Content

Relational database design
SQL queries
Programming interface

Evaluation scale

0 - 5

Assessment criteria, excellent (5)

The students are able to apply their learning to different tasks in a variety of ways.

Assessment criteria, good (3)

The students are able to use the methods they learn during the course appropriately.

Assessment criteria, satisfactory (1)

The students know and are proficient in the basic concepts of the course.

Prerequisites

Tietokantojen perusteet

en
Enrollment

01.12.2021 - 31.01.2022

Timing

01.01.2022 - 31.07.2022

Number of ECTS credits allocated

3 op

Mode of delivery

Contact teaching

Unit

Teknologia

Teaching languages
  • Finnish
Degree programmes
  • Bachelor’s Degree in Business Information Technology
Teachers
  • Niko Kinnunen
Groups
  • TTK20SPO
    TTK20SPO
  • TTK20SP
    TTK20SP

Objective

Students will be able to design the structure of a relational model based database and create software which uses it.

Content

Relational database design
SQL queries
Programming interface

Evaluation scale

0 - 5

Assessment criteria, excellent (5)

The students are able to apply their learning to different tasks in a variety of ways.

Assessment criteria, good (3)

The students are able to use the methods they learn during the course appropriately.

Assessment criteria, satisfactory (1)

The students know and are proficient in the basic concepts of the course.

Prerequisites

Tietokantojen perusteet