MySQL Database Administration Design

Duration: 
5 days
Codes: 
MYS-DIA

Audience

Application and web developers, or system administrators

  • This course is rated as a Fundamentals Course, suitable for novice computer users and beginners.

Prerequisites

  • Prior experience installing software and programming in any language, such as HTML, is recommended but not required.

Course Outline

This course is designed to give administrators the knowledge and skills needed to maintain successful and efficient operations of MySQL databases and services. Administrators will gain practical experience in setting up, administering and troubleshooting the database.

On completion of the course, delegates will understand how to:

  • Start, Stop and Configure MySQL
  • Security-Related Configuration
  • Create Databases
  • Use Client Programs for DBA Work
  • Set up Character Set Support
  • Locking
  • Use Storage Engines
  • Table Maintenance
  • Obtain Data from the Information_Schema Database
  • Backup and Recovery
  • Use Stored Procedures for Database Administration Tasks
  • User Management
  • Secure the Server
  • Upgrade-Related Security Issues
  • Optimise Queries and Schemas
  • Optimise the Server - The Event Scheduler
  • Partitioned Tables
  • Interprete Error Messages
  • Optimise the Environment
  • Scale MySQL

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Midlands
Birmingham5 2500 £2500 2019-02-25
Onsite
Onsite5 2500 £2500 2019-05-18