MySQL DBA Course

This course is designed for MySQL Database Administrators who have a basic understanding of a MySQL database and SQL commands. The course provides practical experience in setting up and maintaining a MySQL server, including backing up, recovery, configurat

All Levels

Created by Ram Niwas Sangwan Last Updated 31/07/2022 12:43

₹39,900.00 ₹39,900.00 0.00% off

What's Included

  • 36 Lectures
  • 13 Assignments
  • Access on tablet and phone
  • Certificate of completion

Course Curriculum

Expand all Collapse all

36 Lectures

00:00

MySQL Security 1 Lectures

Description

MySQL DBA Online Training

The MySQL DBA Online Training course includes Installation to advanced performance tuning.  Most noteworthy, the course have been delivered by the Instruction for many corporate clients. Therefore, with our MySQL DBA Online Training you’ll learn concepts in detailed and with hands on examples.

About This course

MySQL DBA Online Training designed for freshers and experienced professionals. MySQL, an open-source relational database management system (RDBMS) is the most trusted. It is used by the Banking sectors, Health Insurance companies and several other companies including Facebook. Companies whose business is based on complex transactions, payroll processes opt for Mysql. And Mysql Enterprise Version comes with Oracle Support. In addition the MySQL DBA Online Training has evolved over the years.

Course Objectives

First of all, this course is designed to give administrators the knowledge and skills. The Skills needed to maintain successful and efficient day-to-day operations of MySQL databases and services.  Consequently, Administrators will gain practical experience in setting up, administering and troubleshooting MySQL databases.  They will have in depth knowledge on Replication, High availability features of MySQL and in depth knowledge Security.

Practical Includes:

  • MySQL Installation on CentOS 7 or RHEL 7
  • Starting, Stopping and Configuring MySQL
  • Security-Related Configuration
  • Database Creation
  • Using Client Programs for DBA Work
  • Setting up Character Set Support
  • Transactions and Locking
  • Using Storage Engines
  • Table Maintenance
  • Obtaining Data from the Information_Schema Database
  • Backup and Recovery
  • Using Stored Procedures for Database Administration Tasks
  • User Management
  • Securing the Server
  • Upgrade-Related Security Issues
  • Optimizing Queries
  • Optimizing Schemas
  • Optimizing the Server
  • The Event Scheduler
  • Partitioned Tables
  • Interpreting Error Messages
  • Optimizing the Environment
  • MySQL Replication
  • MySQL Cluster

Instructors

(0.00)

21 Courses

225 Students

2 Reviews