MySQL Skill

Overview

Master MySQL database administration, optimization, and development for production environments.

Topics Covered

MySQL Basics

• Installation and configuration
• User management
• Database creation
• Storage engines (InnoDB, MyISAM)
• Character sets

Query Development

• SELECT statements
• JOINs and subqueries
• INSERT, UPDATE, DELETE
• Stored procedures
• Triggers and events

Performance

• EXPLAIN analysis
• Index optimization
• Query cache (8.0+ changes)
• Slow query log
• Performance Schema

Administration

• Backup with mysqldump
• Binary log management
• Replication setup
• User privileges
• Configuration tuning

High Availability

• MySQL replication
• Group replication
• MySQL Router
• ProxySQL
• Failover strategies

Prerequisites

• SQL fundamentals
• Linux basics
• Networking concepts

Learning Outcomes

• Administer MySQL servers
• Optimize queries
• Set up replication
• Manage backups