Seminar aus Datenbanken
SE 181.201 (2.0) Sommersemester 2013
Reinhard Pichler
in cooperation with Gerald Aufmuth (IBM Austria, Certified DB2 Specialist)
and Helmut Riegler (IBM Austria, Certified IT Specialist, Datawarehouse Specialist)
|
Please register until 2 March, 2013 |
General information
- Language. This course will possibly be held in English since it is part of the curriculum of the EMCL curriculum (European Master's Program in Computational Logic).
- Place. Classes will be held in the von Neumann Seminarraum (Favoritenstraße 9-11, ground floor). Only the first class (4 March) will be in the Gödel Seminarraum.
- Time.
Classes will take place on the following days.
- Monday 4 March, 11:00 sharp - 13:00: first class (Gödel Seminarraum).
- Monday 8 April, 09:00 - 11:00: students' presentations, reserve (if needed).
- Monday 8 April, 11:00 - 13:00: students' presentations, part 1.
- Monday 15 April, 09:00 - 11:00: students' presentations, reserve (if needed).
- Monday 15 April, 11:00 - 13:00: students' presentations, part 2.
- Monday 22 April, 11:00 - 13:00: case study database (basics of DB2), part 1.
- Monday 29 April, 11:00 - 13:00: case study database (basics of DB2), part 2.
- Monday 6 May, 11:00 - 13:00: case study database (basics of DB2), part 3.
- Monday 13 May, 11:00 - 13:00: case study database (basics of DB2), part 4.
Prerequisites
Basic knowledge in database systems to the extent of the undergraduate lectures "Datenmodellierung" and "Datenbanksysteme" is an indispensable prerequisite for this seminar. Knowledge in XML and related technologies as taught in the lecture "Semistrukturierte Daten" is very helpful but not absolutely necessary.Registration
Registration in TISS is required for this seminar!!
(Attention: registration != subscription)
Contents and Course Structure
Several topics in the area of Database Administration are studied in this course with emphasis on:- Availability
- Database Security
- Storage Management
- Performance Management/Optimization
- Data Concurrency and Consistency
In the first part of the seminar, students are requested to collect material on some aspect of the above topics and prepare a written report and an oral presentation. The focus is on generally applicable concepts - independent of concrete products.
In the second part of the seminar, we will discuss these concepts on a concrete database system, namely DB2. Students will then be requested to extend their written reports from the first part by a brief reflection where the general concepts are juxtaposed with the concrete realization.
The knowledge acquired in this seminar enables the students to pass the certification as IBM Certified Database Associate. IBM Austria invites every participant of this seminar to do the certification exam free of charge. For details, see below. Please note that the certification exam is optional and independent of the course assessment.
Course Material
First class on 4 March: General information, DB2 specific information, information on DB2 certifications
Course Assessment
Presence in the classes is compulsory. Assessment for the "Seminar aus Datenbanken" will be based on:- written report (8-10 pages)
- oral presentation (ca. 20 min, depending on number of participants)
- reflection (1-2 pages)
Moreover, active participation in the discussions is expected. The details will be fixed in the first class.
DB2 Certification
IBM Austria invites every participant of this seminar to do the certification exam free of charge. This exam corresponds to the certification as IBM Certified Database Associate.
The certification exam will take place at IBM (Obere Donaustraße 95, 1020 Wien) towards the end of the semester. Details will be provided in the first class of the seminar. For further information, see also DB2 on Campus Initiative.
| Last modified 19 February, 2013 |