MySQL DBA Certification Training

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 this course ?

  • 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
  • 98 + satisfied learners. Reviews

Instructor-led live online classes

20

Oct
Fri - Sat ( 5 Weeks )
09:30 PM - 12:30 AM ( EDT )
10% Off
19995
17995

18

Nov
Sat - Sun ( 5 Weeks )
11:00 AM - 02:00 PM ( EDT )
10% Off
19995
17995

Edureka For Business

Train your employees with exclusive batches and offers and track your employee's progress with our weekly progress report.

Instructor-led Sessions

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

Real-life Case Studies

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

Assignments

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

Lifetime Access

You get lifetime access to the Learning Management System (LMS). Class recordings and presentations can be viewed online from the LMS.

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.

Certification

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.

Forum

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

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

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.

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.

Topics:

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

Topics:

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.

Topics:

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

Topics:

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

Topics:

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

Topics:

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.

Topics:

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.

Topics:

Creating and Modifying User Accounts

Configuring Passwords

Authentication Plug-Ins

Granting Permissions & Grant Tables

Hands On:

Creating Users  

Granting Permissions

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

Create user accounts

Recognize common security risks 

List security problems and counter-measures for networks, passwords, operating systems, file systems and applications.

Protect your data from interception and access.

Use SSL for secure MySQL server connections. 

Use SSH to create a secure remote connection to MySQL.

Topics:

Understanding Security Risks

Network Security & Secure Connections

Password & Operating System Security

Hands On:

Enable SSL Connections on the MySQL Server

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

Distinguish between the different types of backup

State advantages and disadvantages of the various backup techniques

Implement a backup strategy

Use MySQL Enterprise Backup to perform consistent backups. 

Use the mysqldump and mysqlpump utilities to perform logical backups

Understand when and how to use raw file backups

Back up the binary log

Topics:

Understanding Backups & Backup Techniques

Creating a Backup Strategy

MySQL Backup Tools

Raw Backup Methods

Hands On:

Backing up using mysqldump and mysqlpump

"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."

edureka is committed to provide you an awesome learning experience through world-class content and best-in-class instructors. We will create an ecosystem through this training, that will enable you to convert opportunities into job offers by presenting your skills at the time of an interview. We can assist you in resume building and also share important interview questions once you are done with the training. However, please understand that we are not into job placements.

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.

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.

You can Call us at +91 90660 20867 /1844 230 6362 ( US Tollfree ) OR Email us at sales@edureka.co . We shall be glad to assist you. 

  • Once you are successfully through the project (Reviewed by a edureka expert), you will be awarded with edureka’s MySQL DBA Expert Certificate.
  • edureka certification has industry recognition and we are the preferred training partner for many MNCs e.g.Cisco, Ford, Mphasis, Nokia, Wipro, Accenture, IBM, Philips, Citi, Ford, Mindtree, BNYMellon etc. Please be assured.

MySQL DBA Certification Training