Introduction to MySQL
MySQL architecture overview
Installing MySQL & using MySQL Workbench
Database creation and structure
SQL Basics
DDL, DML, DQL
Joins, unions, subqueries
Functions: text, numeric, date
Views, triggers, stored procedures
Optimization & Performance
Index types and usage
Query optimization techniques
Explain plans
Normalization and ER modeling
Administration
User accounts, privileges, roles
Backup & restore (mysqldump)
Replication basics
MySQL configurations
Advanced Features
Partitioning and sharding concepts
Event scheduler
InnoDB features and transaction handling
MySQL with PHP/Python/Node integration