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

     

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

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

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

http://www-is.informatik.uni-oldenburg.de/227/

At the end of the lecture period

Oral exam