MySQL for Database Administrators Ed 5.1 by DBQuest, Inc. - SpeedyCourse Philippines
We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

MySQL for Database Administrators Ed 5.1

Inquire Now
Online / Training

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

Schedules

Mar 22, 2021 - Mar 26, 2021
Weekdays 09:00 AM — 05:00 PM
No. of Days: 5
Total Hours: 40
Reviews
Be the first to write a review about this course.
Write a Review
DBQuest, Inc. is an Oracle University Reseller and an Oracle Approved Education Center (OAEC). We are one of the Authorized Training Center of Oracle University here in the Philippines with over 10 years of  delivering high quality Education. 

AWARDS AND RECOGNITIONS
  • Top Oracle Approved Education Center (OAEC) for FY 2017
  • Top Oracle University Reseller for FY 2017
  • Top Oracle Approved Education Center (OAEC) FY 2016
  • Top University Reseller for FY 2015
DBQuest, Inc.
Unit 2606 Antel Global Corp. Center, #3 Dona Julia Vargas Ave., Ortigas Center, Pasig City, Philippines, Metro Manila, Philippines 1605
+632 8667 3802 loc 103
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.