Microsoft/Performance Tuning and Optimizing SQL Databases/10987-C


Performance Tuning and Optimizing SQL Databases Certification Training Course Overview

This Microsoft SQL Server 2016 training on Performance Tuning and Optimizing SQL Databases (10987A course) imparts core knowledge and skills to database management and maintenance professionals to ensure performance tuning and optimization of their SQL database deployments.
 
The SQL Server 2016 Performance & Tuning course is best suited for professionals who manage, maintain and administer SQL databases. Those who are responsible for writing queries and ensuring optimal performance of workloads are also the right audience for this SQL 2016 training.
Download Course Contents Test your current knowledge Qubits42

Performance Tuning and Optimizing SQL Databases Course schedule & Prices

Course Details Schedule
Live Virtual Classroom (Instructor-Led)
Duration : 4 Days (8 Days for 4 Hours/Day)
Fee : 1,300 (Includes Taxes) 
9 AM - 5 PM (Flexible Time Slots for 4 hours option)






January
8 Hours/Day
4 Hours/Day
18-21
18-27
February
8 Hours/Day
4 Hours/Day
01-04
07-10
08-11
01-10
07-16
08-17
March
8 Hours/Day
4 Hours/Day
01-04
07-10
08-11
01-10
07-16
08-17
April
8 Hours/Day
4 Hours/Day
05-08
11-14
12-15
05-14
11-20
12-21
Client's Location
As per mutual convenience

Classroom training is available in select Cities
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request

Special Solutions for Corporate Clients! Click here

Hire Our Trainers! Click here

Request More Information

Course Prerequisites
  • Basic Computer Knowledge.

Upon Completion of this Course, you will accomplish following:-

  • Understand the high level architecture of SQL Server 2016 and its different components.
  • Understand and implement the execution model of SQL Server along with waits and queues.
  • Understand and execute performance testing, SANs and core I/O concepts.
  • Define best practices and architecture overview of data files for TempDB and user databases.
  • Define best practices and architecture overview of Transactions, Isolation Levels, Concurrency, and Locking.
  • Understand the architecture of Optimizer and learn to recognize and repair issues related to query plans.
  • Define the best practices, architecture and troubleshooting scenarios related to Plan Cache.
  • Define the best practices, usage scenarios and troubleshooting strategy for Extended Events.
  • Devise a data collection strategy and define techniques for data analysis.
  • Implement tools and techniques to recognize and diagnose bottlenecks, while improving overall performance.

Give an edge to your career with Microsoft certification training courses. Students can join the classes for 10987A: Performance Tuning and Optimizing SQL Databases Training & Certification Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

Student Feedback  (Check Koenig Feedback on Trustpilot)

Q1 Say something about the Trainer? Q2 How is Koenig different from other training Companies? Q3 Will you come back to Koenig for training ?
Student Name Country Month Feedback Rating
Vinaykumar Marihal United States Oct-2019 A3. Most probably it will remain my first choice for any future training.
Basant Mishra United States Sep-2019 A3. Yes.
Murawweh Daher United States Apr-2019 A1. He have a lot of information and good experience, also he answered all questions that asked to him. Really he is perfect.

FAQ's