Moses - DBPRA Datenbankpraktikum

Display language

Diese Modulbeschreibung gilt nicht im aktuellen Semester.

Die Modulbeschreibung gilt nur für den Zeitraum SoSe 2022 - WiSe 2022/23. Die Version für das aktuelle Semester (SoSe 2024) finden Sie hier: Modulbeschreibung des SoSe 2024

Module / Version:
#40400 / #8

Validity:
SoSe 2022 - WiSe 2022/23

Default display language:
German

Module title:
DBPRA Datenbankpraktikum
DBPRA Database lab course

Credits:
6

Responsible person:
Markl, Volker

Grading:
benotet

Type of exam:
Portfolioprüfung

Zugehörigkeit

Faculty:
Fakultät IV

Institute:
Institut für Softwaretechnik und Theoretische Informatik

Area of expertise:
34351500 FG Datenbanksysteme und Informationsmanagement (DIMA)

Prüfungsausschuss:
No information

Kontakt

Office:
EN 7

Contact person:
Soto, Juan

E-mail address:
sekr@dima.tu-berlin.de

Website:

https://www.tu.berlin/dima

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	VZ
DBPRA - Datenbankpraktikum	PR	0434 L 481	WiSe/SoSe	No information	4

Workload and Credit Points

DBPRA - Datenbankpraktikum (PR):

Workload description	Multiplier	Hours	Total
No information	1.0	15.0h	15.0h
No information	15.0	4.0h	60.0h
No information	15.0	7.0h	105.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:

This module has no requirements.

Module completion

Grading

graded

Type of exam

Portfolio examination

Type of portfolio examination

100 Punkte insgesamt

Language

German

Test elements

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

Grading scale

Notenschlüssel »Notenschlüssel 2: Fak IV (2)«

Gesamtpunktzahl	1.0	1.3	1.7	2.0	2.3	2.7	3.0	3.3	3.7	4.0
100.0pt	95.0pt	90.0pt	85.0pt	80.0pt	75.0pt	70.0pt	65.0pt	60.0pt	55.0pt	50.0pt

Test description (Module completion)

No information

Duration of the Module

The following number of semesters is estimated for taking and completing the module:
1 Semester.

This module may be commenced in the following semesters:
Winter- und Sommersemester.

Maximum Number of Participants

The maximum capacity of students is 30.

Registration Procedures

No information

Recommended literature
No recommended literature given

Assigned Degree Programs

Semester:

Zeige auch ausgelaufene Studiengänge und StuPOs

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

	Studiengang / StuPO	StuPOs	Verwendungen	Erste Verwendung	Letzte Verwendung
This module is not used in any degree program.

No information

Miscellaneous

No information

DBPRA Datenbankpraktikum

Zugehörigkeit

Kontakt

Learning Outcomes

Content

Module Components

Pflichtteil:

Workload and Credit Points

DBPRA - Datenbankpraktikum (PR):

Description of Teaching and Learning Methods

Requirements for participation and examination

Desirable prerequisites for participation in the courses:

Mandatory requirements for the module test application:

Module completion

Grading

Type of exam

Type of portfolio examination

Language

Test elements

Grading scale

Notenschlüssel »Notenschlüssel 2: Fak IV (2)«

Test description (Module completion)

Duration of the Module

Maximum Number of Participants

Registration Procedures

Recommended reading, Lecture notes

Lecture notes

Electronical lecture notes

Literature

Assigned Degree Programs

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

Miscellaneous