Database Programming
| Structure Type: | Study unit |
|---|---|
| Code: | DU00BS11 |
| Curriculum: | TK 2025 |
| Level: | Bachelor of Business Administration |
| Year of Study: | 2 (2026-2027) |
| Semester: | Spring |
| Credits: | 5 cr |
| Responsible Teacher: | Ulvinen, Tero |
| Language of Instruction: | Finnish |
Learning Outcomes
The course objectives of the course are provide skills to design
databases (tables), to be able to install and use database
management systems, be familiar with the SQL standards, and
be able to use advanced features of SQL language.
After completing the course, the student
• is able to design large databases.
• is able to install and configure database systems.
• is able to use advanced features of the SQL language.
• is familiar with SQL standards.
Student's Workload
135 hours
Prerequisites / Recommended Optional Courses
Introduction to Programming
Databases
Contents
• Database system installation
• Database Design and Normalization
• Consistency requirements, foreign keys, constraints, etc.
• SQL commands and their advanced features (e.g.
tansactions)
• SQL standards
Mode of Delivery / Planned Learning Activities and Teaching Methods
Online Learning
Assessment Criteria
The course is assessed on a scale of 0 to 5.
1-2:
The student is familiar with SQL standards, can install database
system software, design simple database solutions, and use
some advanced SQL command features.
3-4:
The student is able to apply SQL standards (e.g., use standardcompliant data types), install and configure database system
software, design versatile database solutions, and utilize
advanced SQL command features more comprehensively than
average.
5:
The student demonstrates a deep understanding of SQL
standards by designing cross platform database solutions that
are independent of the database management systems
(DBMS). The student is able to migrate database solutions from
one system to another. The student demonstrates excellent
skills in using advanced features of SQL commands.