Czech

Not applicable.

The course is designed as an introduction to database systems and their security. Knowledge acquired during secondary school studies, especially mathematics, and Java programming (course: BPC-PC2T) are required.

A maximum of 100 points can be obtained, of which 30 points for completing individual projects and 70 for the final written exam. The minimum requirements for particular parts is determined by the annually updated decree of the subject guarantor.
The conditions for the successful course completion are stated in the yearly updated supervisor’s notice.

The goal of the course is to introduce students to methods of designing database systems with respect to normal forms. In addition, the student will learn to implement the designed database schema, including data processing through a programming language. Finally, the student will learn to secure database systems including virtualization and data backup.
The student will acquire the necessary theoretical and practical skills in the design and implementation of database systems including their security. The student will learn basic principles of design and implementation of database systems, to implement this practically with regard to the security of such a system.

After course completion, the students will be able to:
- explain and practically implement the design of a database application,
- practically realize the implementation of a database system,
- process data in a database using a programming language,
- select the appropriate type of database for different types of applications,
- explain and practically implement transactional data processing,
- optimize database queries to reduce the load on database systems,
- configure the database with respect to its security,
- deploy a database in a virtualized environment,

Not applicable.

Not applicable.

GARCIA-MOLINA, Hector, Jeffrey D. ULLMAN a Jennifer WIDOM. Database system implementation. Upper Saddle River: Prentice Hall, 2000. xv, 653 s. ISBN 0-13-040264-8. (EN)
NATAN, Ben. Implementing Database Security and Auditing. Digital Press, 2005. xv, 432 s. ISBN 978-1555583347. (EN)
SILBERSCHATZ, Abraham, Henry F. KORTH a S. SUDARSHAN. Database system concepts. 7th ed. Boston: McGraw-Hill Education, 2019. xxvi, 1142. ISBN 1260084507. (EN)

Not applicable.