3 Pemimpin Dr, #06-04 (07), Singapore 576147
+65 8839 6772

MySQL DBA Certification Training

MySQL DBA Certification Training

Live Classes

Play Video

MySQL DBA Certification Training trains you on the core concepts & advanced tools and techniques to manage data and administer the MySQL Database. It includes hands-on learning on concepts like MySQL Workbench, MySQL Server, Data Modeling, MySQL Connector, Database Design, MySQL Command line, MySQL Functions etc. End of the training you will be able to create and administer your own MySQL Database and manage data.

Why should you take MySQL DBA?

MySQL is the world's most popular open source database

The average pay stands at $73,973 USD p.a - Indeed.com

Many of the world's largest and fastest-growing organizations including Facebook, Google, Adobe and Alcatel Lucent rely on MySQL

Course Description

MySQL is the most popular open source database. This training is your first step towards gaining a strong foundation and hands-on experience in using and administering this open source relational databases.


You will gain an understanding of the core concepts and advanced tools and techniques to manage data and administer the MySQL Database. Through this training you will gain the ability to create and administer your own MySQL Database and manage data. 

After completing this course, you should be able to:
• Identify features of MySQL database
• Understand benefits of an open source database
• Explain the basics of relational databases
• Create an effective MySQL database
• Create database objects using SQL
• Use MySQL command-line client to populate and manipulate data
• Access a database from MySQL client tools or applications
• Use SELECT statements to query data
• Use various data types based on requirement
• Use SQL to modify structure of your database
• Create indexes and keys
• Use Join operation to query data from multiple tables
• Explain database transactions
• Use built-in MySQL functions
• Export and import database data
• Configure MySQL server and client programs
• Configure simple and complex replication topologies
• Create and manage users
• Define and implement a backup strategy
• Perform physical and logical backups of your data
• Protect your data from common security risks
• Use server logs and other tools to monitor database activity

Edureka's MySQL Administration training is based on MySQL Database 5.6 version. This is your first step in getting to know this open source relational database with extensive hands on learning.


You will get a general understanding of relational databases and techniques to design an efficient database system. You will learn the powerful Structured Query Language (SQL) to build database and manipulate data. You will also learn the various administration skills required to manage the database.

This course can be beneficial for people having the below professional background:


• Database Developers 

• Application Developers

• Database Designers

• Database Administrators

  • Basic computing knowledge
  • Working knowledge of any command-line program
  • Basic understanding of relational database systems is an added advantage


Real-Life Case Studies

Live project based on any of the selected use cases, involving implementation of MySQL Database Administration.

24 x 7 Expert Support

We have 24x7 online support team available to help you with any technical queries you may have during the course.

Instructor-led Live Sessions

30 Hours of Online Live Instructor-led Classes. Weekend class: 10 sessions of 3 hours each.


Each class has practical assignments which shall be finished before the next class and helps you to apply the concepts taught.


Towards the end of the course, you will be working on a project. Edureka certifies you as an MySQL DBA Expert based on the project.

Lifetime Access

You will get lifetime access to LMS where presentations, quizzes, installation guides & class recordings are available.


We have a community forum for all our customers wherein you can enrich their learning through peer interaction and knowledge sharing.

Course Curriculum

Objectives: At the end of this module, you will be able to:

• Understand MySQL products, professional services and support for your operating system.

• Define a relational database management system (RDBMS) and describe its structure.

• Explain the use of SQL and MySQL with relational databases

• Define data definition language (DDL) and data manipulation language (DML)

• Understand MySQL client/server model and work with MySQL connectors.

• Install the MySQL server on Linux, start and stop MySQL server

• Interact with the server using the MySQL command-line client. 

• Log your MySQL command-line client session to a text file.

• Use MySQL Workbench to interact with the server.



• MySQL Overview

• Basics of Relational Databases

• Entities and Relationships

• SQL Language and MySQL

• SQL data definition language and data manipulation language

• MySQL Client/Server Model

• MySQL Connectors

• Installation of the MySQL server

• Starting and stopping MySQL server

• Using the MySQL client

• MySQL Workbench


Hands On

• Install and Configure MySQL Server, Client and MySQL workbench

• Using MySQL Workbench

• Creating the ‘world’ Database & Explore the Schema

Objectives: At the end of this module, you will be able to:

• Describe database modeling

• Use primary keys and foreign keys to achieve referential integrity

• Normalize your data model

• Design your new database

• Model a database using MySQL workbench and view the structure.

• Evaluate a database design

• Explain the use of different data types in database design

• Choose the correct data types while modeling data

• Describe the considerations for selecting data types



• Database Modeling

• Keys and Normalization

• Database Design

• Viewing and Evaluating a Database

• Data Types and Database Design

• Numeric, Temporal and String Data Types

• Character Set and Collation Support

• Data Type Considerations

• Meaning of NULL


Hands On:

• Explore an Existing Database

• Designing a New Database

• Selecting Data Types for your New Database

Objectives: At the end of this module, you will be able to:

• Create a database and add tables

• Use the SHOW CREATE TABLE statement

• Set column and table options

• Create indexes, keys, and constraints

• Delete a database.

• Create and delete a table.

• Add and remove table columns

• Modify table columns.



• Creating a Database

• Creating a Table

• Showing How a Table Was Created

• Table Options

• Column Options

• Indexes, Keys, and Constraints

• Deleting database and tables

• Creating New Table Using an Existing Table

• Creating a Temporary Table

• Copying an Existing Table Structure

• Adding, removing and modifying table columns and indexes


Hands On:

• Creating a Database

• Deleting a Database

• Creating and Deleting a Table

• Altering Table Columns

Objectives: At the end of this module, you will be able to:

• Retrieve database data using the SELECT statement from your database.

• Use the SELECT statement clauses: FROM, DISTINCT, WHERE, ORDER BY, and LIMIT

• Create views

• Query data from application code

• Export and import a delimited file



• The SELECT Statement

• Creating Views

• Querying Data from an Application

• Exporting and Importing a Delimited File

• Troubleshooting: Authorization Levels

• Manipulating Data and inserting records

• Replacing and updating existing records

• Deleting records

• Exporting and importing a script

• Multistatement Transactions

• Modifying Data from an Application


Hands On:

• Executing Basic Queries

• Importing a Delimited File

• Performing Basic Queries on Imported Data

• Performing Basic Queries from a PHP Application

• Exporting Table Data for MySQL Database

• Inserting, Modifying and Deleting Data

• Exporting a Script

Objectives: At the end of this module, you will be able to:

• Explain the concept of a join

• Use the JOIN keyword to query multiple tables

• Execute inner and outer joins

• Use the UNION keyword to combine multiple queries

• Use built-in functions in MySQL

• Describe and use: string functions, Date and time functions, Numeric functions.

• Use aggregate functions with the SELECT statement



• Querying Multiple Tables

• Joining Tables with SELECT

• Inner Joins

• Outer Joins

• Table Name Aliases

• Functions in MySQL Expressions

• Using Functions

• String Functions

• Date and time functions

• Numeric Functions

• Aggregate Functions

• Spaces in Function Names


Hands On:

• Using Joins in Queries

• Using Unions in Queries

• Using Built-In, String, and Date and Time Functions

• Using Numeric Functions

• Using Aggregate Functions

Objectives: At the end of this module, you will be able to:

• Explain how MySQL processes, stores, and transmits data

• Configure InnoDB tablespaces

• Explain how MySQL uses memory

• Configure the InnoDB buffer pool 

• List some of the available plug-ins



• Architectural Overview

• Understand how MySQL Transmits Data and Processes Requests

• Understand how MySQL Stores Data and Uses Memory

• Tablespaces, Redo and Undo Logs

• Plug-in Interface


Hands On:

• Configuring Tablespaces

• Configuring the Buffer Pool

Objectives: At the end of this module, you will be able to:

• Describe database modelling.

• Use primary and foreign keys to achieve referential integrity.

• Normalize your data model.

• Design your new database.

• Model a database using MySQL workbench and view the structure.

• Evaluate a database design.

• Explain the use of different data types in database design.

• Choose the correct data types while modelling data.



• Server Configuration Options

• Option Files and System Variables

• Launching Multiple Servers on the Same Host

• Monitoring Tools & Techniques

• MySQL Enterprise Audit

• MySQL Enterprise Monitor

• Monitoring User Activity


Hands On:

• Modifying the Configuration File 

• Changing Dynamic Settings

• Configuring the Slow Query Log

• Using Performance Schema

Objectives: At the end of this module, you will be able to:

• Create user accounts.

• Design a permission structure.

• Control user permissions

• Grant access to system operations

• Authenticate by using plug-ins

• Expire accounts manually and automatically.

• Reset a forgotten root password.



• Creating and Modifying User Accounts

• Configuring Passwords

• Authentication Plug-Ins

• Granting Permissions & Grant Tables


Hands On:

• Creating Users  

• Granting Permissions

MYSQL DBA Course Certification

Edureka’s MYSQL Administrator Certificate Holders work at 1000s of companies like

Course Projects

You should have a minimum of 4 GB RAM and processor i3 or above

We will help you to setup Virtual Machine in your System with local access. The detailed installation guides are provided in the LMS for setting up the environment. For any doubt, the 24*7 support team will promptly assist you.

In the project you will be creating a Database using MySQL on SALARY MANAGEMENT SYSTEM:-
•   Employee list to be maintained having id, name, designation, experience
•   Salary details having employee id, current salary
•   Salary in hand details having employee id, CTC salary, pf deduction or any other deduction and net salary to be given and also maintain details of total savings of employee
•   Salary increment to be given by next year if any depending upon constraints
•   Deduction in monthly salary if any depending upon any discrepancy in work and amount to be deducted.

Testimonial Reviews

Client Logo

Got really good support rom edureka! After i completing my course also they are very friendly in assisting my queries!!! Excellent!!!!

Client Logo
Rupali Sharma

I would definitely like to give more than 5 stars to Edureka, i have been associated with more than two years from now, and i have never had any issue or any complains. Support staff is excellent and very professional, the amount of time they spend with each customer is really appreciated.

Client Logo
Mohit Sharma

I have been subscribing to Edureka's courses for almost a year now, primarily related to Big Data and Data analytics. These courses have helped me to gain that competitive edge which is required at the job.

Client Logo
Vaibhav Nitturkar

Edureka is providing the best software training I have seen in my 10 years of IT career. I have been an Edureka student for over one year now. Having completed courses such as AWS Architect Certification Training, DevOps Certification Training and Hadoop Administration.

Client Logo
Janardhan Singamaneni

I took kafka and datascience classes with EDUREKA and its overall nice. After thorough scanning of available online courses, I decided to go with edureka and am quite satisfied with it. To start with the Sales and support team- they were fantastic- really fast and responsive.

Client Logo
Zakir Khan

The unique combination of Online Classes with 24*7 On-Demand Support and class recordings/ppt/docs etc in Learning Management System (LMS) on the site made me fall in love with edureka!

Training FAQs

You will never miss a lecture at edureka! You can choose either of the two options:
  • View the recorded session of the class available in your LMS.
  • You can attend the missed session, in any other live batch.

To help you in this endeavor, we have added a resume builder tool in your LMS. Now, you will be able to create a winning resume in just 3 easy steps. You will have unlimited access to use these templates across different roles and designations. All you need to do is, log in to your LMS and click on the "create your resume" option.

We have limited number of participants in a live session to maintain the Quality Standards. So, unfortunately participation in a live class without enrolment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in the class.

All the instructors at edureka are practitioners from the Industry with minimum 10-12 yrs of relevant IT experience. They are subject matter experts and are trained by edureka for providing an awesome learning experience to the participants.

Just give us a CALL at +65 8839 6772 OR email at sales@massivewisdomgroup.com

Related courses by other education partners

SQL Masterclass: SQL for Data Analytic

This SQL Masterclass: SQL for Data Analytic is intended for absolute beginners that concentrate on giving the appropriate knowledge of […]

Data Science: Data-Driven Decision Making

Data becomes valuable when it allows us to make a decision or take action in the real world. On this microcredential, you’ll work […]

The Complete Node.js Developer Course […]

You start a new course, and the instructor has you installing a bunch of libraries before you even know what Node is or how it works. You […]