SQL Performance Explained

This is a two-day course, taught in English, materials are also in English.

After this training :

• You will know how database indexes really work.
• You will understand the causes of slow index lookups and prevent them.
• You will know why database indexing is a development task.
• You will love execution plans.
• You will exploit multi-column indexes to their full extend.
• You will apply SQL functions correctly.
• You will understand the importance and effects of bind parameters.
• You will recognize common anti-patterns and use the more efficient alternatives.
• You will know about the impact of growing load on the response time.
• You will understand that an index on the join predicates is not always the right choice.
• You will understand the performance impact of ORM tools and know what to do about it.
• You will use indexes to optimize order by clauses.
• You will implement efficient pagination queries in SQL.
• You will not be confused by those countless SQL performance myths.
• You will get the best out of the hardware.
• You will write faster SQL.

Investment: 800€

For registration, fill in the form below