Change language: Suomi

Front Page > Current Education > Information Technology (TT) > V2024 > Year 2 > Databases and Open Interfaces (ITTP0903)

Databases and Open Interfaces

Structure Type: Study unit
Code: ITTP0903
Curriculum: TT V2024
Level: Bachelor of Engineering
Year of Study: 2 (2025-2026)
Semester: Autumn
Credits: 5 cr
Responsible Teacher: Kankaanpää, Timo
Language of Instruction: Finnish

Learning Outcomes

After the course, the student understands the principle of the relation data base, she is able to design and implement an effective relation data base and she knows how to use the SQL inquiry language in a versatile way. The student knows the programming interfaces of SQL, she understands the principles of JSON and XML and she is able to utilize open RESTful interfaces.

Student's Workload

135 h, which includes 50 h of scheduled contact studies.

Prerequisites / Recommended Optional Courses

Introduction to Programming, Object Oriented Programming.


Relation databases, normalizing, a data base software and the most important tools (e.g. MySQL, SQLite, SQLite Studio, SQL Server, Oracle), SQL (create, insert, drop, undate, select, join, union, subinquires, indexes, transactions, limits, triggers, views) and the interfaces of SQL (ORM, CRUD). Further, the basics of JSON and XML and the techiques realeted with its use (XSD, Xpath, XSLT) and the basics of the NoSQL databases.

Recommended or Required Reading and Other Learning Resources/Tools

The web site of the course.

Mode of Delivery / Planned Learning Activities and Teaching Methods

Lectures, exercises.

Assessment Criteria

Grade 5: The student understands most of the discussed concepts, she can choose and apply them in a critical manner while designing, developing and building a practical application.
Grade 3: The student understands a significant amount of the discussed concepts, she can apply them while designing, developing and building a practical application.
Grade 1: The student understands the basic concepts discussed on the course and with guidance, she can use them while designing and building a practical application.

Assessment Methods

Continuous assessment, the grade results in from homework assignments, project works and the examination.