MySQL Database Administration for Experienced Database Administrators

StayAhead Training Ltd

Course

In London

£ 1,195 VAT inc.

The best Other Database courses

See all

See all

Description

  • Type

    Course

  • Location

    London

  • Class hours

    21h

  • Duration

    3 Days

Suitable for: Anyone with substantial experience of an alternative relational database management system who now needs to administer, monitor and support MySQL databases and servers

Facilities

Location

Start date

London
See map
6 Long Lane, Barbican, EC1A 9HF

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

Subjects

  • To provide the skills necessary to administer
  • Monitor and support MySQL databases and servers

Course programme

The delegates 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

See related categories

MySQL Database Administration for Experienced Database Administrators

£ 1,195 VAT inc.

The best Other Database courses

See all

See all