MySQL Database Administration — A 5-Day CourseCourse SynopsisThis course is suitable for delegates intending to sit the 'Certified MySQL DBA I' and 'Certified MySQL DBA 2' examinations. Course ObjectivesThis 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. Suitable For
Course PrerequisitiesA working knowledge of MySQL is required. This can be gained by attendance on the Introduction to MySQL course. Publicly scheduled dates, locations, and pricesCentral London — £1495 (+VAT)
ContentsMySQL ArchitectureStarting, Stopping and Configuring MySQLSecurity-Related ConfigurationDatabase CreationClient Programs for DBA WorkCharacter Set SupportLockingStorage EnginesTable MaintenanceThe Information_Schema DatabaseBackup and RecoveryStored ProceduresUser ManagementSecuring the ServerUpgrade-Related Security IssuesOptimizing QueriesOptimizing SchemasOptimizing the ServerInterpreting Error MessagesOptimizing the EnvironmentScaling MySQL |
MySQL training UK enquiriesMySQL training UK pricesFor publicly scheduled training (individual places), see our UK training schedule. In-house training for company groups is charged at a daily rate per group — see our In-House UK Training Guidelines. Publicly Scheduled Training LocationsWe currently run public training courses in the following locations:
Most UK public training courses are available on a monthly basis. Please see the individual course outlines or our public training schedule for details. In-house (on-site) training locationsWe deliver in-house courses at client premises and/or training facilities in any part of the world which is practically and commercially accessible. Our In-house training guidelines outline our basic requirements and our UK pricing structure. To estimate costs for training in other countries, simply convert to your local currency and then make a rough calculation of our tutor's costs for travelling to and staying at your location. |
|
West Yorkshire Office
GBdirect Ltd
Training: 0800 651 0338 Please call between 0900 and 1700 (UK time) on Monday to Friday South East Regional Office
GBdirect Ltd
Training: 0800 651 0338 Please call between 0900 and 1700 (UK time) on Monday to Friday Please note: |
