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, configuration and optimization.
For any Clarification Call at 09312406920

232 STUDENTS ENROLLED

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

Course Curriculum

Introduction
DBA A. Introduction to DBMS and RDBMS 02:00:00
In this Unit you will know about the basics of DBMS and RDBMS.
DBA B. Schema Normalization 02:00:00
Schema Normalization-The session is a walk through for the normalization of a sample database. You will learn how to apply 1NF, 2NF and 3NF to your own database.
Getting Started with MySQL
MySQL DBA 3. MySQL Architecture 24 hours
MySQL DBA 4. Installing, Configuring, Stopping and Starting 24 hours
This unit will make you familiar about OS Setting and Installation.
MySQL Lab 1 – Installing MySQL on CentOS/RHEL 710, 00:00
MySQL Lab 2. Creating Multiple Instances of MySQL on CentOS 710, 00:00
MySQL Lab 3. Getting Started with MySQL 8.010, 00:00
MySQL DBA 5. Interpreting Error and Diagnostic Information 24 hours
MySQL DBA 6. Storage Engines 24 hours
MySQL DBA 7. The Innodb Engine 24 hours
MySQL Lab 4. Innodb Table Space Management10, 00:00
Data Management in MySQL
MySQL DBA 8. Obtaining Metadata 24 hours
MySQL DBA 9. Locking and Transactions in MySQL 24 hours
MySQL Lab 5. Transactions, Savepoints and Isolation Levels10, 00:00
MySQL DBA 10. MySQL Table Maintenance 24 hours
MySQL Lab 6 Performing Table Maintenance Operations10, 00:00
MySQL DBA 11 Working with Numeric and Temporal Data 00:45:00
Apply numeric and temporal values in expressions, Perform date and time arithmetic Use a range of numeric functions, Use a range of temporal functions, Employ numeric and temporal functions in expressions and Use control flow functions
MySQL DBA 12 Database Driven Web Applications 00:35:00
Using MySQL for Database Driven Applications. Examples used in the sessions are based on PHP and Python.
MySQL DBA 13. Backup and Recovery in MySQL 24 hours
MySQL Lab 7 Performing Backup and Restore10, 00:00
MySQL DBA 14. User Management in MySQL 24 hours
MySQL Lab 8 User Management10, 00:00
MySQL DBA 15. Privileges in MySQL 24 hours
Variables and Stored Routines
MySQL DBA 16. User Variables and Prepared Statements 24 hours
MySQL DBA 17. Stored Procedures and Functions in MySQL 24 hours
MySQL Lab 9 Stored Routines10, 00:00
MySQL DBA 18. Triggers in MySQL 24 hours
MySQL DBA 19. Partitioned Tables in MySQL 24 hours
MySQL Lab 10 Partitioning in MySQL10, 00:00
MySQL Security
MySQL DBA 20. Securing MySQL Server 24 hours
Optimization and Performance Tuning
MySQL DBA 21. Optimizing MySQL Queries 24 hours
MySQL DBA 22. Query Execution Plan and Optimization 24 hours
MySQL DBA 23. Optimizing MySQL Schemas 24 hours
MySQL DBA 24. Optimizing MySQL Server 24 hours
MySQL Lab 11 Benchmarking your MySQL servers10, 00:00
MySQL DBA 25. Optimizing MySQL Environment 24 hours
Scaling and High Availability
MySQL DBA 26. Understanding Replication Concepts 24 hours
MysQL DBA 27. GTID Based Replication in MySQL 24 hours
MySQL Lab 12 Replication in MySQL10, 00:00
MySQL DBA 28. MySQL Clusters Introduction 24 hours
MySQL DBA 28. Cluster Part 1 00:30:00
MySQL DBA 29. Cluster Part 2 00:20:00
MySQL Lab 14 MySQL Cluster Setup on CentOS10, 00:00

Course Reviews

4.8

4.8
24 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

Recent Posts

About The SkillPedia

The Skill Pedia is a platform for online training. It offers great learning experience for learners by offering features such as Interactive Videos, Interaction with Trainer, Assignments, Rich Audio Visuals and Handouts.

The Course Completion Certificate generated automatically based on your performance after the course is complete is an edge.

For Trainers, it is a platform for sharing your Skills which may be in the form of videos, slides, handouts, e-books or even consulting and get up to 85% of the fee you decide for the course.

The Skill Pedia - Learn or Teach a Skill

Designed by  © Alliance Softech Pvt Ltd. All rights reserved.
WhatsApp chat
X