Online MySQL for Database Administrators training course of Oracle University is designed for DBAs and other database professionals.

Candidates Learn to:

Describe the MySQL Architecture.

Install and upgrade MySQL.

Configure MySQL server options at runtime.

Evaluate data types and character sets for
performance issues.

Understand the use of the InnoDB storage engine with MySQL.

Perform backup and restore operations.

Course objectives:

Describe the MySQL Architecture

Install and Upgrade MySQL

Use the INFORMATION_SCHEMA database to access metadata

Perform the MySQL start and shutdown operations

Configure MySQL server options at runtime

Use available tools including MySQL Workbench

Evaluate data types and character sets for performance issues

Understand data locking in MySQL

Understand the use of the InnoDB storage engine with MySQL

Maintain integrity of a MySQL installation

Use triggers for administration tasks

Use Enterprise Audit and Pluggable Authentication
Configure advanced replication topologies for high availability

Describe introductory performance tuning techniques
Perform backup and restore operations

Automate administrative tasks with scheduled events

Contact detail :
Oracle University
Local: 1800 103 4775
Intl: +91 80 67863102