Training: MySQL Query Optimisation

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.

Topics

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

Benefits

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.

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.

Request a course

To request a course or ask for more information, please contact me:

info@federico-razzoli.com
+44 7739 427279 (London time)
Skype: fede.razzoli
Telegram: federico_razzoli

Or just fill the following form:

Related courses

← Back to Training List