Navigation To modulepage
Display language

Datenbankpraktikum
Database lab course

6 LP

German

#40400 / #6

Seit SS 2017

Fakultät IV

EN 7

Institut für Softwaretechnik und Theoretische Informatik

34351500 FG Datenbanksysteme und Informationsmanagement

Markl, Volker

Kutsche, Ralf-Detlef

sekr@dima.tu-berlin.de

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.

Content

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

Pflichtteil:

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

Grading:

graded

Type of exam:

Portfolio examination

Language:

German

Typ 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

1.01.31.72.02.32.73.03.33.74.0
95.090.085.080.075.070.065.060.055.050.0

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

Literature

Recommended literature
No recommended literature given.

Assigned Degree Programs

Zur Zeit wird die Datenstruktur umgestellt. Aus technischen Gründen wird die Verwendung des Moduls während des Umstellungsprozesses in zwei Listen angezeigt.

This module is used in the following modulelists:

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

    Miscellaneous

    No information