Retired: Performance Tuning And Optimizing SQL Databases M10987 - United States

Who should attend?

This course is designed for those who administer and maintain SQL Server databases, manage the performance of SQL Server instances, and write queries against data. Likewise, this course is intended for individuals who develop applications that produce data from SQL Server databases. Therefore, IT Professionals in particular would benefit from this Performance Tuning and Optimizing SQL Databases training course.

Prerequisites

In order to attend this course, delegates should possess some professional experience and knowledge of the following:

• Microsoft Windows operating system and its key functions

• Database administration and maintenance

• Transact-SQL

Performance Tuning and Optimizing SQL Databases (M10987) Overview

This Microsoft SQL Server training course provides delegates with the knowledge and techniques needed to optimise and monitor the performance of their databases.

During this 4 day course, delegates will become familiar with the functionalities of SQL Server, and will explore its fundamental concepts, including the execution model, waits, and queues. The architectural concepts and best practices relating to data files, transactions, locking, concurrency, and solving query plan problems will be explored. As well as this, the elements and strategy of the plan cache and extended events will be studied.

By the end of this Performance Tuning and Optimizing SQL Databases training course, delegates will be able to explain data collection strategy, identify techniques for data analysis, and determine where improvements can be made to enhance overall performance.

The Knowledge Academy is a Microsoft Silver Partner, therefore we are an accredited provider of Microsoft training courses.

There is no associated exam for Performance Tuning and Optimizing SQL Databases.