Course 10987C: Performance Tuning and Optimizing SQL Database
Database performance, tuning, and query optimization course will teach how to performance tune and optimize their databases in this four-day instructor-led course. This online course covers how optimizer statistics affect the performance of SQL and how the query optimizer makes a decision about how to access data. The course 10987C also teaches to modify an SQL statement and to identify poorly performing SQL. This curse does not teach SQL database from scratch therefore, Database/SQL knowledge is a pre-requisite for this course.
TARGET AUDIENCE
The primary audience for this course is individuals who administer and maintain SQL Server databases and are responsible for optimal performance of SQL Server instances that they manage. These individuals also write queries against data and need to ensure optimal execution performance of the workloads. The secondary audience for this course is individuals who develop applications that deliver content from SQL Server databases.
Course Topics
- SQL Server Architecture, Scheduling, and Waits
- SQL Server I/O
- Database Structures
- SQL Server Memory
- SQL Server Concurrency
- Statistics and Index Internals
- Query Execution and Query Plan Analysis
- Plan Caching and Recompilation
- Extended Events
- Monitoring, Tracing, and Baselining
Prerequisites
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of database administration and maintenance
- Working knowledge of Transact-SQL.
Flexible Class Options
- Corporate Group Training | Fast-Track
- Week End Classes For Professionals SAT | SUN
- Online Classes – Live Virtual Class (L.V.C), Online Training