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
• 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
• 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
• have an understanding of what good data quality is

Online teaching with practical exercises and discussion forum.