SubjectsSubjects(version: 850)
Course, academic year 2019/2020
   Login via CAS
A Practical Approach to Database Systems - NDBI036
Title in English: Databázové systémy pro praxi
Guaranteed by: Department of Software Engineering (32-KSI)
Faculty: Faculty of Mathematics and Physics
Actual: from 2019
Semester: winter
E-Credits: 4
Hours per week, examination: winter s.:2/1 C+Ex [hours/week]
Capacity: unlimited
Min. number of students: unlimited
State of the course: cancelled
Language: Czech
Teaching methods: full-time
Additional information:
Note: enabled for web enrollment
Guarantor: RNDr. Ondřej Zýka
Class: Informatika Mgr. - Softwarové systémy
Classification: Informatics > Database Systems
Annotation -
Last update: RNDr. Ondřej Zýka (04.09.2013)
The course focuses on data management in the organization and the important aspects of database design in terms of performance and operation of database systems. It shows the impact of practical implementation of theoretical principles of DBMS (especially Oracle, MS SQL, Sybase, and Teradata) on application design, administration, management and operation. The course assumes knowledge of the conceptual and logical database design, relational calculus and SQL. The advantage is knowledge of a particular data server and own experience with the development of data-oriented applications.
Syllabus -
Last update: RNDr. Ondřej Zýka (04.09.2013)

1. Enterprise data management - data as the property of the organization, the structure of data in the organization, Data Management, Data Governance.

2. Data Quality and Metadata - basic competencies necessary to meet user requirements.

3. Data integration and data flows - integration patterns and Master Data Management.

4. Database server architecture - data sources and how to use them.

5. Database system design - based on what is the quality of the data model

6. Physical database design - a critical part of the application design in terms of its performance.

7. Database patterns - proven techniques for standard situations.

8. Dimensional modeling and Teradata.

9. Programming of database applications - SQL dialects.

10.Transactions and parallelism in the database systems.

11. Performance optimization.

12. Administration and Enterprise DBMS features - the basis for the successful operation of the database system.

Charles University | Information system of Charles University |