MySQL Database Administration
Course
In London
Description
-
Type
Course
-
Location
London
-
Duration
5 Days
This course is designed to give administrators the knowledge and skills needed to maintain successful and efficient day-to-day operations of MySQL databases and services. Administrators will gain practical experience in setting up, administering and troubleshooting MySQL databases. They will gain an understanding of the architecture of a MySQL database. They will be able to ensure the integrity and availability of a company's data within the MySQL environment. Note: Exams are not included.
Facilities
Location
Start date
Start date
Reviews
Course programme
- MySQL Architecture
- Starting, Stopping and Configuring MySQL
- Security-Related Configuration
- Database Creation
- Client Programs forDBAWork
- Character Set Support
- Locking * Storage Engines
- Table Maintenance
- The Information_Schema Database
- Backup and Recovery
- Stored Procedures
- User Management
- Securing the Server
- Upgrade-Related Security Issues
- Optimizing Queries
- Optimizing Schemas
- Optimizing the Server
- Interpreting Error Messages
- Optimizing the Environment
- Scaling MySQL
MySQL Database Administration