SQL Server 2014 Internals and Query Tuning

Course Number: ISI-1430

• Vendor: Microsoft
• Category: Microsoft Technical Courses
• Outline: SQL Server 2014 Internals and Query Tuning PDF
• Prerequisites
• List Price

Description

This is an advanced 5-day, instructor-led course designed for experienced SQL Server professionals. This course will be presented on SQL Server 2014 and cover features specific to that version, but much of the information is relevant to SQL Server 2012 and SQL Server 2008 as well.
This 5-day intensive seminar was developed by Kalen Delaney, one of the world's leading experts in SQL Server internals. Topics to be covered include the following:
-SQL Server Architecture and Metadata
-Physical Storage Structures
-Index Design and Tuning
-Query Processing and Query Plans
-Optimization and Recompilation
-Concurrency Control: Locking, Blocking and Row Level Versioning
-In-memory OLTP
-Query Tips and Techniques
-Troubleshooting Tools
The course includes extensive demonstrations that illustrate the details of SQL Server internals as well as performance tuning techniques.

Prerequisites

Before attending this course, students should have a good understanding and practical experience of SQL Server programming and administration. This is an advanced seminar designed for experienced SQL Server professionals.

List Price

$3995.00