Bespoke MySQL for Database Administrators Certificate for Akansha Sharma
DAY 1
=====
MySQL Server Installation
MySQL Distributions
Installing on Linux and UNIX
Starting and Stopping on UNIX/Linux
Status Files
Upgrading the Server
Time Zone Tables
Clients & Tools
Introduction
MySQL
MySQL Server and Server-Startup Programs
Understanding mysqld/mysqld_safe/mysql.server/mysqld_multi
MySQL Admin
MySQL Client Programs
Obtaining Metadata
What is Metadata?
The mysqlshow Client Program
The SHOW and DESCRIBE Commands
The Information_Schema
Show Command and Information_Schema Differences
Configuring the Server
MySQL Server Options and Variables
MySQL Status Variables
Configuring MySQL Enterprise Audit
SQL Modes
MySQL Error Messages
The SHOW Errors Statement
The SHOW Warnings Statement
SQL Modes
Note Messages
The PERROR Utility
The General Log
The Error Log
The Slow Query Log
The Binary Logs
Storage Engines
Introduction
The MYISAM Engine
The Merge Engine
Other Engines: Archive, Memory, Federated, Blackhole, CSV
Cluster Engine Overview
Overview of High Availability Techniques
Memcached and NoSQL Overview
The InnoDB Engine
Introduction
Features of Innodb
Transactions
Referential Integrity
Physical Characteristics of Innodb Tables
System Tablespace Configuration
Log File and Buffer Configuration
Innodb Status
Backup and Restore
DAY 2
=====
Table Maintenance
Table Maintenance Operations
Check Table
Repair Table
Analyze Table
Optimize Table
MySQL Check
MYISAMCHK
Repairing Innodb Tables
Enabling MYISAM AutoRepair
Import and Export Operations
Exporting Using SQL
Importing Using SQL
Exporting from the Command Line using mysqldump
Importing from the Command Line using mysqlimport
User Management
Introduction
User Accounts
Creating Users
Renaming Users
Changing Passwords
Dropping Users
Granting Privileges
The User Table
Connection Validation
Privileges
Introduction
Types of Privileges
Revoking Privileges
Resource Limits
The MySQL Database
The Show Grants Command
Tuning & Tables
General Table Optimizations
Myisam Specific Optimizations
Innodb Specific Optimizations
Other Engine Specific Optimizations
Tuning the Server
Status Variables
Server Variables
Performance Schema Overview
The Query Cache
Replication
Replication Overview
Testing Replication