Transact SQL Programming (TSQL)

This course is aimed at SQL Server database developers, administrators and analysts who need a little bit more than SQL can do alone. SQL Server provides a powerful scripting language called Transact SQL, which enables developers to extend the capabilities of the SQL language. Using Transact SQL (TSQL) powerful scripts, stored procedures, functions and triggers can be produced to enable extracted information to be processed further, or to enable complex transformations of data prior to, during or after an insert, update or delete, or to implement automated updates and audit trails. Covers SQL Server 2005 through to SQL Server 2016.

Transact SQL Scripting

Error Handling

Transaction Logging

Locking

Implementing Cursors

Stored Procedures

User-Defined Functions

Triggers

Dates

London Greenwich

Monday 23 to Wednesday 25 October 2017

£1195

Book Now


Collections

Programming courses

Sql courses

Database courses