Course detail

Security of Database Systems

FEKT-CZV-BDSAcad. year: 2025/2026

The student will acquire the necessary theoretical and practical skills in designing and implementing database systems, including their security. They will understand the fundamental principles of designing and implementing database systems and be able to practically apply them with a focus on the system's security.

Upon completing the course, the student will be able to:

  • Explain and practically design a database application,
  • Practically implement a database system,
  • Process data in a database using a programming language,
  • Choose an 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 a database with a focus on its security,
  • Deploy a database in a virtualized environment.
 

Language of instruction

Czech

Number of ECTS credits

5

Mode of study

Not applicable.

Guarantor

RNDr. Ing. Pavel Šeda, Ph.D.

Department

Department of Telecommunications (UTKO)

Entry knowledge

The course is designed as an introduction to database systems and their security. Knowledge acquired during high school studies is required, particularly in mathematics and basic programming. 

Rules for evaluation and completion of the course

The conditions for successfully completing the course are determined by the annually updated regulations of the course guarantor. 

Aims

The aim of the course is to familiarize students with methods for designing database systems with a focus on normal forms. Furthermore, students will learn to implement the designed database schema, including data processing through a programming language. Last but not least, students will learn to secure database systems, including virtualization and data backup. 

Study aids

Study materials are available in the course's e-learning platform. 

Prerequisites and corequisites

Not applicable.

Basic literature

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.
NATAN, Ben. Implementing Database Security and Auditing. Digital Press, 2005. xv, 432 s. ISBN 978-1555583347.
SILBERSCHATZ, Abraham, Henry F. KORTH a S. SUDARSHAN. Database system concepts. 7th ed. Boston: McGraw-Hill Education, 2019. xxvi, 1142. ISBN 1260084507.

Recommended reading

Not applicable.

Classification of course in study plans

  • Programme CZV3-Cyber Lifelong learning - long-term course 1 year of study, summer semester, compulsory

Type of course unit

 

Lecture

20 hod., optionally

Teacher / Lecturer

RNDr. Ing. Pavel Šeda, Ph.D.

Syllabus

 

Laboratory exercise

10 hod., compulsory

Teacher / Lecturer

RNDr. Ing. Pavel Šeda, Ph.D.