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 (10987C 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.
Test your current knowledge Qubits42

Performance Tuning and Optimizing SQL Databases (32 Hours) Download Course Contents

Live Virtual Classroom
Group Training 1400
16 - 19 Aug GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 09 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)

04 - 07 Oct 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 1600
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
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

Course Modules

Module 1: SQL Server Architecture, Scheduling, and Waits
  • SQL Server Components and SQL OS
  • Windows Scheduling vs SQL Scheduling
  • Waits and Queues
Module 2: SQL Server I / 0
  • Core Concepts
  • Storage Solutions
  • I / 0 Setup and Testing
Module 3: Database Structures
  • Database Structure Internals
  • Data File Internals
  • TempDB Internals
Module 4: SQL Server Memory
  • Windows Memory
  • SQL Server Memory
  • In-Memory OLTP
Module 5: Concurrency and Transactions
  • Concurrency and Transactions
  • Locking Internals
Module 6: Statistics and Index Internals
  • Statistics Internals and Cardinality Estimation
  • Index Internals
  • Columnstore Indexes
Module 7: Query Execution and Query Plan Analysis
  • Query execution and optimizer internals
  • Query execution plans
  • Analyzing query execution plans
  • Adaptive query processing
Module 8: Caching and Recompilation
  • Plan cache internals
  • Troubleshooting plan cache issues
  • Automatic tuning
  • Query store
Module 9: Extended Events
  • Extended events core concepts
  • Working with extended events
Module 10: Monitoring, Tracing, and Baselining
  • Monitoring and tracing
  • Baselining and benchmarking
Download Course Contents

Request More Information

Course 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.

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.

FAQ's


Yes, fee excludes local taxes.