MYSQL DBA Course Content
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
myisampack — Generate Compressed, Read-Only MyISAM Tables
mysql_config_editor — MySQL Configuration Utility
mysqlaccess — Client for Checking Access Privileges
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
Innodb startup options
8. Database Backup Methods
Using mysqldump for Backups
Dumping Data in SQL Format.
Backup Tools ( Percona XtraBackup )
9.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
Recovering data
11. Performance Tuning - Partitioning
Overview of Partitioning in MySQL
Partitioning Types
RANGE Partitioning
LIST Partitioning
HASH Partitioning
KEY Partitioning
12.Replication
Overview Replication
Master-Slave Configuration
Master-Master Configuration
Replication trouble shooting / errors
13.Performance Tuning
The MyISAM Key Cache
The InnoDB Buffer Pool
Isolations Level
Optimization ( about Constraints )
About Locking & Issues
o Locking Methods
o Table Locks
o Deadlock
InnoDB PT Parameters
14.How to reset / update the MySQL root/user password
15. Creating Events & Monitoring Events & Cron Jobs
15.Managing Multiple instances
Installing MySQL Server from Generic Binaries
Setting Up Multiple Data Directories
Running Multiple MySQL Instances on Linux
Managing Multiple MySQL Servers
16.Upgrading MySQL and Features
MySQL Server 5.5 to MySQL Server 5.7
17. Uninstalling MySQL Server 5.7
18. 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?
What is PAAS?
What is SAAS?
Introduction to AWS RDS
Deploy AWS RDS
AWS RDS Operational Commands
AWS RDS - Backup & Recovery
Basics of Amazon Aurora Database
-------------- For job Seekers
1, Real time Environment Discussion
2, Resume preparation
3, Real time Monitoring tools
4, Ticketing tools
4,ITIL Process ( Information Technology Infrastructure Library)
o HelpDesk Management
o Change Management
o Incident Management
o Problem Management
5.Mock Interview
6.Job Support
