MYSDBA: MySQL Database Administration
Short Description
Full Description
This MySQL Database Administration course is designed for MySQL Database Administrators who have a basic understanding of a MySQL database and a good working knowledge of SQL commands.
The course provides an understanding of MySQL Architecture and practical experience in setting up,configuring and maintaining a MySQL server,and backing up and recovering data. This MySQL Database Administration course also covers MySQL replication and its role in high availability and scalability.
-
Module 01: The server, clients and tools
-
Module 02: MySQL Workbench
-
Module 03: Obtaining MetaData
-
Module 04: Configure the Server
-
Module 05: SQL Modes, Log files and Binary Logging
-
Module 06: MySQL Architecture
-
Module 07: The Innodb Storage Engine
-
Module 08: Other Storage Engines
-
Module 09: Table Maintenance
-
Module 10: Backup and Recovery
-
Module 11: User Management
-
Module 12: Privileges
-
Module 13: Transactions and Locking
-
Module 14: Tuning and Tables
-
Module 15: Tuning the Server
-
Module 16: The Event Scheduler
-
Module 17: MySQL Server Installation and Upgrade
-
Module 18: Overview of High Availability
-
Module 19: Configure Master Slave Replication
-
Module 20: Administer a Replication Topology
