TSQL for Developers Intermediate/Advanced Training Course

TSQL for Developers Intermediate/Advanced Training Course

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

T-SQL for Developers Intermediate/Advanced Training Course Agenda

Query Deconstruction Introduction
  • Logical Query Processing
  • SQL Server Database Internals
  • Storage & B-Trees
  • Heaps, Indexes Clustered and Non-clustered
  • Covering Indexes
  • Index Access Methods
Join Us
  • Joins
  • Natural
  • Equi-joins and Non-equi joins
  • Nested, Merge and Hash Joins
Data and Tables
  • Data Types
  • Normal Form
  • Temporary Tables
  • Table Variables
  • While vs Cursors
  • For Performance
Table Expressions
  • Derived Tables
  • CTEs and Views
  • In-line Table-Valued Functions
  • The APPLY Operator
  • Date and Time anomalies
Execution
  • Dynamic SQL vs Stored Procs
  • EXEC
  • sp_executesql
  • UDFs
  • Multistatement Table-Valued UDFs
The Database Objects!
  • Stored Procedures
  • Triggers
  • Error Handling
Blockchain is old news
  • Transactions
  • Isolation Levels
  • Locking and Blocking
  • Deadlocking
  • Handling deadlocks
  • Timeouts
The Query Optimizer
  • 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!

You Might Also Like…

New Features of SQL Course
Beginners SQL DBA Course
Advanced SQL DBA Course
Performance Tuning Course
SSIS Training Course
SSRS Training Course
Power BI Training Course

 

Summary
TSQL for Developers Intermediate/Advanced Training Course
Service Type
TSQL for Developers Intermediate/Advanced Training Course
Provider Name
Sequallity Ltd,
80-83 Long Lane,London,EC1A 9ET,
Telephone No.020 3507 1989
Area
UK
Description
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.