MySQL Database Administration Fundamentals
Book Now - 2 Delivery Methods Available:
Classroom Virtual Classroom Private Group - Virtual Self-Paced OnlineOverview
This MySQL Database Administration course is designed for MySQL Database Administrators who have a basic understanding of a MySQL database and SQL commands. The course provides practical experience in setting up and maintaining a MySQL server, including backing up, recovery, configuration and optimization.
Objectives
The delegate will practise:
- Starting, Stopping and Configuring MySQL
- Security-Related Configuration
- MySQL Database Creation
- Using Client Programs for MySQL DBA Work
- Setting up Character Set Support
- Locking
- Using Storage Engines, including the MyISAM and InnoDB engines
- Table Maintenance
- Obtaining Data from the Information_Schema Database
- Backup and Recovery, including Exporting (mysqldump) and Importing (mysqlimport
- Using Stored Procedures and Triggers for Database Administration Tasks
- User Management
- Securing the Server
- Upgrade-Related Security Issues
- Optimizing Queries
- Optimizing Schemas
- Optimizing the Server
- The Event Scheduler
- Partitioned Tables
- Interpreting Error Messages
- Optimizing the MySQL Environment
- Scaling MySQL, including Replication
Training Partners
We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.
Modules
Prerequisites
A working knowledge of MySQL is required. This can be gained by attendance on the Introduction to MySQL course.
Additional Learning
The courses below may help you meet the knowledge level required to take this course.
-
Introduction to MySQL
The Introduction to MySQL training course is intended for those with little or no previous experience with a relational database management system
Scheduled Dates
Please select from the dates below to make an enquiry or booking.
Pricing
Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.