MySQL For Database Administrators

 

Course Objectives

  • MySQL Database Architecture
  • MySQL Database Administration Essentials

Prerequisites

  • General IT technical knowledge
  • Understanding of RDBMS concepts
  • Previous RDBMS Database Administration Experiance (Oracle, MS SQL Server, etc.)

Course Outline

  • Introduction to MySQL
    • Why MySQL?
    • Brief History of MySQL
  • MySQL Installation
    • MySQL Software Installation Methods
    • Hardware and Software Prerequisites
    • User Accounts and Environment Variables
  • MySQL Server Basics
    • MySQL Server Configuration and Defaults
    • MySQL Server System and Status Variables
    • MySQL Server SQL Modes
  • MySQL CLI
    • mysql
    • mysqladmin
    • mysqlcheck
    • mysqlshow
    • mysqldump
    • mysqlimport
  • MySQL Server Logs
    • MySQL Error Log
    • MySQL General Query Log
    • MySQL Slow Query Log
    • MySQL DDL Log
    • MySQL Binary Log
    • MySQL Server Log Maintenance and Rotation
  • MySQL Data Dictionary
    • Understanding Metadata
    • INFORMATION_SCHEMA
  • MySQL Server Security
    • MySQL General Security Issues
    • MySQL User Account Management
    • MySQL Access Privileges
    • MySQL Connection Encryption
  • MySQL Server Backup and Recovery
    • MySQL Backup and Recovery Methods
    • MySQL Backup and Recovery Strategies
    • Introducing Point-in-time recovery
  • MySQL Storage Engines
    • InnoDB Storage Engine
    • MyISAM Storage Engine
    • MEMORY Storage Engine
    • ARCHIVE Storage Engine
    • NDB Storage Engine (MySQL Cluster)
    • Other Storage Engines
  • MySQL Table Partitioning
    • MySQL Table Partitioning Overview
    • MySQL Partition Types
    • MySQL Partition Management
    • MySQL Partition Pruning
    • MySQL Partitioning Restrictions
  • MySQL Procedural Programming
    • MySQL Stored Procedures
    • MySQL Functions
    • MySQL Triggers
    • MySQL Event Scheduler