Advanced Querying Microsoft SQL Server with Transact-SQL Course

Course Duration: 2 Days

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

Virtual

From £ 795 +VAT

Course Duration: 2 Days

What's included
Course Material
View Dates and Book

Classroom

From £ 0 +VAT

Course Duration: 2 Days

What's included
Course Material
View Dates and Book

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

Enquire About This Course

If you are attending a classroom course, then this will be taken at our many training centres within the UK.
Our London location is Minories London EC3N 1BJ

E-learning is s training, learning, or education delivered online through a computer or any other digital device, where you can work through the course at your own pace.

Online Exams
The remote web proctor solution allows you to take your exams online, using a webcam, microphone and a stable internet connection. You can schedule your exam in advance, at a date and time of your choice. At the agreed time you will connect with a proctor who will invigilate your exam live. View More info here https://tinyurl.com/mr22kry9

A Pearson VUE exam voucher
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. View More info here https://tinyurl.com/2mhn5ust

Virtual classroom is like being in a classroom where students gather, except you will be in your home, office, or other place of your choice.

Pass Protect, offered by TSG Training, is a valuable option for those concerned about the possibility of not passing their exam on the first attempt. It acts like an insurance policy, allowing you to resit your exam at a significantly reduced rate. Pass Protect covers one resit per exam purchased, so you don’t have to worry about the cost of an additional attempt if you don’t pass initially.

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.