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
  • 52 mins
  • 44.5 MB
Preview

MySQL Architecture

MySQL Server Architecture
  • 9 mins
  • 6.36 MB

Installing MySQL Server

MySQL Installation Guide
  • 104 KB
Overview of MySQL Installation
  • 6 mins
  • 3.81 MB
Lab Practice: Installing MySQL Server
  • 38 mins
  • 50.5 MB

Exploring MySQL Installation

MySQL Programs, Files and Directories
  • 22 mins
  • 21.8 MB

Connecting to MySQL Server

Connecting to MySQL Server and executing Commands
  • 28 mins
  • 26.1 MB

Managing the Startup and Shutdown of MySQL Server

Managing the Startup and Shutdown of MySQL Server
  • 21 mins
  • 23.4 MB

MySQL System Databases

Overview of MySQL System Databases
  • 34 mins
  • 32.2 MB

About MySQL Programs

Overview of MySQL Programs
  • 20 mins
  • 16 MB
Invoking MySQL Programs
  • 12 mins
  • 9.27 MB
Specifying Options on the Command Line
  • 18 mins
  • 18.6 MB
Specifying Options in Option Files
  • 38 mins
  • 37.8 MB
Specifying Options using Environment Variables
  • 6 mins
  • 6.42 MB

Using MySQL Programs

mysql-config-editor
  • 25 mins
  • 19.4 MB
mysqladmin
  • 10 mins
  • 12.1 MB
mysqlshow
  • 5 mins
  • 4.89 MB
mysqlimport
  • 10 mins
  • 8.31 MB
mysqlcheck
  • 5 mins
  • 6.69 MB
mysql-tzinfo-to-sql
  • 8 mins
  • 7.52 MB

Server Configuration

About Configuring MySQL Server
  • 21 mins
  • 46.1 MB
Sever Command Options
  • 7 mins
  • 4.75 MB
Sever System Variables
  • 54 mins
  • 59 MB
Server Status Variables
  • 7 mins
  • 8.55 MB

Managing MySQL Accounts

About Managing MySQL Accounts
  • 17 mins
  • 11.9 MB
Installing MySQL Client on Windows
  • 14 mins
  • 15.6 MB
Lab Practice: Managing MySQL Accounts
  • 24 mins
  • 26.4 MB

Managing Privileges

About Privileges in MySQL
  • 35 mins
  • 31 MB
Lab Practice: Managing Privileges
  • 37 mins
  • 38.6 MB

Managing Roles

About Roles
  • 13 mins
  • 8.86 MB
Lab Practice: Managing Roles
  • 23 mins
  • 19.8 MB

Managing Databases

Overview of Managing Databases
  • 21 mins
  • 18.8 MB
Lab Practice: Creating, Using and Dropping Databases
  • 21 mins
  • 26.1 MB

MySQL Storage Engines

Overview of MySQL Storage Engines
  • 41 mins
  • 33.5 MB
Lab Practice: MySQL Storage Engines
  • 25 mins
  • 24.9 MB

InnoDB Storage Engine

Creating File-Per-Table Tablespaces
  • (1h 04m 13s)
  • 71.3 MB
Managing File-Per-Table Tablespaces
  • 31 mins
  • 28.7 MB
Overview of General Tablespaces
  • 9 mins
  • 6.05 MB
Lab Practice: Creating and Managing General Tablespaces
  • 20 mins
  • 25.1 MB
Overview of System Tablespace
  • 16 mins
  • 13.2 MB
Lab Practice: Managing System Tablespace
  • 43 mins
  • 113 MB
Overview of Undo Tablespaces
  • 17 mins
  • 12.8 MB
Lab Practice: Managing Undo Tablespaces
  • 34 mins
  • 51 MB
Overview of Temporary Tablespaces
  • 17 mins
  • 16.9 MB
Lab Practices: Managing Temporary Tablespaces
  • 20 mins
  • 23.9 MB