Programming Microsoft SQL Server with Transact-SQL

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.


From £ 795 +VAT

Course Duration: 2 days

What's included
Course Material
View Dates and Book


From £ 0 +VAT

Course Duration: 2 days

What's included
Course Material
View Dates and Book

About the Course

Course Duration: 2 days

Price From: £795

Private Course: Click Here
The Programming Microsoft SQL Server with Transact-SQL SQL training course introduces the delegate to the programming features of the Transact-SQL programming language, using Microsoft SQL Server. This course looks at the procedural programming language capabilities of T-SQL. The delegate will learn how to use local variables, write program flow control constructs, create stored procedures and triggers, handle errors and use built-in functions.

The delegate will learn and acquire skills as follows:

  • Declaring and using variables
  • Using conditional programming logic
  • Implementing conditional execution and loop constructs
  • Using cursors to process records
  • Trapping and handling errors and exceptions in code
  • Creating stored procedures
  • Creating user defined functions
  • Creating triggers
  • Using dynamic SQL

Who will the course benefit?

Software development personnel and database support staff who need to write Transact-SQL scripts to enhance their productivity in manipulating data.

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

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

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.

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.