This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.

Who Should Attend

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of database administration and maintenance.
  • Working knowledge of Transact-SQL.

Course Content

  • Module 1: SQL Server Architecture, Scheduling, and Waits
  • Module 2: SQL Server I/O
  • Module 3: Database Structures
  • Module 4: SQL Server Memory
  • Module 5: SQL Server Concurrency
  • Module 6: Statistics and Index Internals
  • Module 7: Query Execution and Query Plan Analysis
  • Module 8: Plan Caching and Recompilation
  • Module 9: Extended Events
  • Module 10: Monitoring, Tracing, and Baselining

Frequently Asked Questions

"Performance Tuning and Optimizing SQL Databases - Course 10987-C Course" trainings are given in ("Group - One to one") two different  ways.
The one-to-one tuition fee is 1,160 €.

"Performance Tuning and Optimizing SQL Databases - Course 10987-C Course" trainings are given in two different ways.

The tuition fee as a group is 1,160 €. To create a group, you must be at least  3 people.
The one-to-one tuition fee is 1,160 €.

Our "Performance Tuning and Optimizing SQL Databases - Course 10987-C Course" trainings are one-to-one 4 days,

Our "Performance Tuning and Optimizing SQL Databases - Course 10987-C Course" trainings are group 2 days,
 

 

Exam & Certification

Participation Certificate

All trainees who participate in training will have an AcademyTech participation certificate.

Exam & Certification

Reviews

Recommendations by our happy graduates.

Popular locations for Performance Tuning and Optimizing SQL Databases - Course 10987-C Course in Russian Federation

Request more information for
"Performance Tuning and Optimizing SQL Databases - Course 10987-C Course"

Prefered Mode of Contact