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
Responsible persons
Grawunder, Marco (module responsibility)
Lehrenden, Die im Modul (Prüfungsberechtigt)
Prerequisites
Information Systems I
Operating system knowledge
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
Recommended reading
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