Call us on  08000 199337 From overseas +44 (0)1344938011

Advanced Querying Microsoft SQL Server with Transact-SQL Course

Course Duration: 2 days

Book online today or if you need any assistance or help chosing the right course for you, please call our team on 08000 199337 and we will help point you in the right direction.


Course Duration: 2 days

From £795.00 +Vat
View dates and book

Enquire Now


Course Duration: 2 days

From £0.00 +Vat
View dates and book

Enquire Now

Course Overview

The Advanced Querying Microsoft SQL Server with Transact-SQL course is designed to give delegates practical experience in using more complex Transact-SQL techniques. This course covers Microsoft SQL Server up to version 2016.

Read More

The delegate will learn and acquire skills as follows:

  • Creating and using Views
  • Using table expressions
  • Enhanced Grouping and Pivoting Data
  • Using Windowing ranking, offset and ranking functions
  • Creating and using Stored Procedures
  • Controlling Program Flow
  • Using Dynamic SQL
  • Implementing Error Handling
  • Improving Query Performance

Who will the course benefit?

IT Professionals and non-technical ‘power users’ who are required to implement more complex Transact-SQL queries.

Read Less

Course dates

Start Date Exam Included Price (excl VAT) Qty  

Frequently asked questions

A Pearson VUE exam voucher enables you to book and sit your exam at your local Pearson VUE testing centre at a time and date convenient to you.  Pearson VUE centres are worldwide, and you will be able to choose the closest testing centre to you. You then go along to the test centre with your photo ID at the specified date and time and you will then take an electronic exam. Your exam voucher will have an expiration date and your exam must be sat before this date as these vouchers cannot be extended.

At TSG Training, we know that preparing for an exam can be a stressful endeavour. That’s why we offer a unique promise to our customers – if you don’t pass your software testing course exam the first time around, you can take one subsequent course at no cost! Exam re-takes are chargeable

Enquire Now

Wait! Before You Leave.

How can we help?

Would you like to know more? Click here to arrange a call back with one of our business development managers. They will be able to discuss the course with you and answer any questions you have.