T‑SQL Performance
Optimize the efficiency of your
T‑SQL queries & ETL code
Skill Level: PowerUser
SQL Server Course:
T‑SQL Performance
2-Day Course
Summary
If you're serious about
writing efficient SQL,
this course is for you.
T‑SQL Performance covers:
  • System, Memory & Version
  • Primary Keys and Indexes
  • Query Tuning Basics
  • Reviewing Execution Plans
  • Other Data Model Factors
  • Stored Procedures and UDFs
  • Bulk-Logged Operations
  • Transactions & Wait States
  • Table Partitioning
Course Details
SSMS Monitor
Available Soon
T‑SQL Performance
2-Day Course
Course Name:
T‑SQL Performance
Database:
MS SQL Server 2012-2017
Course Format:
Live Instructor, Hands-On
Course Duration:
Two Days (9AM to 5PM)
Course Delivery:
On-Site Only (Available Soon)
Prerequisite:
Content of T‑SQL Programming
Available Soon
T‑SQL Performance
Description
This course covers a variety of performance techniques: indexes, execution plans & query tuning, stored procedures and UDFs, bulk-logged operations, transactions & wait states, and more.
Topics are illustrated with code examples, runnable scripts and hands-on exercises. Basic tuning challenges allow students to practice the new techniques they learn in the course.
View the course outline(Available Soon)
Course Docs
T-SQL Performance: Course Outline
Available Soon
T‑SQL Performance
Course Outline
T-SQL Performance: Content Sample
Available Soon
T‑SQL Performance
Sample Content
Who Should Attend?
T‑SQL Performance
Audience
T‑SQL Performance is for business users with solid T‑SQL experience who need to quickly isolate issues and optimize the performance of their queries and ETL code.
The course focuses on design and tuning methods used in scenarios that users often run into when working with T‑SQL.
NOTE:  To attend this course, you need hands-on experience with all or most of the topics in my course, T‑SQL Programming.
[09]
[09]
[This button does not display]
[This button does not display]
[This button does not display]
[This button does not display]
[09]
[09]
[This button does not display]
[This button does not display]
[This button does not display]
[This button does not display]
[09]
[09]
[This button does not display]
[This button does not display]
[This button does not display]
[This button does not display]
[09]
[09]
[This button does not display]
[This button does not display]
[This button does not display]
[This button does not display]