Home / MySQL DBA Training in Hyderabad

MySQL DBA Training in Hyderabad

 MySQL DBA training

Many Startup companies across the world hiring MySQL DBA’s.This is a open database with good features.DBA CENTRE will provide very good training on MySQL DBA.Students will get hands-on exposure to MySQL Installation, Configuration and Administration.
Best MySQLDBA Training in Hyderabad,we will provide training One to One (or) Per Batch only 5 Members.

1.Open Source Introduction

Overview of MySQL
History of MySQL
The Main Features of MySQL
Basics of Linux Commands

2.MySQL Installation

Ubuntu Operating System Installation
Installing MySQL from apt repository on Ubuntu
How to start, stop and restart the server
How to check the MySQL status and Configuration file
MySQL Architecture
INFORMATION_SCHEMA Tables
System Catalog Views
Tablespace Management
Red Hat Linux Operating System Installation
Installing MySQL from yum repository on Red Hat Linux Or Oracle Linux

3.MySQL user management.

How to maintain the user privileges using DDL & DCL Commands
How to maintain the user privileges using DML Commands
Installation on Windows on MySQL
Installation of Workbench (Community Edn)

4.Storage Engines with Simple Examples

Transaction and Non-transaction Engines
Setting the Storage Engine
Overview of MySQL Storage Engine Architecture
Pluggable Storage Engine Architecture
The MyISAM Storage Engine
The INNODB Storage Engine
The MEMORY Storage Engine
The CSV Storage Engine
The ARCHIVE Storage Engine
The BLACKHOLE Storage Engine
The MERGE Storage Engine
The FEDERATED Storage Engine

5.MySQL Server logs

Error Log
General Log
Slow Log
Binary Log
Relay Log

7.MySQL Administrative Programs

innochecksum — Offline InnoDB File Checksum Utility
myisam_ftdump — Display Full-Text Index information
myisamchk — MyISAM Table-Maintenance Utility
myisamlog — Display MyISAM Log File Contents
mysqldump — Generate Backups
mysqlbinlog — Utility for Processing Binary Log Files
mysqldumpslow — Summarize Slow Query Log Files
mysqladmin – administrative tasks

8.Configuring InnoDB

InnoDB Table and Index Structures.
Managing InnoDB Data and Redo Log Files.
InnoDB Startup Options.
Restrictions on InnoDB Tables
Memory allocation for Innodb
Turnoff Innodb

9.Database Backup Methods

Using mysqldump for Backups
Dumping Data in SQL Format.
Full Backup & Recovery
Percona XtraBackup Installation on MySQL Server

10.Percona Server

Percona Overview
Percona Server Installation
Percona XtraBackup Installation
Percona Features
Configuration of XtraBackup
Taking Full Backup
Taking Incremental Backups
Restoring Full Backups and Incremental
Partial Backups
Recovering data
Performance Tuning – Partitioning
Overview of Partitioning in MySQL
Partitioning Types
RANGE Partitioning
LIST Partitioning
HASH Partitioning
KEY Partitioning

11.Managing Multiple instances

Installing MySQL Server from Generic Binaries
Setting Up Multiple Data Directories
Running Multiple MySQL Instances on Linux
Managing Multiple MySQL Servers

12.Upgrading MySQL and Features

MySQL Server 5.7 to MySQL Server 8

13.Replication

Overview Replication
Master-Slave Configuration
Master-Master Configuration
GTID Replication Setup
Multi-Threaded Slave
Replication trouble shooting / errors

14.Uninstalling MySQL Server 5.7

15.Installing MySQL Server 8.0 on Ubuntu Operating System
New Features

16.Amazon Web Services for DBA’s

Introduction of Cloud Computing
What is IAAS, PAAS & SAAS
Introduction to AWS RDS
Basics of Amazon Aurora Database

17.Performance Tuning

The MyISAM Key Cache
The InnoDB Buffer Pool
Isolations Level
Optimization [ about Constraints ] Index Management
About Locking & Issues
Locking Methods
Table Locks
Deadlock
InnoDB PT Parameters

18.Job Support

 Details for MySQL Certification

 

GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe