|
Database Programming with Oracle (DBprog)
- Lecturers
- Dipl.-Inf. Thomas Fischer, Dipl.-Inf. Frank Lauterwald
- Details
- Übung
2 cred.h, benoteter certificate
nur Fachstudium, Sprache Deutsch
Time and place: Mon 8:30 - 10:00, 00.151-113
- Fields of study
- WPF IuK-MA-ES-INF 1-3
WPF IuK-MA-KN-INF 1-3
WPF IuK-MA-MMS-INF 1-3
WPF INF-BA-V-DB ab 6
WPF INF-MA 1-3
WPF IuK-MA-ÜTMK-INF 1-3
WPF WINF-BA 6
- Prerequisites / Organisational information
- Inhalt: http://www6.informatik.uni-erlangen.de/DE/teaching/curriculum/dbpg/
StudOn: http://www.studon.uni-erlangen.de/crs441551.html
- Contents
- UeDBprog:
Database Modelling
SQL - DDL, loading data
SQL - Queries
SQL - DML and Tricky SQL
Views, PL/SQL and Triggers
Access from JAVA (JDBC)
Java Persistence API
Object-Relational Extensions in SQL (in Oracle)
Optimization and access control
- Recommended literature
- Oracle 11g-Dokumentation
Anthony Molinaro: SQL Cookbook
- Additional information
- Expected participants: 30
- Verwendung in folgenden UnivIS-Modulen
- Startsemester SS 2012:
- Database Practice with Oracle (DBP)
- Department: Chair of Computer Science 6 (Data Management)
|
|
|