Module 1: Introduction to MySQL 8.0
- MySQL database architecture
- Overview of MySQL 8.0 features and functionalities
Module 2: Installing and Configuring MySQL 8.0
- Installing MySQL 8.0 on Linux and Windows
- Configuring MySQL 8.0 server and clients
Module 3: MySQL 8.0 Tools and Techniques
- Using MySQL 8.0 Workbench
- MySQL Shell and MySQL Client
- MySQL Router and MySQL Router Plugins
- MySQL 8.0 Performance Tuning
Module 4: MySQL 8.0 Security
- MySQL 8.0 Security Best Practices
- MySQL 8.0 Authentication and Authorization
Module 5: MySQL 8.0 Development
- Developing MySQL 8.0 Applications
- MySQL 8.0 Connector and APIs
- MySQL 8.0 Stored Procedures and Functions
Module 6: MySQL 8.0 Administration
- Backup and Restore in MySQL 8.0
- MySQL 8.0 Replication
- Scaling MySQL 8.0
Module 7: Troubleshooting in MySQL 8.0
- Diagnosing and Fixing MySQL 8.0 Errors and Issues
- MySQL 8.0 Monitoring and Performance Optimization