SQL Server 2012 And 2014 Internals and Query Tuning (SQL-245)

SQL Server 2014 Internals and Query Tuning is an advanced 5-day course designed for experienced SQL Server professionals.
  • Virtual Classroom

    Learning Style
  • Beginner

    Difficulty
  • 5 Days

    Course Duration
Pricing
About Individual Course:
  • Individual course plan gives you access to this course
$3,995.00
$3,995.00
/ Seat
SQL Server 2014 Internals and Query Tuning is an advanced 5-day 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 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.


Course Objectives

  • Examine details of SQL Server's internal structures to determine their impact on query performance.
  • Use the SQL Server 2014 Dynamic Management Objects to determine SQL Server's internal behavior.
  • Read query plans to determine where a poorly performing query needs tuning.
  • Determine if concurrency issues are causing problems with performance and choose an appropriate solution.


Audience

  • Experienced SQL Server professionals.


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.

More Information
Technology Microsoft
Learning Style Virtual Classroom
Difficulty Beginner
Course Duration 5 Days
Language English
Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account
Sales Support

Sales (866) 991-3924

Mon-Fri. 8am-6pm CST

Have Questions? Ask Us.

Why QuickStart

Turn Training Into A Personalized Learning Experience


  • Problem Solving through ExpertConnect & Peer-To-Peer Learning
  • Find The Quickest Path To Learn With Career Paths
  • Access All Courses With Master Subscription
  • Manage Your Team With Learning Analytics
  • Virtual Classroom Training & Self-Paced Learning
  • Integrate With Your LMS Through API's