Home About Us Training Frequently Asked Questions Enroll Contact Us

Courses by Category
Click on a category below to see a listing of courses.
This course is available for customized on-site delivery for groups of 3 or more students.
Contact us today at 877-258-8987 for more information or a quote.

Scroll down the page for a list of upcoming course dates in our public calendar.

MySQL Performance and Tuning (3 days)


OTG's MySQL Performance and Tuning course is designed for those users that wish to deploy flexible and scaleable MySQL solutions. In particular, this course focuses on more complex aspects of MySQL, and provides the skills needed to manage MySQL as an OLTP database in a large enterprise.

MySQL Performance and Tuning Course Calendar (3 days)

Call for upcoming dates or on-site delivery.

1 Includes airfare from anywhere in the continental United States and some parts of Canada as well as accommodation and shuttle services.
spacer
2 Include course and course materials only.
spacer
3 Requires a broadband internet connection and microphone. Note that Virtual LIVE courses are led by an instructor, and as such start and end in local time (based on the course location), this my differ from your time zone.
spacer
For government and education pricing, please contact us.

Recommended Pre-requisites

We recommend students attend our "Implementing Databases with MySQL" and our "MySQL Administration" courses before attending this course.

Course Outline/Agenda

  • Review of MySQL fundamentals
  • Understanding MySQL storage engines
  • Benchmarking MySQL server performance
  • Optimizing indices for queries
  • Server performance tuning
  • Configuring and managing replication
  • Load balancing and high availability
  • Backup and recovery
  • MySQL system security

Class Size

This class is limited to a maximum of 12 students.

On-Site Delivery

This course is available for on-site delivery for groups of 3 or more students.

OTG offers discounted training for on-site courses of more than 3 students - call us at 877-258-8987 (or submit the form on the upper right side of this page) for more information.

Course Details
This course is delivered using our own Structured Learning method and course guide, as well as other industry recognized materials.

Instructional Materials
The following materials are used to deliver this course:
  • High Performance MySQL (O'Reilly)
Adobe PDF Logo View course guide table of contents
Requires Adobe Acrobat Reader

Enroll in this course

View upcoming course calendar

info@otg-nc.com
877-258-8987



[I liked most the instructors] presentation skills, content of materials, and exercises.

- J. J.
Sanofi Pasteur

[I liked the] instructor knowledge, course page, lab exercises, [and] bredth of material covered.

- M. V.
Atos Origin

This facility is excellent. I appreciate the quality and care taken in selecting classroom hardware. [I liked] the personal attention given by Amy during the entire process, especially in registration, travel & lodging accommodations. It is outstanding. I

- A.V.
City of Fremont

The instructor was responsive to all questions, and kept the class moving smoothly, despite different student backgrounds.

- Michael S.
WebMD

Great! Great! Great! It was an enjoyment!

- T.P.
Oklahoma University

© 2004-2023 Open Technology Group, Inc. All rights reserved.