Training
SQL Server Query Performance Tuning and Advanced T-SQL
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. And even though it's easy to get started writing T-SQL code, there is also a lot to learn if you want to make sure that your code effectively uses the current features of the product and is easy to maintain.

This course combines two of our most favourite courses into a single week. The first two days of the course cover SQL Server table structures, indexing and performance. The last three days of the course provide insights into using T-SQL effectively.

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 2012, 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 2005, SQL Server 2008, SQL Server 2008 R2 and SQL server 2012. Where there are differences between versions, the differences are clearly highlighted.
City
Dates
Course Price
Early Bird Price
Darwin
30 Jun - 04 Jul 2014
$3500+GST
$3500+GST if paid by Jun 13
Melbourne
08 Sep - 12 Sep 2014
$3500+GST
$2975+GST if paid by Aug 22
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
Reading SQL Server Execution Plans (Part 1)
- Understanding Execution Plans
- Capturing Execution Plans
- Common Execution Plan Elements
- LAB: Reading SQL Server Execution Plans (Part 1)
1
QP204
Reading SQL Server Execution Plans (Part 2)
- Join Strategies
- Aggregates
- Data Modifications
- Query Hints
- LAB: Reading SQL Server Execution Plans (Part 2)
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
- Index Maintenance and Optimization
- Query Compilation and Plan Caching
- Recompilation Triggers
- Best Practices
- LAB: Maintaining Query Efficiency
2
QP208
Cursors, Temporary Tables and Table Variables
- SQL Server Cursor Types
- Sets vs Cursors
- Temporary Tables and Table Variables
- LAB: Cursors, Temporary Tables and Table Variables
3
AT301
Using Data Types Effectively
- Working with Numeric Types
- Working with Character Types and Collations
- Working with Date and Time Types
- Working with Other Types
- Converting Between Types
- LAB: Using Data Types Effectively
3
AT302
SQL Server Spatial Data
- Spatial Applications
- Spatial Data Types
- Spatial Indexing and Tuning
- 2012 Enhancements
- LAB: SQL Server Spatial Data
3
AT303
Joins and Set Operations
- Joins
- Join Strategies
- Set Operations
- LAB: Joins and Set Operations
3
AT304
Subqueries
- Nested and Correlated Subqueries
- Derived Tables
- Common Table Expressions
- LAB: Subqueries
4
AT305
Data Modification
- Inserting, Updating, Deleting Data
- Merging Data
- OUTPUT Clause
- SEQUENCES
- LAB: Data Modification
4
AT306
TOP, APPLY and Windowing Functions
- TOP
- Resultset Pagination
- CROSS APPLY and OUTER APPLY
- Windowing Functions
- LAB: TOP, APPLY and Windowing Functions
4
AT307
Ranking, Pivoting and Grouping Data
- Ranking Functions
- Pivoting and Unpivoting Data
- Grouping Sets
- LAB: Ranking, Pivoting and Grouping Data
4
AT308
Working with XML Data
- XML Basics
- Storing and Retrieving XML
- XQuery
- Combining XML and Relational Data
- LAB: Working with XML Data
5
AT309
Full Text Indexing
- Full Text Indexing Concepts
- Implementing Full Text Indexing
- Full Text Best Practices
- SQL Server 2012 Full Text Enhancements
- Filetable
- Statistical Semantic Search
- LAB: Full Text Indexing
5
AT310
Creating Database Code Objects
- Executing Dynamic SQL
- Views, Functions and Stored Procedures
- SQL Server 2012 Built-In Function Enhancements
- DML and DDL Triggers
- Table Type and Table-Valued Parameters
- Identifying Dependencies and Metadata
- LAB: Creating Database Code Objects
5
AT311
SQL CLR Integration
- SQL CLR Concepts
- Implementing SQL CLR
- Best practices for SQL CLR
- LAB: SQL CLR Integration
5
AT312
Exception Handling
- T-SQL and Errors
- Error Handling – pre 2005
- TRY/CATCH and SQL Server 2005+
- Error Handling - 2012
- Error Handling in SQLCLR Code
- Error Handling on Clients
- LAB: Exception Handling
Phone: 1300 SQL SQL (1300 775 775) l International +61 1300 775 775 l Fax: +61 3 8676-4913
Copyright 2013 by SQL Down Under | Terms Of Use | Privacy Statement | Client login