Friday , December 15 2017
Home / Online MySQL DBA Training

Online MySQL DBA Training

MYSQL DBA Course Content

 1.Open Source Introduction

  • Overview of MySQL
  • History of MySQL
  • The Main Features of MySQL

2.MySQL Installation

  • Installing MySQL from RPM Packages on Red Hat Linux Or Oracle Linux
  • Installing MySQL on Windows
  • Installing MySQL from Generic Binaries
  • Explaining Environment Variables
  • Architecture
  • How to start, stop and restart the server
  • How to check the MySQL status

3.How to set /update the MySQL root/user password

  • Mysql_install_db
  • Mysql_secure_installation
  • Mysql_tzinfo_to_sql

4.MySQL user management.

  • How to maintain the user privileges using DDL & DCL Commands
  • How to maintain the user privileges using DML Commands

 5.MySQL Programs.

  • MySQL Client Programs.
    • Mysql — the MySQL Command-Line Tool.
    • Mysqladmin — Client for Administering MySQL Server
    • Mysqlcheck — A Table Maintenance Program.
    • Mysqldump — A Database Backup Program.
    • Mysqlimport — A Data Import Program.
    • Mysqlshow — Display Database, Table and Column Information
    • Mysqlslap — Load Emulation Client
  • MySQL Administrative and Utility Programs
    • Myisamchk — MyISAM Table-Maintenance Utility
    • Myisampack — Compress MyISAM Tables.
  • MySQL Server Administration.
    • Server System Variables
    • Server Status Variables
    • Server SQL Modes

6.Storage Engines with Simple Examples

  • MYISAM
  • INNODB
  • MEMORY
  • CSV
  • ARCHIVE
  • MERGE
  • FEDERATED
  • BLACKHOLE

7.Configuring InnoDB

  • InnoDB Table and Index Structures.
  • Managing InnoDB Data and Log Files.
  • Memory allocation for Innodb
  • Turnoff Innodb
  • Using Per-Table Tablespaces
  • Innodb startup options & System Variables
  • Converting Tables from Other Storage Engines to InnoDB
  • Restrictions on InnoDB
  • InnoDB Multi-Versioning.

8.MySQL server logs

  • Error Log
  • General
  • Slow Log
  • Binary Log

9. Database Backup Methods

  • Using mysqldump for Backups
  • Dumping Data in SQL Format.
  • Backup Tools ( Percona XtraBackup )
  • Restore & Recovery.

10.Replication

  • Overview Replication
  • Master-Slave Configuration
  • Master-Master Configuration
  • Replication trouble shooting / errors

11.Managing Multiple instances

  • Setting Up Multiple Data Directories
  • Running Multiple MySQL Instances on UNIX
  • Running Multiple MySQL Instances on Windows
  • Using mysqld_multi for Managing Multiple MySQL Servers

12.Performance Tuning

  • InnoDB
  • Isolation Levels
  • Error Handling

13.Optimization

  • Optimization Overview
  • Obtaining Query Execution Plan Information
  • Optimizing SELECT Statements
  • Tuning Server Parameter

14.Partitioning

  • Overview of Partitioning in MySQL
  • Partitioning Types

15.INFORMATION_SCHEMA Tables

  • Buffering and Caching
  • The MyISAM Key Cache
  • The InnoDB Buffer Pool

16.Locking Issues

  • Internal Locking Methods
  • Table Locking Issues
  • Concurrent Inserts
  • External Locking
  • Deadlock

17.Upgrading MySQL and Features

18.Percona

  • About Percona
  • Percona Server Installation
  • Percona XtraBackup
  • Percona Features
GET OUR LATEST CONTENT IN YOUR INBOX

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