Databases

This topic covers the following topics:

Terminology related to databases. Data modeling and database design. Relational database systems and SQL. Database integrity. Normalization. Transaction handling and multi-user issues. Security. Introduction of alternatives to relational database (NoSQL). Link between database and programming.

Knowledge: The candidate must:

• know central concepts (in Norwegian and English) within databases, and be able to explain these
• understand problems related to several simultaneous users of a database and know how these can be solved (transactions)
• know the theory behind the relational model
• know about alternatives to relational databases (NoSQL and semi-structured data)

Skills: The candidate must:

• be able to create a separate database, and extract and change the data in this database, all via SQL
• see the connection between program code and underlying SQL / database
• be able to optimize SQL queries for performance
• be able to construct a data model (EER) for a given problem and translate this into the relational model
• be able to use basic NoSQL solutions to store and access semi-structured data
• be able to analyze different requirements from applications
• could propose sustainable solutions for storing data related to normalization and re-use of data

General competence: The candidate must:

• gain an understanding of applying database solutions to solve various needs for the storage and representation of digital data
• gain an understanding of security challenges in database systems
• understand what good data quality is
• be able to interact with AI tools about database topics

Teaching with practical exercises and discussion forum.