Duration: 4 Days
Discounts: We offer multiple discount options. Click here for more info.
Delivery Options: Attend face-to-face in the classroom or remote-live attendance.
This course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.
The primary audience for this course is individuals who administer and maintain SQL Server databases and are responsible for optimal performance of SQL Server instances that they manage. These individuals also write queries against data and need to ensure optimal execution performance of the workloads. The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.
Familiarity with database concepts, Windows desktop navigation and Transact-SQL. Attendance at the Microsoft Transact-SQL Programming course is highly recommended although not required.
|SQL Server Architecture, Scheduling, and Waits
||SQL Server I/O
||SQL Server Memory
|Concurrency and Transactions
||Statistics and Index Internals
|Query Execution and Query Plan Analysis
||Plan Caching and Recompilation
||Monitoring, Tracing, and Baselining
Course Schedule - Face-to-Face in the Classroom or Remote-Live
Choose a city below to view a schedule. If you have any questions, please call us at 978-250-4299 between 9:00 am - 5:00 pm EST.
Copyright© Hands On Technology Transfer, Inc.