Programming and Databases

Brief description

Basics of Databases, Queries and Basics of SQL: Relational databases: Primary/foreign key; Queries: Criteria, Operators, Aggregate Functions; Introduction to SQLite; General Programming structures: Declaration - Input - Processing - Output, Branches, Loops, Data types; Basic Skills in statistical software (e.g. R, SPSS, SAS or Minitab)

Mode of delivery

face to face

Type

compulsory

Planned learning activities and teaching methods

Interactive work in computer labs, discussion of exercises and examples.

Assessment methods and criteria

This course is based on continuous assessment (30%) and a final written exam (70%). The continuous assessment consists of active participation in class (15%) and three home assignments to be uploaded on the Moodle platform before the respective deadlines (15%).

Prerequisites and co-requisites

Meet the admission requirements for this master’s programme

Infos

Degree programme

Quantitative Asset and Risk Management (Master)

Cycle

Master

ECTS Credits

4.00

Language of instruction

English

Curriculum

Part-Time

Academic year

2025

Semester

1 WS

Incoming

Yes

Learning outcome

After the successful completion of the course students demonstrate basic knowledge concerning relational databases and are able to use queries in Structured Query Language (SQL). They are able to store, manipulate and retrieve data in databases. Furthermore, they are able to join data sets. They demonstrate basic programming knowledge (definition of variables, assignment of values to variables, if-statements, for- and while-loops, logical operators, arrays). Additionally, the students are able to operate statistical software such as R which is advantageous when dealing with large data sets or complex algorithms.

Course code

0613-09-07-BB-EN-04

Programming and Databases