Štruktúra kurzu
Táto časť nie je lokalizovaná
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)