460-2030/01 – Administration of Database System (SD)
| Gurantor department | Department of Computer Science | Credits | 4 |
| Subject guarantor | doc. Ing. Radim Bača, Ph.D. | Subject version guarantor | doc. Ing. Radim Bača, Ph.D. |
| Study level | undergraduate or graduate | Requirement | Optional |
| Year | 3 | Semester | summer |
| | Study language | Czech |
| Year of introduction | 2010/2011 | Year of cancellation | 2010/2011 |
| Intended for the faculties | FEI | Intended for study types | Bachelor |
Subject aims expressed by acquired skills and competences
The student who pass this course will be able to work with the three most widespread database systems (Oracle, MS SQL Server, MySQL) and efectively utilize their features. The database system start, configuration and common administration is explained and tried practicaly on an accessible hardware. Students will be able to tune the performance of databases running on a database system and detect possible problems.
- Oracle, MS SQL Server and MySQL intorduction.
- Database enviroment and hardware.
- Initialization and configuration of one instance of an database system.
- Parameters of the database.
- User acess rights and identity management.
- Database maintanance: back-up, recovery, index rebuild.
Teaching methods
Lectures
Tutorials
Summary
The main topic of this course is the administration of the most widespread database system (Oracle, MS SQL Server a MySQL). The course is focused on general aspects of these products and also on their specified features.
Compulsory literature:
DBMS documentation to Oracle, SQL Server and DB2.
Recommended literature:
Way of continuous check of knowledge in the course of semester
Students will have to solve problems during the exercises and show the understanding of the DBMS administration. The problems will usually have two tasks where one will be available before the exercise and the second not.
E-learning
Other requirements
Prerequisities
Co-requisities
Subject has no co-requisities.
Subject syllabus:
Syllabus of lectures.
1. SQL Server - databáze creation, filegroups, data files, parameters set-up, user creation, role assignment, user rights, back-up recovery.
2. SQL Server - services, resource governor, database audit, automatic database maintenace, logs, log shiping.
3. Oracle - tablespaces, data files, database restart, database parameters, memory set-up, recovery and back-up, users, rights and roles.
4. Oracle - services, alert log, trace logs, resource governor, database audit, automatic maintenance, table creation, treshold value set-up.
5. MySQL - data files, users and access rights, recovery and back-up, database parameters.
6. Summary and general talk abou DBA and different platforms (RAID, NUMA, Clusters).
7. SQL Server - physical database design (clustered, unclustered index, materialized views), physical database design.
8. Oracle - physical database design in Oracle.
9. Oracle - automatic physical database design, Database replay.
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction