0
SUBTOTAL :
empty cartcheckout
MySQL Database Administration Training and Certification

MySQL Database Administration Training and Certification

Size
Price:
Add to CartProduct Added View Cart Checkout
Product Tags:

Read more

 2Month/20 Hours                                                  Price:35,000

                                                                                     30,000

MySQL Database Administration Training and Certification


MySQL Database Administrator

MySQL Administration training course is for anyone who wants to administrate the MySQL database server. It is a comprehensive course covering all administrator duties required to perform MySQL database administration day-t0-day tasks. Step-by-step learning from basic to advanced level course.

The course explains how MySQL Database works, what tools are available, how we can use them, how we can secure the MySQL Database Server and configure it. During the training course you will learn how to manage user accounts and how the MySQL Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.

Key Learnings

MySQL Architecture

  • Use MySQL client programs to interface with the MySQL Server interactively and in batch
  • Describe how MySQL uses disk and memory resources
  • List and describe key characteristics of standard MySQL storage engines including InnoDB, NDB, MyISAM, MEMORY, FEDERATED

MySQL Server Installation, Configuration and Maintenance

  • Select, deploy, start and stop MySQL using appropriate binary packages for Windows and Linux platforms
  • Configure MySQL Server deployments using options files, command-line options and server variables.
  • Identify, configure, locate and describe appropriate use cases for MySQL the error, binary, general query and slow query log.

MySQL Security

  • Describe appropriate steps to secure a MySQL deployment at the operating system, filesystem and network levels.
  • Create and maintain user accounts with appropriate privileges and configuration.
  • Deploy and configure MySQL Enterprise Audit

Diagnostic Data and Metadata Sources in MySQL

  • Configure and leverage PERFORMANCE_SCHEMA tables to identify and diagnose performance problems.
  • Obtain MySQL metadata from INFORMATION_SCHEMA tables

Optimizing MySQL Performance

  • Demonstrate the ability to diagnose and optimize poorly-performing queries.
  • Tune MySQL Server configuration for best performance.
  • Apply best practices in optimizing schema objects
  • Demonstrate an understanding of locking concepts as applied to MySQL Server and storage engines.
  • Create and utilize table PARTITIONING

Backups and Recovery in MySQL

  • Create and restore logical backups using mysqldump
  • Create and restore binary backups
  • Use backups for data recovery

High Availability Techniques for MySQL

  • Describe, configure, deploy and troubleshoot MySQL replication
  • Describe and contrast characteristics of common MySQL high availability solutions (MySQL Cluster, DRBD, Windows Failover Clustering, Solaris Cluster, OVM Template for MySQL Enterprise)
  • Final Project


Online Class for International Students 




0 Reviews

Contact form

Name

Email *

Message *