| INFB Database Programming | Course | INF | |
|---|---|---|---|
| Lecturers : |
Dr. Susanne Busse eMail |
Term | 4 |
| Course Classification : | Informatics Bachelor, Core elective modules B-INF-Profil | CH | 4 |
| Language : | Deutsch | Type | L E |
| Type of examination : | PL | Credits | 5 |
| Method of evaluation : | written examination 120 min | ||
| Requirements : | |||
| Cross References : | |||
| Previous knowledges : | Databases I | ||
| Aids and special features : | Mode of assessment Course examination / oral examination with prerequisite exercises | ||
| Teaching aims : | Knowledge and understanding of transaction concept and DBMS recovery functionality Knowledge and understanding of database programming variations and the standardisation developed in SQL 200x Ability to use selected methods of database application programming in exercises using own relational database Knowledge and understanding of important performance aspects, the functions of optimizer components in RMBMS and tuning database applications | ||
| Contents : | Advanced transaction concept and recovery | ||
| Literature : | Ramez Elmasri / Shamkant B. Navathe Grundlagen von Datenbanksystemen PEARSON Studium 2002 Heuer, A. / Saake, G., Sattler, K.-U.: Datenbanken mitp Verlag 2001; Heuer, A. / Saake, G. Datenbanken Implementierungs-techniken MITP-Verlag; Kevin Kline, Lee Gould & Andrew Zanevsky Transact-SQL Programming; Gunter Saake, Kai-Uwe Sattler: Datenbanken & Java JDBC,SQLJ und ODMG dpunkt.verlag; Matthias Schubert: Datenbanken, Theorie, Entwurf und Programmierung relationaler Datenbanken B.G. Teubner 2004; | ||