MSSQL

1 weeks

Live Course

Your Instructor

Sahil Goyal

Course Overview

This advanced Microsoft SQL Server course is designed for professionals looking to deepen their expertise in performance tuning, indexing, query optimization, and T-SQL development.

Over nine days, participants will learn to troubleshoot complex issues using SQL Server tools like DMVs, SQL Profiler, and Extended Events. The course covers essential indexing strategies, execution plan analysis, and optimization techniques to ensure efficient query performance.

Learners will also explore advanced topics such as lock management, statistics, views, triggers, stored procedures, dynamic SQL, and recursive CTEs. Through practical examples and real-world scenarios, this course equips participants with the skills needed to manage and optimize SQL Server databases effectively.

What you'll get out of this course

Learn to Troubleshoot SQL Server Performance Issues using tools like SQL Profiler, Extended Events, and DMVs to detect and resolve deadlocks and slow queries.

Understand and Apply Indexing Techniques including clustered, non-clustered, and filtered indexes to improve query performance and reduce page splits.

Read and Analyze Execution Plans to identify table scans, sort, and join operators, and use the Query Optimizer effectively for tuning queries.

Manage SQL Server Statistics and Concurrency by understanding locking, blocking, deadlocks, and optimizing TempDB and wait statistics.

Build Advanced T-SQL Solutions using views, triggers, stored procedures, dynamic SQL, and recursive CTEs for efficient and maintainable code.

Course content

Week 1

5 items

5 lectures

Week 2

4 items

4 lectures

Your Instructor

Sahil Goyal

No additional information available about this instructor at the moment.

Frequently Asked Questions

Who is this course intended for?
Do I need prior experience with indexing or execution plans?
Will there be hands-on practice?
What tools will be used in the course?