Database Systems in Practes

Garant předmětu:

Lecturer:

Tutor:

Supervisor:

Department of Software Engineering

Synopsis:

This course is presented in Czech.

Requirements:

The lecture presupposes knowledge of conceptual and logical design of a database and SQL. The advantage is the knowledge of a specific data server and own experience with the development of data-oriented applications.

Syllabus of lectures:

Transactions and paralelism

SQL dialects

ORM

Optimization

Architecture of data servers

Design of data models

Physical DB design

Database design patterns

Business intelligence

Data management

Data quality and metadata

Syllabus of tutorials:

1. Data value - design of data-oriented system

2. Estimates of size and data requirements

3. Modeling; analysis of data models

4. SQL

5. Transactions and SQL

6. Administration in the corporate environment

Study Objective:

Study materials:

https://profinit.eu/univerzity/predmet/databazove-systemy-v-praxi/

Note:

Further information:

https://courses.fit.cvut.cz/NI-DSP/

No time-table has been prepared for this course

The course is a part of the following study plans:

• Bachelor program Informatics, unspecified branch, in Czech, 2015-2020 (elective course)
• Bachelor branch Security and Information Technology, in Czech, 2015-2020 (elective course)
• Bachelor branch Computer Science, in Czech, 2015-2020 (elective course)
• Bachelor branch Computer Engineering, in Czech, 2015-2020 (elective course)
• Bachelor branch Information Systems and Management, in Czech, 2015-2020 (elective course)
• Bachelor branch Web and Software Engineering, spec. Software Engineering, in Czech, 2015-2020 (elective course)
• Bachelor branch Web and Software Engineering, spec. Web Engineering, in Czech, 2015-2020 (elective course)
• Bachelor branch Web and Software Engineering, spec. Computer Graphics, in Czech, 2015-2020 (elective course)
• Bachelor branch Knowledge Engineering, in Czech, 2018-2020 (elective course)
• Bachelor specialization Information Security, in Czech, 2021 (elective course)
• Bachelor specialization Management Informatics, in Czech, 2021 (elective course)
• Bachelor specialization Computer Graphics, in Czech, 2021 (elective course)
• Bachelor specialization Computer Engineering, in Czech, 2021 (elective course)
• Bachelor program, unspecified specialization, in Czech, 2021 (elective course)
• Bachelor specialization Web Engineering, in Czech, 2021 (elective course)
• Bachelor specialization Artificial Intelligence, in Czech, 2021 (elective course)
• Bachelor specialization Computer Science, in Czech, 2021 (elective course)
• Bachelor specialization Software Engineering, in Czech, 2021 (elective course)
• Bachelor specialization Computer Systems and Virtualization, in Czech, 2021 (elective course)
• Bachelor specialization Computer Networks and Internet, in Czech, 2021 (elective course)
• Study plan for Ukrainian refugees (elective course)