• Build in and Upgrade MySQL for the most common operating systems
• Exploit the MySQL Administrator Graphical User Interface (GUI) to control a MySQL server
• Benefit the INFORMATION_SCHEMA database to approach metadata
• Execute the MySQL start and shutdown operations
• Setup MySQL server options at runtime
• Check out data types and character sets for performance issues
• Comprehend data locking concepts and the various levels of locking in MySQL
• Extricate between the multiple storage engines available in MySQL
• Accomplish backup and restore operations utilizing multiple MySQL tools
• Control integrity of a MySQL installation utilizing security protocols
• Benefit stored routines and triggers for administration tasks
• Control, apply and discern the reason for using views
• Enhance performance through query optimization
• Optimize Schemas (Databases) utilizing multiple techniques
• Employ MySQL monitoring tools to develop server performance
• Correlate multiple environment options to improve server performance

• Visit the MySQL for Beginners course or some involvement with Relational Databases and SQL

After Successful completion this course, you will be able to:-

• Introduction
• MySQL Architecture
• The MySQL Server
• Configuring the MySQL Server
• MySQL Clients
• Overview of Data Types
• Metadata
• Storage Engines
• Partitioning
• Transactions and Locking
• Security and User Management
• Table Maintenance
• Export and Import Data
• Program with MySQL
• Backup and Recovery