Navigation To modulepage
Display language

Database lab course



#40400 / #6

SS 2017 - WS 2020/21

Fakultät IV

EN 7

Institut für Softwaretechnik und Theoretische Informatik

34351500 FG Datenbanksysteme und Informationsmanagement

Markl, Volker

Kutsche, Ralf-Detlef

POS-Nummer PORD-Nummer Modultitel
31150 24941 Datenbankpraktikum
3880 27435 Datenbankpraktikum

Learning Outcomes

Students are capable of applying the contents of the database module "Information Systems and Data Analytics" to concrete application cases. Particularly, knowledge in the use, and administration of a database management system will be achieved.


Goal of this module is the practical application of the theoretical content of the database lecture "Information Systems and Data Analytics". The practical applications include use of SQL as data definition, data manipulation, and authorization language, and the embedding of SQL into another programming language. Furthermore, the process architecture of database systems and the basics of database administration (e.g. building indexes or materialized views, analysis of query plans and query optimization based on statistics) are taught. For the lab work, a commercial object-relational database system is used. As programming language we use Java and JDBC to communicate with the database system.

Module Components


All Courses are mandatory.

Course Name Type Number Cycle Language SWS
DBPRA - Datenbankpraktikum PR 0434 L 481 WS/SS No information 4

Workload and Credit Points

DBPRA - Datenbankpraktikum (PR):

Workload description Multiplier Hours Total
No information 15.0 7.0h 105.0h
No information 1.0 15.0h 15.0h
No information 15.0 4.0h 60.0h
180.0h(~6 LP)
The Workload of the module sums up to 180.0 Hours. Therefore the module contains 6 Credits.

Description of Teaching and Learning Methods

No information

Requirements for participation and examination

Desirable prerequisites for participation in the courses:

No information

Mandatory requirements for the module test application:

No information

Module completion



Type of exam

Portfolio examination

Type of portfolio examination

100 points in total



Test elements

Name Points Categorie Duration/Extent
No information 40 oral No information
No information 60 practical No information

Grading scale

Test description (Module completion)

No information

Duration of the Module

This module can be completed in one semester.

Maximum Number of Participants

The maximum capacity of students is 90.

Registration Procedures

No information

Recommended reading, Lecture notes

Lecture notes

Availability:  unavailable

Electronical lecture notes

Availability:  unavailable


Recommended literature
No recommended literature given.

Assigned Degree Programs

This module is used in the following Degree Programs (new System):


No information