Administration Database System in Use

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.