Entry requirements

30 credits in information systems or the equivalent including 7.5 credits in databases

Learning outcomes

Regarding knowledge and understanding the student is expected to be able to on completion of the course:

• summarize how NoSQL databases work,
• describe central concepts in Big Data.

Regarding competence and skills the student is expected to be able to on completion of the course:

• apply advanced techniques in relational databases, such as indexes, views, triggers, cursors, and stored procedures,
• design and manage NoSQL databases,
• implement database transaction management.

Regarding judgement and approach the student is expected to be able to on completion of the course:

• evaluate database implementations in a given context
• reflect on how the use of databases and data storage can affect an individual, organisation, and society from an ethical perspective.

Content

The course provides an in-depth study of relational databases where transaction management and multi-user systems are treated. The course also includes in-depth study of SQL with exercises in working with views, indexes, triggers and stored procedures. Furthermore, different types of NoSQL databases are studied with a focus on their use in applications and their functionality. The course also addresses the concept of Big Data and areas of use for different types of databases. The course also deals with ethical aspects of how the design and use of various forms of databases and data storage affect individuals, organizations and society.

Instruction

The course is given in the form of lectures, seminars, and labs.

Assessment

The course is examined through seminars and assignments.

If there are special reasons for doing so, an examiner may make an exception from the method of assessment indicated and allow a student to be assessed by another method. An example of special reasons might be a certificate regarding special pedagogical support from the University's disability coordinator or a decision by the department's working group for study matters.