MySQL Performance Tuning Training Course in London

Course Price:
Course Type: Classroom Based, instructor-led and Hands-on
Location: Kings Cross, London

When is this course running

Course is not currently running, contact us for more information about this course.

MySQL Performance Tuning Course overview

If you want to learn MySQL Performance Tuning using a variety of techniques and tools then our MySQL Performance Tuning course is exactly what you need.

The courses content will help delegates understand the basis for MySQL Performance Tuning so that they can competently navigate independently through different software. You will learn essential components of MySQL Performance Tuning.

Our MySQL Performance Tuning course will allow you to interact with the tutor on a one-to one basis and receive tailored help to suit your learning needs.Our tutors have had years of industry practice and can offer course times to suit your busy schedule, whether that be in the evening or on weekends.

This short MySQL Performance Tuning course in London is hands-on, instructor-led and classroom based in London. This training can be taken as a part-time evening course or even on the weekends.

Prerequisites for our MySQL Performance Tuning course

Required Prerequisites:

  • Experience maintaining a database server (preferably a MySQL server)
  • Can use MySQL tools to connect to the MySQL Server
  • Have knowledge of general SQL statement structure and basic SQL tuning principles
  • Working knowledge of Linux operating systems

Suggested Prerequisites:

  • MySQL for Database Administrators
  • Experience with a MySQL Server instance and MySQL tools
  • Experience writing SQL retrieve, insert, modify and delete
  • An ability to locate and execute commands on Linux

What will I learn?

  • Introduction
  • Performance Tuning Basics
  • Performance Tuning Tools
  • MySQL Server Tuning
  • MySQL Query Cache
  • InnoDB
  • MyISAM
  • Other MySQL Storage Engines and Issues
  • Schema Design and Performance
  • MySQL Query Performance
  • Performance Tuning Extras
  • Conclusion
RT @epowell101: Step by step blog on getting to šŸ¤Æ performance of @Percona MySql on @openebs by @MayaData https://t.co/xxlWRzjfWG -> thankā€¦
RT @epowell101: Step by step blog on getting to šŸ¤Æ performance of @Percona MySql on @openebs by @MayaData https://t.co/xxlWRzjfWG -> thankā€¦
RT @mariadb: Our recent #database benchmark compares the latest versions of #MariaDB and #MySQL using easily accessible commodity #cloud haā€¦
RT @epowell101: Step by step blog on getting to šŸ¤Æ performance of @Percona MySql on @openebs by @MayaData https://t.co/xxlWRzjfWG -> thankā€¦
RT @epowell101: Step by step blog on getting to šŸ¤Æ performance of @Percona MySql on @openebs by @MayaData https://t.co/xxlWRzjfWG -> thankā€¦
RT @awscloud: AWS Graviton2-based database instances are now generally available for Amazon RDS for MySQL, Amazon RDS for PostgreSQL & Amazā€¦
I've been using PostgreSQL for more than a year now (from MySQL) and I STILL get giddy about using a simple TEXT fiā€¦ https://t.co/f45dtptRHd
RT @awscloud: AWS Graviton2-based database instances are now generally available for Amazon RDS for MySQL, Amazon RDS for PostgreSQL & Amazā€¦
@Tyler_Potts_ Same. This week for work was a lot of LAMP WP, but also Magento, Laravel. On stream I do my own JAMā€¦ https://t.co/aO46W29McE
Optimize MySQL System Variables for High Performance #Database #MySQL #DB #optimize #optimization #Developmentā€¦ https://t.co/PzIBmHhpKC
Stephanie Warner Bros
It was challenging at a good level, we worked through real life scenarios and didn't just improve something but really enhanced it.
Robert United Nations
Very well presented course. There is a lot to learn, and there were some good handouts to practice from home.