Training
SQL Server Query Performance Tuning
SQL Server is easy to start working with but there can be a lot to learn before you get the best possible performance from it.

This course is one of our most favourite courses and covers SQL Server table structures, indexing and performance, with just the right depth, and within two days.

The course is targeted at application developers that are generating T-SQL queries and designing SQL Server applications and also to existing SQL Server developers and DBAs.

While our courses are based on SQL Server 2016, we realise that many customers are not yet running that version. Rather than provide you a course that only covers a single version of SQL Server, our courses are designed to be relevant (wherever possible) to a range of SQL Server versions including SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 and SQL Server 2016. Where there are differences between versions, the differences are clearly highlighted.

City
Dates
Course Price
Early Bird Price
Melbourne
21 Sep - 22 Sep 2017
$1400+GST
$1190+GST if paid by Sep 7
Day
Code
Module
1
QP201
SQL Server Indexing Core Concepts
- Core Indexing Concepts
- Table and Index Structures
- Index Effectiveness
- LAB: SQL Server Indexing Core Concepts
1
QP202
Designing Effective Indexes for SQL Server
- Indexing for Constraints
- Clustering Keys and Data Types
- Indexing Strategies
- LAB: Designing Effective Indexes for SQL Server
1
QP203
Working with Query Plans
- Understanding Execution Plans
- Capturing Execution Plans
- Data Collection and Query Store
- LAB: Working with Query Plans
1
QP204
Reading SQL Server Execution Plans
- Common Plan Elements
- Join Strategies
- Aggregations
- Data Modifications
- Views and Indexed Views
- Query Hints
- LAB: Reading SQL Server Execution Plans
2
QP205
Tracing and Profiling SQL Server Queries
- SQL Server Profiler
- Query Tracing using SQL Trace
- Query Tracing using Extended Events
- Identifying Queries to Optimize
- LAB: Tracing and Profiling SQL Server Queries
2
QP206
SQL Server Transactions and Concurrency
- Transaction Isolation Levels
- Lock Modes, Hints, Duration, and DMVs
- Deadlocks
- Row Version Tables
- LAB: SQL Server Transactions and Concurrency
2
QP207
Maintaining Query Efficiency
- Index and Heap Fragmentation
- Query Compilation and Plan Caching
- Cursors vs Set-Based Operations
- Temporary Tables vs Table Variables
- LAB: Maintaining Query Efficiency
2
QP208
Working with In-Memory Tables and Indexes
- Memory-Optimized Tables
- Indexes on Memory-Optimized Tables
- Natively-Compiled Modules
- LAB: In-Memory Tables and Indexes
Phone: 1300 SQL SQL (1300 775 775) l International +61 1300 775 775 l Fax: +61 3 8676-4913
Copyright 2017 by SQL Down Under | Terms Of Use | Privacy Statement