VAMK

Change language: Suomi

Front Page > Study Search > Database Programming (IT00BT01)

Database Programming

Structure Type: Study unit
Code: IT00BT01
Curriculum: IT 2025 / 2026
Level: Bachelor of Engineering
Year of Study: 1 (2025-2026 / 2026-2027)
Semester: Spring
Credits: 5 cr
Responsible Teacher: Dams, Johan
Language of Instruction: English

Courses

Impl.Group(s)Study TimeTeacher(s)LanguageEnrolment
3001IT2025, IT2025-A, IT2025-B2026-02-16 – 2026-07-31Johan DamsEnglish2025-12-01 – 2026-02-18

The descriptions shown below are for the academic year: 2025-2026

Learning Outcomes

After completing the course, you will be able to design and implement a database scheme and use a database both through the management system (DBMS) as well as through a programming language. You will learn key concepts and syntax of SQL, NoSQL and XML databases, know what normalization and data integrity is, what constraints are and how to use them. With SQL, you will be able to use main SQL commands (SELECT, INSERT, UPDATE, DELETE), joins and sub-queries, aggregations and groupings, and create views. Through a programming language and API (e.g., JDBC or other) you will learn how to effectively use a database from within an application and how to perform optimization and query performance tuning as well as security considerations to take into account. You will also know what ORM is, which tools are available, and how they are used.

Contents

Database schema’s, SQL, NoSQL, XML, DBMS, database manipulation from within applications.


Back