MySQL for Database Administrators Ed 4 Training

Live Online & Classroom Enterprise Certification Training

Looking for a private batch ?

REQUEST A CALLBACK

Certified Trainer
Authorized Courseware
Completion Certificate from ATP

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is MySQL for Database Administrators Ed 4 Certification Training about?

The MySQL for Database Administrators course teaches DBAs and other database professionals how to maximize their organization's investment in MySQL and about the benefits of using the MySQL Cloud Service. Learn to configure the MySQL Server, set up replication and security, perform database backups, optimize query performance, and ensure high availability.

Through a variety of realistic, hands-on activities, expert MySQL instructors will teach you to install, configure, secure, and maintain your database server which you can deploy on-premise or as a MySQL Cloud Service instance.

What are the objectives of MySQL for Database Administrators Ed 4 Certification Training ?

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
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
Protect your data from common security risks
Identify and optimize poorly-performing queries
Troubleshoot server slowdowns and other common problems
Gain an understanding of MySQL Cloud

Who is MySQL for Database Administrators Ed 4 Certification Training for?

Database Administrators
Database Developers
Technical Consultant

What are the prerequisites for MySQL for Database Administrators Ed 4 Certification Training?

Suggested Prerequisite

Should be knowlegeable with MySQL data types and executing basic DDL and DML queries using SQL
Should be knowlegeable with relational database concepts and using the mysql command-line client
Should be knowlegeable with Joining tables

Required Prerequisite

MySQL Fundamentals Ed 1
MySQL for Developers

Available Training Modes

Live Online Training

40 Hours

Classroom Training

5 Days

Course Outline Expand All

Expand All

Introduction to MySQL

MySQL on the Web

The MySQL community

MySQL in the Cloud

MySQL overview

MySQL Enterprise Edition

Installing MySQL

Initial Configuration

Starting and Stopping MySQL

Upgrading MySQL

Installing MySQL

Installed Files and Directories

MySQL Architecture

Redo and Undo Logs

How MySQL Stores Data

Tablespaces

How MySQL Uses Memory

Architectural Overview

How MySQL Processes Requests

How MySQL Transmits Data

Plug-in Interface

Configuring MySQL

Launching Multiple Servers on the Same Host

Server Options, Variables, and the Command Line

System Variables

Option Files

Monitoring MySQL

Monitoring MySQL with Performance Schema

MySQL Enterprise Audit

Monitoring MySQL with Log Files

Monitoring User Activity

MySQL Enterprise Monitor

Monitoring MySQL with Status Variables

User Management

Configuring Passwords and Account Expiration

MySQL Privilege System

Resetting a Forgotten Root Password

Authentication Plug-Ins

Grant Tables

Creating and Modifying User Accounts

Granting Permissions

MySQL Security

Security Risks

Secure Connections

MySQL Enterprise Firewall

Network Security

Protecting Against SQL Injections

Operating System Security

Password Security

Maintaining a Stable System

Troubleshooting

Identifying the Causes of Server Slowdowns

Capacity Planning

Stability

InnoDB Recovery

Why Databases Fail

Optimizing Query Performance

Working with Indexes

The EXPLAIN statement

Identifying Slow Queries

Index Statistics

Backup Strategies

Understanding Backups

Creating a Backup Strategy

Backup Techniques

Performing Backups

MySQL Backup Tools

Raw Backup Methods

Techniques that Use the Binary Log

Configuring a Replication Topology

Configuring Replication

Replication Conflicts

Overview of Replication

When to Use Replication

Administering a Replication Topology

Monitoring Replication

Troubleshooting Replication

Replication Threads

Failover

MySQL Utilities

Group Replication

Monitoring Group Replication

Single-Primary and Multi-Primary Modes

Overview

Configuring Group Replication

Conclusion

Course Overview

Q&A Session

Course Evaluation

MySQL Curriculum

Thank You!

Who is the instructor for this training?

The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

MySQL for Database Administrators Ed 4 Certification Training - Certification & Exam

SpringPeople is the Authorized Training Partner of Oracle.
The training fees is exclusive of exam cost.
For any queries; feel free to reach us at oracle@springpeople.com

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree