Stud.IP Uni Oldenburg
University of Oldenburg
19.11.2019 17:24:09
inf009 - Database Practical (Complete module description)
Original version English Download as PDF
Module label Database Practical
Module code inf009
Credit points 6.0 KP
Workload 180 h
Faculty/Institute Department of Computing Science
Used in course of study
  • Bachelor's Programme Business Informatics (Bachelor) >
  • Bachelor's Programme Computing Science (Bachelor) >
  • Dual-Subject Bachelor's Programme Computing Science (Bachelor) >
  • Master of Education Programme (Vocational and Business Education) Computing Science (Master of Education) >
Contact person
Module responsibility
Authorized examiners
Entry requirements
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
     

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
Reader's advisory
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 jährlich
Module capacity unlimited
Modullevel AS (Akzentsetzung / Accentuation)
Modulart je nach Studiengang Pflicht oder Wahlpflicht
Lern-/Lehrform / Type of program P
Vorkenntnisse / Previous knowledge Informationssysteme I
Betriebssystemkenntnisse
Examination Time of examination Type of examination
Final exam of module
At the end of the lecture period
Oral exam
Course type Practical
SWS 4.00
Frequency WiSe
Workload attendance 56 h