Transaction control, isolation levels, SELECT query and transactions, deadlock and its detection.
Procedural languages in relational databases, procedures and functions, packages, deterministic functions, triggers.
Normal forms and data schemes in relational databases.
Definition of SQL, technical manuals
Lectures, projects, seminary
Attendance in seminary is optional, credit is acquired after simple project presentation and succesful written credit exam (select statement).
During course, a non-trivial example for PL/SQL will be released. Its elaboration is optional, the result however will be included to final rating. The course is finished with final written exam.