MySQL Query Optimisation is a 2 days training, specifically designed for novice to expert developers. It is also useful for 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
- Table order
- Subqueries vs.
- Transactions and locks
When an application is slow, most of the times the bottleneck is the database.
To obtain good performance, it is very important to design good indexes and write queries that will use them. But to be able to do this, application developers need to learn how indexes are implemented and in which way a query can take advantage of them.
Teams and individuals that attend this course will be able to solve SQL performance problems, and write blazing fast applications.
Cost and timing
The MySQL Query Optimisation training has a cost of 2,200GBP 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 does not take place in London, Europe, 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.
Request a course
To request a course or ask for more information, please contact me:
+44 7739 427279 (London time)
Or just fill the following form: