732A57 · 6 credits · Advanced level (A1F) · Datavetenskap

Database Technology

Active · next start HT 2026

69%

passed the latest ordinary exam

TENT · 12 Jan 2026 · 13 students

82%

passed the ordinary exams, all sittings over the last 5 years

TENT · 72 students

Part of 1 programme

Exam

82% passed · 72 students

66% passed · 29 students

Pass the re-exam: 66% (29 students), compared with 82% (72 students) on the ordinary exam
Get B or A: 38% (101 students)

Show small sittings (6)

Sittings with fewer than 5 students, often credit transfers or special sittings. They are not part of any figure on this page.

Partial exams, hand-ins and labs. They are not part of the figures at the top.

Hand-in or lab

100% passed · 46 students

100% passed · 6 students

Pass a later round: 100% (6 students), compared with 100% (46 students) on the ordinary exam

Show small sittings (16)

Sittings with fewer than 5 students, often credit transfers or special sittings. They are not part of any figure on this page.

After completing the course, the student shall be able to:

Explain and use the most important concepts in databases and database technology correctly.
Design a data model using EER modeling.
Design, implement, and use a relational database.
Explain the theoretical basis of the relational model and use this to determine if a relational database has a good design.
Explain which file structures in the database management system can be used to implement a database.
Explain the basic principles of how to index a database and design an index with good efficiency.
Explain the problems that can arise when the database handles many users and some possible solutions to this.
Explain how the database can ensure that data is persistent and, given the desired properties of the database, explain how this is solved with database recovery and backup.
Explain the main principles behind heuristic query optimization, and given a query, calculate the optimized query and estimate how effective the optimization has been.

The course covers theoretical and practical knowledge of principles for:

Storage and retrieval of information in a modern database system.
General database management systems (DBMS).
Methods for database design and database use.
Data modeling techniques: EER model, relational databases, database-specific data structures, SQL relational algebra and query optimization, transactions, concurrency control, recovery.