Programming and Databases

Lehrinhalte

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)

Art der Vermittlung

Präsenzveranstaltung

Art der Veranstaltung

Pflichtfach

Empfohlene Fachliteratur

Murth, W., 2024, SQL Basics with SQLite, script, available on the Moodle website for this class

Lern- und Lehrmethode

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

Prüfungsmethode

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%).

Voraussetzungen laut Lehrplan

Meet the admission requirements for this master’s programme

Schnellinfos

Studiengang

Quantitative Asset and Risk Management (Master)

Akademischer Grad

Master

ECTS Credits

4.00

Unterrichtssprache

Englisch

Studienplan

Berufsbegleitend

Studienjahr, in dem die Lerneinheit angeboten wird

2025

Semester in dem die Lehrveranstaltung angeboten wird

1 WS

Incoming

Ja

Lernergebnisse der Lehrveranstaltung

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.

Kennzahl der Lehrveranstaltung

0613-09-07-BB-EN-04