MySQL Database Administration

Course

In London

£ 1,495 + VAT

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

London
See map
3-5 Crutched Friars, EC3N 2HR

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

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 as part of the course. Before taking any exam, delegates must ensure they have the recommended experience. Course content
  • 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

£ 1,495 + VAT