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.
- Understanding performance optimisation
- Understanding indexes
- Operations that can be optimised
- Equality and range searches
- Functions and virtual columns
- Covering indexes
ORDER BYand materialisation
- 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.
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.
Don’t hesitate to contact me.