MySQL Training & Certification (Administrator)
MySQL Administrator is a powerful visual administration console that enables a user to easily administer the MySQL environment and gain significant visibility into how relational databases operate. MySQL Administrator now integrates database management and maintenance into a single, seamless environment, complete with a clear and intuitive graphical user interface.
Our systematic and planned MySQL Administrator training with real time exposure provides students the required knowledge to handle a complex data base environment.
The MySQL Administrator training course is designed to explain the MySQL administrator tasks, such as configuring and monitoring the MySQL Data base server, managing user connections and configuring backups and the restore process. It also teaches a number of other administrative tasks.
Prior Knowledge of students
The students must be familiar and comfortable with the basic SQL queries and understanding of the RDBMS concept.
MySQL Administrator Course Coverage :
- Introduction and installation of MySQL
Features of MySQL, Downloading MySQL, Installing MySQL on WINDOWS and LINUX environment
- MySQL configuration
Runtime MySQL configuration, loading time zone tables, Security related configuration,Upgrading MySQL
- Storage engines
The MyISAM, The MERGE, The InnoDB, The MEMORY, The FEDERATED
- Table Maintenance
Table maintenance operations, SQL statements for table maintenance, Client and utility programs, Repairing InnoDB tables, Enabling MyISAM Auto-Repair
- MySQL database administration
Introduction, User administration, User accounts
- Server Logs
Logging, Activating binary update logging, Error log, General query log, Slow query log
- Optimising performance
Optimising performance, Performance tuning, setting system variable, Commands for Optimisation
- Backup and Recovery
Backup Project, Schedule, Recovery, Restore, the General Tab, Restore Content
Related Open Source Training Courses: