MySQL DBA

  • 365-day access

  • Learn at your own pace

  • Your Course, Your Time, Your Comfort

  • Doubts clarification via mail/call/WhatsApp

  • Same cirriculum as that of Live Training

  • Less cost compared to Live Training

  • Recommended for busy/working professionals

About the Course

MySQL is the world’s most popular open source database management system.

MySQL is very fast, reliable, scalable, and easy to use ,cross-platform and is compliant with the ANSI SQL standard.

Its reliability, performance, scalability, and ease of use make MySQL a popular choice for developers.

MySQL it at the heart of demanding, high-traffic applications such as Facebook, Netflix, Uber, Airbnb, Shopify, and Booking.com.

MySQL is ideal for both small and large applications.

Course Curriculum

  • Introduction to MySQL Database Administration

  • Understand MySQL Editions, Distributions, Releases

  • Understand MySQL Architecture

  • Installing MySQL Server

  • Exploring MySQL Programs and File Structure

  • MySQL Data Directory

  • Connecting to MySQL Server locally as well as remotely

  • Perform Basic Database Administration tasks

  • MySQL Startup & Shutdown

  • MySQL Data Dictionary

  • MySQL Programs - Client, Administrative and Utility Programs

  • MySQL Server Logs

  • Configuring MySQL

  • Configuration Files & Options

  • MySQL System Databases

  • MySQL Storage Engines

  • InnoDB Storage Engine

  • Other Storage Engines

  • Creating and Managing User Databases

  • MySQL User Administration

  • MySQL Privileges Administration

  • MySQL Backup and Restore

  • Troubleshoot MySQL server issues.

  • MySQL Security

  • Upgrading MySQL Server

  • Uninstalling MySQL Server

Course Recordings

Introduction to MySQL Server

Introduction to MySQL
Preview

MySQL Architecture

MySQL Server Architecture

Installing MySQL Server

MySQL Installation Guide
Overview of MySQL Installation
Preview
Lab Practice: Installing MySQL Server
Preview

Exploring MySQL Installation

MySQL Programs, Files and Directories

Connecting to MySQL Server

Connecting to MySQL Server and executing Commands

Managing the Startup and Shutdown of MySQL Server

Managing the Startup and Shutdown of MySQL Server

MySQL System Databases

Overview of MySQL System Databases

About MySQL Programs

Overview of MySQL Programs
Invoking MySQL Programs
Specifying Options on the Command Line
Specifying Options in Option Files
Specifying Options using Environment Variables

Using MySQL Programs

mysql-config-editor
mysqladmin
mysqlshow
mysqlimport
mysqlcheck
mysql-tzinfo-to-sql

Server Configuration

About Configuring MySQL Server
Sever Command Options
Sever System Variables
Server Status Variables

Managing MySQL Accounts

About Managing MySQL Accounts
Installing MySQL Client on Windows
Lab Practice: Managing MySQL Accounts

Managing Privileges

About Privileges in MySQL
Lab Practice: Managing Privileges

Managing Roles

About Roles
Lab Practice: Managing Roles

Managing Databases

Overview of Managing Databases
Lab Practice: Creating, Using and Dropping Databases

MySQL Storage Engines

Overview of MySQL Storage Engines
Lab Practice: MySQL Storage Engines

InnoDB Storage Engine

Creating File-Per-Table Tablespaces
Managing File-Per-Table Tablespaces
Overview of General Tablespaces
Lab Practice: Creating and Managing General Tablespaces
Overview of System Tablespace
Lab Practice: Managing System Tablespace
Overview of Undo Tablespaces
Lab Practice: Managing Undo Tablespaces
Overview of Temporary Tablespaces
Lab Practices: Managing Temporary Tablespaces