Optimization and monitoring of T-SQL queries

Course code: TSQL

The three-day course, designed primarily for developers, focuses on optimizing SQL queries. As part of the course, you will learn how to write quality code, search for problems and fix them.

790 EUR

956 EUR including VAT

The earliest date from 20.02.2023

Selection of dates
onas
Do you have a question?
+420 731 175 867 edu@edutrainings.cz

Professional
and certified lecturers

Internationally
recognized certifications

Wide range of technical
and soft skills courses

Great customer
service

Making courses
exactly to measure your needs

Course dates

Starting date: 20.02.2023

Type: In-person/Virtual

Course duration: 3 days

Language: en/cz

Price without VAT: 790 EUR

Register

Starting date: 27.03.2023

Type: In-person/Virtual

Course duration: 3 days

Language: en/cz

Price without VAT: 790 EUR

Register

Starting date: 29.05.2023

Type: In-person/Virtual

Course duration: 3 days

Language: en/cz

Price without VAT: 790 EUR

Register

Starting date: 17.07.2023

Type: In-person/Virtual

Course duration: 3 days

Language: en/cz

Price without VAT: 790 EUR

Register

Starting date: 04.09.2023

Type: In-person/Virtual

Course duration: 3 days

Language: en/cz

Price without VAT: 790 EUR

Register

Starting date: 06.11.2023

Type: In-person/Virtual

Course duration: 3 days

Language: en/cz

Price without VAT: 790 EUR

Register

Starting date: Individual

Type: In-person/Virtual

Course duration: 3 days

Language: en/cz

Price without VAT: 790 EUR

Register

Starting
date
Place
Type Course
duration
Language Price without VAT
20.02.2023 In-person/Virtual 3 days en/cz 790 EUR Register
27.03.2023 In-person/Virtual 3 days en/cz 790 EUR Register
29.05.2023 In-person/Virtual 3 days en/cz 790 EUR Register
17.07.2023 In-person/Virtual 3 days en/cz 790 EUR Register
04.09.2023 In-person/Virtual 3 days en/cz 790 EUR Register
06.11.2023 In-person/Virtual 3 days en/cz 790 EUR Register
Individual In-person/Virtual 3 days en/cz 790 EUR Register
G Guaranteed course

Didn't find a suitable date?

Write to us about listing an alternative tailor-made date.

Contact

Course description

The three-day course, designed primarily for developers, focuses on optimizing SQL queries. As part of the course, you will learn how to write quality code, search for problems and fix them. We will explain all this even in real situations.

Course structure

Get to know the optimization process

Reasons for optimizing queries
General optimization procedure
Optimization goals
Top database query performance killers
Indices and statistics
Configure your server and databases
Enforcement plans
T-SQL and program objects

ServerSQL Architecture

Basic concepts and principles of internal processes in SQL Server
Execution model and thread scheduling
Monitoring techniques
Dynamic management objects
ExtendedEvents
Query Store
Data structures
Organization of data in SQL Server databases
Row structure, data access pages, vertical partitioning

Indexes

Data access methods
Query Store
Query Store
Query Store

SQL Knowledge in MySQL

Basic knowledge of T-SQL (at the level of a simple SELECT statement)

Follow-up courses

MongoDB Developer en/cz

Vendor: EDU Trainings

Area: Databases

Price from

885 EUR without VAT

MongoDB Administration en/cz

Vendor: EDU Trainings

Area: Databases

Price from

885 EUR without VAT

MySQL Administration en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

MySQL Performance en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

PostgreSQL Administration en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

PostgreSQL for DB Developers en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

PostgreSQL Performance en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

SQL for beginners en/cz

Vendor: EDU Trainings

Area: Databases

Price from

460 EUR without VAT

SQL for intermediate users en/cz

Vendor: EDU Trainings

Area: Databases

Price from

460 EUR without VAT

MS SQL Server administration comprehensively and efficiently en/cz

Vendor: EDU Trainings

Area: Databases

Price from

1 210 EUR without VAT

ComGate payment gateway MasterCard Logo Visa logo