MySQL DBA

DASVM brings you comprehensive MySQL DBA training, designed to give you basic knowledge and skills to become a successful MariaDB Administrator.

In this course, you will get a walk-through on how the Database works, the availability of tools, how to use these tools, how to configure MySQL Database server and configuration.

The course also covers database maintenance, backup and recovery. MySQL Server is one of the most popular database servers and it has been developed by the original developers of MySQL. MySQL is open source and as a relational database it provides SQL interface for data access.

Course Content:

• Open Source Introduction
• Overview of MySQL
• History of MySQL
• The Main Features of MySQL
• MySQL Installation
• Linux Operating System Installation
• Linux Commands
• Installing MySQL on Linux
• How to start, stop and restart the server
• How to check the MySQL status and Configuration file
• INFORMATION_SCHEMA Tables
• System Catalog Views
• Storage Engines with Simple Examples
• Setting the Storage Engine
• 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
• Tablespace Management
• Storage Architecture
• Create Tablespace
• Alter Tablespace
• Drop Tablespace
• MySQL User management.
• Creating Users
• Renaming Users
• Changing Passwords
• Dropping Users
• Granting Privileges
• The User Table
• Create SSL Users
• Installation on Windows on MySQL
• Installation of Workbench
• Installation of HeidiSQL
• MySQL Architecture
• MySQL Server logs
• Error Log
• General Log
• Slow Log
• Binary Log
• Relay Log
• Configuring InnoDB
• InnoDB Table and Index
• Managing InnoDB Data and Redo Log
• Change the location of the ibdata file
• Adding 2 ibdata files
• Change the position of log files
• increase the redo log files with 4 or 6
• Memory allocation for Innodb
• Turnoff Innodb
• Database Backup Methods
• Using mysqldump for Backups
• Dumping Data in SQL Format.
• Backups
• Restore
• Point in Time Recovery (Binlog)
• Percona XtraBackup Installation on MySQL Server
• Percona Server
• Percona Overview
• Percona Server Installation
• Percona XtraBackup Installation
• Percona Features
• Configuration of XtraBackup
• Taking Full Backup
• Taking Incremental Backups
• Restoring / Recovering Full Backups and Incremental
• Partial Backups
• XtraBackup Installation on MySQL Server
• Performance Tuning – Partitioning
• Overview of Partitioning in MySQL
• Partitioning Types
• RANGE Partitioning
• LIST Partitioning
• HASH Partitioning
• KEY Partitioning
• Obtaining partitioned information
• Modifying and removing partitions
• Partition pruning
• Managing Multiple instances
• Installing MySQL Server from Generic Binaries
• Setting Up Multiple Data Directories
• Running Multiple MySQL Instances on Linux
• Managing Multiple MySQL Servers
• Upgrading MySQL
• MySQL Server 5.7 to MySQL Server 8
•  Uninstalling MySQL Server 5.7
•  Installing MySQL Server 8.0 on Linux
• New Features