About This Course
This course provides insight into concepts and techniques for installing and managing highly scalable relational databases: storage, protection, structure, tuning, and access. Students will learn how to integrate business requirements into specific database policies and procedures.
Topics include selection of hardware and software components, backup and disaster recovery, performance metrics, high availability, and monitoring techniques. Hands-on lab exercises will use core concepts covered in lecture: installation of MySQL, backup and recovery, import and export, security, transaction management, data partitioning, and database replication.