T-SQL for Developers

2 Day Course  |  £795.00 (+VAT)

Target Audience

This course is aimed at Developers who are using SQL Server and wish to expand their knowledge in order to write more performant t-SQL and avoid causing any server bottlenecks.

Required Knowledge

Basic T-SQL knowledge
Basic Execution Plan Analysis

Purpose of the Course

The purpose of this course is to ensure that Application Developers who use SQL Server understand some SQL Server internals in order to write highly performant and re-usable code when developing their applications.

Topics Covered

  • Basic Execution Plan Analysis
  • Indexing
  • Internal Join Types
  • Memory Grants
  • Cost Based Queues
  • Statistics
  • Parameter Sniffing
  • Parallelism
  • Intermediate Execution Plan Analysis

Course Modules

Module 1: Basic Execution Plan Analysis
  • At a Glance
  • Reads / Writes
  • The 8K Page
  • Execution Plan Warnings
Module 2: Indexing
  • Clustered Indexes
  • Non Clustered Indexes
  • Key Columns vs Included Columns
  • Filtered Indexes and gotchas
Module 3: Optimizer Join Types
  • Loop Join
  • Merge Join
  • Hash Join
  • Adaptive Query Joins
Module 4: Memory Grants
  • Spills
  • Concurrency
Module 5: Statistics
  • How to Read a Statistic
  • Performance Impact
  • Statistics Maintenance Tips
  • Filtered Statistics
  • Incremental Statistics
Module 6: Parallelism
  • How it works
  • Performance Boost
  • Performance Pitfalls
  • Optimizer Flaws
Module 7: Cost Based Queries
  • Query Cost
  • Costing Pyramid
  • Concurrency Issues
Module 8: Parameter Sniffing
  • What is Parameter Sniffing?
  • Plan Cache Limitations
  • Alternative Strategies
Module 9: Intermediate Execution Plan Analysis
  • Aggregation Operators
  • Blocking Operators
  • Estimation Quirks
Would you like to discuss your training requirements with me?
I'm always happy to help so, whatever your question, simply give me a call or send me a message and I'll get back to you as quickly as possible.
Copyright © 2018 London SQL Server Training Courses @ SQL Training | Website Design From Scott Heron