On this Advanced TSQL Training Course learn the more advanced constructs of TSQL and how to use them in the right way. We cover all of the new Transact-SQL features up to the version you choose to study in. Learning all about tables and indexes will let you know how to fix poorly performing SQL Server queries.

Learning Outcomes

Logical query processing, table b-trees, indexes, access methods.  How queries work and how to use the right construct at the right time.

Course Requirements

Intermediate or Advanced Developers wanting to delve deeper into TSQL

Course Length

3-days

• Logical Query Processing
• SQL Server Database Internals
• Storage & B-Trees
• Heaps, Indexes Clustered and Non-clustered
• Covering Indexes
• Index Access Methods

• Joins
• Natural
• Equi-joins and Non-equi joins
• Nested, Merge and Hash Joins

• Data Types
• Normal Form
• Temporary Tables
• Table Variables
• While vs Cursors
• For Performance

• Derived Tables
• CTEs and Views
• In-line Table-Valued Functions
• The APPLY Operator
• Date and Time anomalies

• Dynamic SQL vs Stored Procs
• EXEC
• sp_executesql
• UDFs
• Multistatement Table-Valued UDFs

• Stored Procedures
• Triggers
• Error Handling

• Transactions
• Isolation Levels
• Locking and Blocking
• Deadlocking
• Handling deadlocks
• Timeouts

• The Query Optimizer
• How the optimiser decides and indexes
• Execution Plans
• Graphical Execution Plans

Course Price

This course costs £1,425 excluding VAT

How to Book

Call us or email us on the form below, any questions, ask us!