MySQL Database Adminstration

Instructor-led Live Online Training

About the MySQL Database

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.

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
MySQL Command Options & System Variables
MySQL Server System Variables and Status Variables
MySQL Option Files
Managing MySQL Accounts - Creating, Altering, Renaming, Dropping
Managing MySQL Privileges
Administrative Privileges
Database Privileges
Object Privileges
Granting and Revoking Privileges
Grant Tables
Managing MySQL Roles
Creating Roles
Granting and Revoking Privileges to/from Roles
Activating Roles
Dropping Roles
Managing MySQL Databases
MySQL System Databases
Creating and Dropping Databases
Sample Databases
MySQL Supported Storage Engines - InnoDB, MyISAM, Memory, CSV, Archive, Blackhole, NDB, Merge, Federated
Storage Engines Feature Summary
MySQL Pluggable Storage Engine Architecture
Installing & Uninstalling Storage Engines
InnoDB Storage Engine
InnoDB Architecture
InnoDB Tablespaces, Redo Logs, Doublewrite Buffer Files
InnoDB Buffer Pool, Log Buffer
MySQL Backup and Restore
Upgrading MySQL Server
Uninstalling MySQL Server