Training: MySQL Query Optimisation

MySQL Query Optimisation is a 2 days training, designed to be suitable for novice to expert developers. It is also useful for analysts, data scientists, and DBAs who work on index tuning.

This training includes all aspects of query optimisation and index design. It is extremely interactive and it presents many realistic examples. Explanations are designed to make practical examples as intuitive as possible, leading the attendees to understand the necessary concepts by themselves.

Topics

  • Understanding performance optimisation
  • Understanding indexes
  • The EXPLAIN commands
  • Optimising WHERE clauses
    • Operations that can be optimised
    • AND, OR and NOT connectors
    • Equality and range searches
  • Functions and virtual columns
  • Covering indexes
  • ORDER BY and materialisation
  • GROUP BY and HAVING
  • Optimising JOINs
  • Subqueries
  • Multi-table DELETEs and UPDATEs
  • Transactions and locks

Cost and timing

The MySQL Query Optimisation training has a cost of 2,000GBP per attendee and its duration is 2 days.

Strong discounts can be negotiated if your company has more than four attendees.

If the training is not remote and doesn’t take place in London, UK, the cost of travel and accommodation will be added to the total.

Requirements

A basic SQL knowledge is required.

Attendees are strongly encouraged to bring their laptops with MySQL installed. For exercises and examples, the recommendation is to use mysql or mycli command-line interface. However, any program will work.

If your company is going to host the course, please be sure that a projector and a whiteboard are in the room.

Questions?

Don’t hesitate to contact me.

← Back to Training List