Advanced education in database systems, with developing of students' ability to involve in real-world projects of database design and implementation.

Students will get hands-on experience with: designing stored procedures and triggers in a relational database system; explaining the basic principles and common trade-offs in relational database query optimization; explaining the basic principles of database concurrency control and recovery, and implement them within a transaction program.

Characteristics and capabilities of database systems (DBS) / database management systems (DBMS). Transactional data processing. Transaction management system and data sharing and multiuser environment. Database security, safety and recovery. Data dictionary. Realization of database schema on a database server. Server programming techniques. Distributed databases. Database file organization. Query processing and query optimization. Database design methods.

Lectures; laboratory exercises; individual consultations; team work on the design of conceptual data base schema; individual work (assignments). Students are encouraged to communicate, to reason critically, to work independently and to contribute actively to teaching process.