This course enables the participants to learn SQL server architecture, indexing, statistics strategies, optimization of transaction log operations, blocking and locking. In addition, the courses enable you to create baselines and benchmark SQL server performance; workload analysis, and rule out performance issues.
Course Objective:
On completion of this course you will be able to understand:
Module 1: Course Overview
Introduction, Course materials, facilities, and prerequisites
Module 2: SQL 2014 Architecture
Module 3: The Database Engine
Module 4: SQL Performance Tools
Module 5: Query Optimizing and Operators
Module 6: Understanding Indexes
Module 7: Understanding Statistics
Module 8: In-Memory Database
Module 9: SQL Profiler and SQL Trace
Module 10: Query Issues and Hints
Individuals administering and maintaining SQL Server databases
Name | Code | Fee |
---|---|---|
SQL 2014 Performance Tuning | 55144 | USD 100 |
OR