Main page | Study Branches/Specializations | Groups of Courses | All Courses | Roles                Instructions

A course is the basic teaching unit, it's design as a medium for a student to acquire comprehensive knowledge and skills indispensable in the given field. A course guarantor is responsible for the factual content of the course.
For each course, there is a department responsible for the course organisation. A person responsible for timetabling for a given department sets a time schedule of teaching and for each class, s/he assigns an instructor and/or an examiner.
Expected time consumption of the course is expressed by a course attribute extent of teaching. For example, extent = 2 +2 indicates two teaching hours of lectures and two teaching hours of seminar (lab) per week.
At the end of each semester, the course instructor has to evaluate the extent to which a student has acquired the expected knowledge and skills. The type of this evaluation is indicated by the attribute completion. So, a course can be completed by just an assessment ('pouze zápočet'), by a graded assessment ('klasifikovaný zápočet'), or by just an examination ('pouze zkouška') or by an assessment and examination ('zápočet a zkouška') .
The difficulty of a given course is evaluated by the amount of ECTS credits.
The course is in session (cf. teaching is going on) during a semester. Each course is offered either in the winter ('zimní') or summer ('letní') semester of an academic year. Exceptionally, a course might be offered in both semesters.
The subject matter of a course is described in various texts.

NI-DSP Database Systems in Practes Extent of teaching: 2P+1C
Instructor: Vichta T. Completion: Z,ZK
Department: 18102 Credits: 4 Semester: L

Annotation:
This course is presented in Czech.

Lecture syllabus:
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

Seminar syllabus:
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

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

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.

Předmět je ekvivalentní s MI-DSP
Tento předmět obsahově navazuje na bakalářský předmět Databázové systémy.
https://courses.fit.cvut.cz/NI-DSP/

The course is also part of the following Study plans:
Study Plan Study Branch/Specialization Role Recommended semester
BI-SPOL.2015 Unspecified Branch/Specialisation of Study V Není
BI-WSI-PG.2015 Web and Software Engineering V Není
BI-WSI-WI.2015 Web and Software Engineering V Není
BI-WSI-SI.2015 Web and Software Engineering V Není
BI-ISM.2015 Information Systems and Management V Není
BI-ZI.2018 Knowledge Engineering V Není
BI-PI.2015 Computer engineering V Není
BI-TI.2015 Computer Science V Není
BI-BIT.2015 Computer Security and Information technology V Není
BI-SPOL.21 Unspecified Branch/Specialisation of Study V Není
BI-PI.21 Computer Engineering 2021 (in Czech) V Není
BI-PG.21 Computer Graphics 2021 (in Czech) V Není
BI-MI.21 Business Informatics 2021 (In Czech) V Není
BI-IB.21 Information Security 2021 (in Czech) V Není
BI-PS.21 Computer Networks and Internet 2021 (in Czech) V Není
BI-PV.21 Computer Systems and Virtualization 2021 (in Czech) V Není
BI-SI.21 Software Engineering 2021 (in Czech) V Není
BI-TI.21 Computer Science 2021 (in Czech) V Není
BI-UI.21 Artificial Intelligence 2021 (in Czech) V Není
BI-WI.21 Web Engineering 2021 (in Czech) V Není


Page updated 16. 4. 2024, semester: Z/2024-5, L/2021-2, Z,L/2022-3, Z/2019-20, L/2023-4, L/2019-20, L/2020-1, Z/2021-2, Z/2023-4, Z/2020-1, Send comments to the content presented here to Administrator of study plans Design and implementation: J. Novák, I. Halaška