Database Systems 2

Lecturer:

Vladimír Hora

Tutor:

Vladimír Hora

Supervisor:

Computing Centre

Synopsis:

Data models in practise, bussiness rules and integrity constraints. Server programming, procedural languages, rules, triggers, stored procedures. RDMS in multiuesr environment. Capita selecta from RDMS.

Requirements:

175XDS1 or other relevant course recommended

Syllabus of lectures:

Syllabus of tutorials:

Study Objective:

Understanding of application of RDMS in real-word problems and environments.

Study materials:

[1] firemní manuály Oracle, DB2, PostgreSQL

Momjian, Bruce: PostgreSQL: introduction and concepts

http://www.postgresql.org

Gilfillan Ian: Myslíme v MySQL 4

Note:

Time-table for winter semester 2011/2012:

Time-table is not available yet

Time-table for summer semester 2011/2012:

	06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon	roomTH:B-377 Hora V. 17:00–17:50 (lecture parallel1) Thákurova 7 (FSv-budova A) B377roomTH:B-377 Hora V. 18:00–18:50 (lecture parallel1 parallel nr.101) Thákurova 7 (FSv-budova A) B377
Tue
Fri
Thu
Fri

The course is a part of the following study plans: