trainocate-oracle-training-b
Home > Vendors > Oracle > D73628

D73628 - MySQL for Database Administrators Ed 5

Overview

Duration: 5 days
The MySQL for Database Administrators enables DBAs and other database professionals to maximize their organization's investment in MySQL. Learn to configure the MySQL Server, set up replication and security, perform database backups and recoveries, optimize query performance, and configure for high availability.
 Install and configure MySQL Server and client programs
 Recognize the key components of the MySQL architecture
 Manage user accounts and secure your server
 Troubleshoot server slowdowns and other issues
 Backup and recover MySQL database
 Configure and administer a variety of replication topologies

Objectives

 Install the MySQL server and client programs
 Upgrade MySQL on a running server
 Describe MySQL architecture
 Explain how MySQL processes, stores, and transmits data
 Configure MySQL server and client programs
 Use server logs and other tools to monitor database activity
 Create and manage users and roles
 Protect your data from common security risks
 Troubleshoot server slowdowns and other common problems
 Identify and optimize poorly performing queries
 Define and implement a backup strategy
 Perform physical and logical backups of your data
 Describe MySQL replication and its role in high availability and scalability
 Configure simple and complex replication topologies
 Administer a replication topology
 Configure and administer InnoDB Cluster

Audience

 Cloud Administrators
 Database Administrators
 Database Designers
 Web Administrators

Content

 Introduction to MySQL
 Installing and Upgrading MySQL
 Understanding MySQL Architecture
 Configuring MySQL
 Monitoring MySQL
 Managing MySQL Users
 Securing MySQL
 Maintaining a Stable System
 Optimizing Query Performance
 Choosing a Backup Strategy
 Performing Backups
 Configuring a Replication Topology
 Administering a Replication Topology
 Achieving High Availability with MySQL InnoDB Cluster
 Conclusion

Prerequisites

Experience with relational database concepts; knowledge of basic SQL statements; understand how to execute Linux/Unix commands


Certification

This course is not associated with any Certification.

Schedule

Show Schedule for: