Overview

The most common problem of working with SQL is performance problems. Most of the DBA and developers don't know how to write well-performing queries. So in time, this problem grows and becomes a problem for everybody the developer, DBA and the company.Statistics provided by specialized institutions point out that about 70% of the database performance problems are related to the SQL statement.Among the most common SQL statement performance problems are:Missing index or inappropriate indexLack of statistics, outdated statistics or inaccurate statisticsQuality of the SQL statement codeThe level of knowledge of each of these topics is very important in the SQL Tuning tasks, so in this course we will explore in detail the use of indexes by the Optimizer in choosing the execution plan.This training has a very strong focus on the practical part, I believe the best way to consolidate knowledge is through practice.All the theories of this training are accompanied by practical demonstrations that you can replicate in a virtual environment that will be made available in the training.In addition, you will be invited to perform 20 practical exercises on the proposed topics that will be solved and commented on in the last 3 training classes.

Skills

Reviews