Database Management and Access II

Catalog description

Students will explore the theory and application of advances database administration including database performance monitoring and tuning techniques. Standard topics in DBMS performance will be discussed including: physical and logical design issues, the hardware and software environment, SQL statement execution, indexes and front-end application issues. Techniques in performance monitoring and tuning will be investigated. In addition, advanced database backup and recovery, disaster recovery and other DBA topics will be explored.