MySQL is one of the prevalent Database management systems.

Nowadays, many application/software using MySQL for their primary data storage.

The MySQL database owned by Oracle Corporation and Oracle provides two types of certification for MySQL professionals.
1. MySQL Database Administration
2. MySQL Database Developer

MySQL Database Administration designed for the person who wants to prove their skills for administrating MySQL database management system.

This Certification shows candidates having strong knowledge of MySQL installation, configuration, administrating, troubleshooting, security, and monitoring a running system.

Certification Details:

Certification Name: MySQL 5.7 Database Administrator
Exam Number: 1Z0-888
Target Audience: MySQL DBAs and architects and those who are currently working on production Databases
Platform: Delivered via Pearson VUE
Exam Duration: 120 minutes
Number of Questions: 75
Passing Score: 58%

Certification Benefits:

After passing the MySQL Database Administration exam, you will become a Certified MySQL Database Administrator Professional and ready to exploit more advanced features of MySQL RDBMS.

You will get a digital badge, which can use to share your expertise on all social media, resume, and skill showcase documents.

Oracle Certification Signifies a Candidates Readiness to Perform:
* Industry Recognized
* Credible
* Role Based
* Product Focused Across Database, Applications, Cloud, Systems, Middleware and Java
* Globally one of the top 10 certification programs available

MySQL Database Administration Exam Objective

Session 01: Installing MySQL

Session 02: MySQL Architecture

Session 03: Configuring MySQL

Session 04: Monitoring MySQL

Session 05: User Management

Session 06: MySQL Security

Session 07: Maintaining a Stable System

Session 08: Optimizing Query Performance

Session 09: Backup Strategies

Session 10: Configuring a Replication Topology

Detailed Syllabus:

Session 01: Installing MySQL

Installing MySQL
Installed Files and Directories
Initial Configuration
Starting and Stopping MySQL

Session 02: MySQL Architecture

How MySQL Processes Requests
How MySQL Stores Data
Tablespaces
Redo and Undo Logs
How MySQL Uses Memory

Session 03: Configuring MySQL

Server Options, Variables, and the Command Line
Option Files
System Variables

Session 04: Monitoring MySQL

Monitoring MySQL with Log Files
Monitoring MySQL with Status Variables
Monitoring MySQL with Performance Schema

Session 05: User Management

MySQL Privilege System
Creating and Modifying User Accounts
Configuring Passwords and Account Expiration
Authentication Plug-Ins
Granting Permissions
Resetting a Forgotten Root Password

Session 06: MySQL Security

Security Risks
Network security
Password Security
Operating System Security
Protecting Against SQL Injections

Session 07: Maintaining a Stable System

Stability
Capacity Planning
Troubleshooting
Identifying the Causes of Server Slowdowns
InnoDB Recovery

Session 08: Optimizing Query Performance

Identifying Slow Queries
The EXPLAIN statement
Working with Indexes
Index Statistics

Session 09: Backup Strategies

Understanding Backups
Creating a Backup Strategy
MySQL Backup Tools
Raw Backup Methods
Techniques that Use the Binary Log

Session 10: Configuring a Replication Topology

Replication Conflicts
When to Use Replication
Configuring Replication
MySQL Utilities
Replication Threads

If You Like What We Do Here On DatabaseConcept, You Should Consider:

Stay Connected to: Twitter | Facebook

Subscribe to our email updates: Sign Up Now

 

We are thankful for your support.