UnivIS
Information system of Friedrich-Alexander-University Erlangen-Nuremberg © Config eG 
FAU Logo
  Collection/class schedule    module collection Home  |  Legal Matters  |  Contact  |  Help    
search:      semester:   
 
 Layout
 
printable version

 
 
 Also in UnivIS
 
course list

lecture directory

 
 
events calendar

job offers

furniture and equipment offers

 
 

  Database Programming with Oracle (DBprog)

Lecturers
Dipl.-Inf. Thomas Fischer, Dipl.-Ing. Niko Pollner

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/crs657771.html

Contents
  • 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: 20
Registration is required for this lecture.
Registration starts on Friday, 1.3.2013, 00:01 and lasts till Sunday, 14.4.2013, 23:59 über: StudOn.

Verwendung in folgenden UnivIS-Modulen
Startsemester SS 2013:
Database Practice with Oracle (DBP)

Department: Chair of Computer Science 6 (Data Management)
UnivIS is a product of Config eG, Buckenhof