+44 7459 302492
support@uplatz.com
Job Meter = High
Programming with Transact-SQL
30 Hours
Online Instructor-led Training
GBP 2000
About this Course
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
--------------------------------------------------
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.
--------------------------------------------------
--------------------------------------------------
Suitability - Who should attend?
Programming with Transact-SQL
Course Details & Curriculum
--------------------------------------------------
