Querying Microsoft SQL Server with Transact-SQL

Course Duration: 3 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.

Virtual

From £ 1193 +VAT

Course Duration: 3 days

What's included
Course Material
View Dates and Book

Classroom

From £ 0 +VAT

Course Duration: 3 days

What's included
Course Material
View Dates and Book

Course Overview

The Querying Microsoft SQL Server with Transact-SQL course covers the basics of the SQL language as implemented by Microsoft SQL Server. The course is designed to give delegates practical experience in writing Transact-SQL statements using the SQL Server Management Studio (SSMS) development environment. The basic Transact-SQL statements, including the use of many built-in Transact-SQL functions are covered on this course. This course covers Microsoft SQL Server up to version 2016.

The delegate will learn and acquire skills as follows:

  • Writing SELECT queries
  • Sorting and filtering data
  • Using SQL aggregate functions
  • Using SET operators
  • Writing joins to query multiple tables
  • Using built-in functions
  • Using Subqueries
  • Inserting, updating, deleting and merging rows
  • Transaction control

Who will the course benefit?

Anyone who needs to access and work with a Microsoft SQL Server Database.

Enquire About This Course

Start Date Location Exam Included Duration Price (excl VAT) Qty  
View All
Start Date Location Exam Included Duration Price (excl VAT) Qty  
View All

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

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.

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

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.

Enquire Now

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