HOME
 

Programming with Transact-SQL

Impartica IT Training
Course summary
2 days
650 GBP excl. VAT
Birmingham, Leeds, London, Manchester, Nottingham, Sheffield - Show all  
Professional Training

Course description

Transact-SQL (or T-SQL) is Microsoft’s proprietary extension to SQL. This Transact-SQL programming training course will introduce you to the programming features of the language, using Microsoft SQL Server. With prior knowledge of SQL assumed, this course looks at the procedural programming language capabilities of T-SQL, such as local variables, flow control constructs, error handling and built-in functions. You will learn how to write your own functions to be used in SQL Server just in the way you use built in functions such as UPPER and GETDATE. You will also learn to write procedures, allowing you to execute any number of commands in a single database call. You'll write triggers, which automatically fire in response to a predefined database event - for example allowing you to automatically archive changed or deleted records. You'll find out how to get information from the database, such as whether there is an existing open transaction. All in all your capacity to work with SQL Server will massively increase over just using plain old SQL

Suitability - Who should attend?

A working level of basic SQL (SELECT, INSERT, UPDATE and DELETE statements) is assumed. Delegates without this experience should consider the Introduction to SQL course.

Expenses

Price: £650 plus VAT

Customer Outreach Award 2019

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

About provider

Impartica IT Training: SQL, Linux, C#, Ruby on Rails, HTML and ASP.NET 3.5 Web Development training courses

Impartica IT Training: SQL, C#, HTML and ASP.NET Web Development training courses

Impartica IT Training are a specialist Professional IT training provider delivering sql, c#, html and asp.net courses, with quality material and leading instructors. Attending a course with Impartica IT Training will help you stay up to date with the very...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Programming with Transact-SQL.

  Contact the provider

  Get more information

  Register your interest

Country *

Contact info

Impartica IT Training

19 Shaftesbury Road
YO15 3PP Bridlington

 Show phone number


Reviews

Average rating 4

Based on 2 reviews.

Remko
Good course and course leader.
Gibbo
Very useful course, gave some good insight into T-SQL and its real world usage. The course materials are a good desk reference afterwards too, filled with examples and exercises to practice your skills.
Request information

Find out more about this Programming with Transact-SQL course - simply fill out your details:

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here