inf009 - Database Practical (Complete module description)

Module label	Database Practical
Modulkürzel	inf009
Credit points	6.0 KP
Workload	180 h
Institute directory	Department of Computing Science
Verwendbarkeit des Moduls	Bachelor's Programme Business Informatics (Bachelor) > Akzentsetzungsbereich Praktische Informatik und Angewandte Informatik Bachelor's Programme Computing Science (Bachelor) > Akzentsetzungsbereich - Wahlbereich Informatik Dual-Subject Bachelor's Programme Computing Science (Bachelor) > Praktische Vertiefung (60 KP) Master of Education Programme (Gymnasium) Computing Science (Master of Education) > Wahlpflichtmodule (Praktische Informatik) Master of Education Programme (Hauptschule and Realschule) Computing Science (Master of Education) > Mastermodule Master of Education Programme (Vocational and Business Education) Computing Science (Master of Education) > Praktische Vertiefung der Informatik
Zuständige Personen	Grawunder, Marco (module responsibility) Lehrenden, Die im Modul (Prüfungsberechtigt)
Prerequisites	Useful prior knowlegde : Basics of data base systems
Skills to be acquired in this module	The objective of this module is to gather practical experience on databases and information systems. The students get an overview of the technical realisation, implementation and optimisation of a professional database management system. Professional competence The students: Realise, implement and program data base systems Program and implement database-oriented system routines Implement optimisation goals in the modelling phase Administer professional database systems (installation, maintenance and adjustment) Recognise database systems' performance problems and are able to fix them with according methods Organise and control processes of database systems Methodological competence The students: propose concrete processing principles for special application classes reflect on specific technologies and procedures with regard to their consequences Social competence The students: Solve database system problems in a team Self-competence The students: Acknowledge the limits of their ability to cope with pressure during the implementation and are aware of failures Reflect their self-perception
Module contents	The module “Practical Course Databases” is a related practical course of the module “Information Systems I”. The objectives of this module are special technical concepts of a database system and practical solutions in database programming and optimisation. Contents of this module are: System-oriented database management programming, Implementation of catalogue systems, Optimisation strategies based on parallelisation and partitioning requirements
Literaturempfehlungen	Ramez Elmasri und Shamkant B. Navathe (2007). Fundamentals of Databases Systems. Fifth Edition, Pearson/Addison Wesley Held Andrea (2005), Oracle 10g Hochverfügbarkeit Addison-Wesley - Held Andrea (2015), Oracle 12c New Features Addison Wesley Feuerstein Steven, Pribyl Bill, Dawes Chip (2007).Oracle PL/SQL. 4. Auflage, O'Reillys Taschenbibliothek
Links
Language of instruction	German
Duration (semesters)	1 Semester
Module frequency	every winter term
Module capacity	unlimited
Teaching/Learning method	P

Examination	Prüfungszeiten	Type of examination
Final exam of module	During the lecture time	Practical Exercises

Form of instruction	Exercises
SWS	4
Frequency	WiSe
Workload Präsenzzeit	56 h