MYSQL DBA

Module 1: Database Basics – RDBMS
----------------------------------------------
Concepts: Data, tables, relationships, normalization, ACID properties.

Hands-on lab: Create a sample schema with normalized tables.

Outcome: Students understand how relational databases store and manage data.

Database Basics – RDBMS

Module 2: MySQL Installation and Configuration
------------------------------------------------------
Concepts: Installing MySQL on Linux/Windows, my.cnf configuration, ports, data directory.

Hands-on lab: Install MySQL, configure a custom port (like 3307), and start the service.

Outcome: Students can set up and configure MySQL servers.

MySQL Installation and Configuration.

Module 3: MySQL Backup and Restore
-----------------------------------
Concepts: Logical backups (mysqldump), physical backups, point-in-time recovery.

Hands-on lab: Take a backup of a database, drop a table, and restore it.

Outcome: Students can protect and recover data.

MySQL Backup and Restore

Module 4: User Creation and Security
-------------------------------------
Concepts: User accounts, privileges, roles, password policies, SSL connections.

Hands-on lab: Create users with different privileges, test access restrictions.

Outcome: Students can secure MySQL environments.

User creation and security

Module 5: Troubleshooting and Performance Tuning/Optimization
---------------------------------------------------------------
Concepts: Query optimization, indexes, slow query log, EXPLAIN plan, server parameters.

Hands-on lab: Identify slow queries, add indexes, measure improvements.

Outcome: Students can diagnose and optimize performance issues.

Troubleshooting and Performance Tuning/Optimization

Module 6: MySQL DB Replication
--------------------------------
Concepts: Master-slave replication, GTID, semi-sync replication, failover.

Hands-on lab: Configure replication between two servers, test failover.

Outcome: Students can set up high availability.

MySQL DB Replication

Module 7: MySQL DB Monitoring
-------------------------------
Concepts: Monitoring tools (MySQL Enterprise Monitor, Percona Monitoring, Prometheus + Grafana), logs, alerts.

Hands-on lab: Set up monitoring with performance_schema and Grafana dashboards.

Outcome: Students can proactively monitor and maintain MySQL health.

MySQL DB Monitoring