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.
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
Starting date: 03.06.2024
Type: In-person/Virtual
Course duration: 3 days
Language: en/cz
Price without VAT: 790 EUR
Starting date: 12.08.2024
Type: In-person/Virtual
Course duration: 3 days
Language: en/cz
Price without VAT: 790 EUR
Starting date: 07.10.2024
Type: In-person/Virtual
Course duration: 3 days
Language: en/cz
Price without VAT: 790 EUR
Starting date: 02.12.2024
Type: In-person/Virtual
Course duration: 3 days
Language: en/cz
Price without VAT: 790 EUR
Starting date: Upon request
Type: In-person/Virtual
Course duration: 3 days
Language: en/cz
Price without VAT: 790 EUR
| Starting date |
Place |
Type | Course duration |
Language | Price without VAT | ||
|---|---|---|---|---|---|---|---|
| 03.06.2024 | In-person/Virtual | 3 days | en/cz | 790 EUR | Register | ||
| 12.08.2024 | In-person/Virtual | 3 days | en/cz | 790 EUR | Register | ||
| 07.10.2024 | In-person/Virtual | 3 days | en/cz | 790 EUR | Register | ||
| 02.12.2024 | In-person/Virtual | 3 days | en/cz | 790 EUR | Register | ||
| Upon request | In-person/Virtual | 3 days | en/cz | 790 EUR | Register | ||
| G | Guaranteed course | ||||||
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.
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)
Price from
885 EUR without VAT
Price from
620 EUR without VAT
Price from
620 EUR without VAT
Price from
620 EUR without VAT
Price from
620 EUR without VAT
Price from
460 EUR without VAT
Vendor: EDU Trainings
Area: Databases
Price from
1 210 EUR without VAT
