Official course description, subject to change:
Basic info last published 1/10-20

Introduction to Database Systems, SWU

Course info
Language:
English
ECTS points:
7.5
Course code:
BSINDBS1KU
Participants max:
15
Offered to guest students:
yes
Offered to exchange students:
yes
Offered as a single subject:
yes
Price (single subject):
10625 DKK (incl. vat)
Programme
Level:
Bachelor
Programme:
BSc in Software Development
Staff
Course manager
Associate Professor
Course semester
Semester
Forår 2021
Start
25 January 2021
End
28 May 2021
Exam
Abstract
The course covers fundamental techniques for developing data management and data analytics applications.
Description

The course covers fundamental techniques for developing data management and data analytics applications. The main part of the course deals with traditional relational database processing, including the theory and practice of modelling and querying a database. In the latter part of the course, the focus is on new developments for both traditional database applications and for modern data analytics applications.

Formal prerequisites

This course assumes basic ability to use a computer. We also assume that a student has taken an introductory programming course (otherwise basic programming skills in Java are expected) and a discrete math course such as Discrete Mathematic for SD (or has knowledge of basic discrete math: logic and set theory).

Intended learning outcomes

After the course, the student should be able to:

  • Write SQL queries, involving multiple relations, compound conditions, grouping, aggregation, and subqueries.
  • Use SQL programming constructs in a secure manner.
  • Suggest a database design in the E-R model and convert to a relational database schema in a suitable normal form.
  • Analyze/predict/improve query processing efficiency of the designed database using indices.
  • Reflect upon the evolution of the hardware and storage hierarchy and its impact on data management system design.
  • Discuss the pros and cons of different classes of data systems for modern analytics and data science applications.
Ordinary exam
Exam type:
A: Written exam on premises, External (7-point scale)
Exam variation:
A22: Written exam on premises with restrictions.