Back to Courses

MySQL for Database Administrators Ed 5.1

ENDED

Online Training by DBQuest, Inc.

Inquire Now

Online / Training

Inquire for Price

Inquire Enroll Now

RESPONSE RATE

Details
Outline
About the Provider

Enroll Now

Inquire

Details

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

Prerequisites

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

Audience

Cloud Administrators
Database Administrators
Database Designers
Web Administrators

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

Outline

Topics

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

Reviews

Be the first to write a review about this course.

Write a Review

DBQuest, Inc. is an Oracle Training Provider and an Approved Training Partner of Lithan. We are one of the Authorized Training Center of Oracle University here in the Philippines with over 10 years of delivering high quality Education. Recently, we partners with Lithan, an eduCLaaS Digital Skills Accelator in Singapore to deliver International Degree Programs and Certification Skills Programs.

AWARDS AND RECOGNITIONS