SQL Server Transact SQL Programming

TSQL Programming Training

This course is aimed at SQL database developers, administrators and analysts who need a little bit more than SQL can do alone.

Microsoft SQL provides a powerful scripting language called Transact SQL, which enables developers to extend the capabilities of the SQL language.

You will learn:

• Basic syntax for TSQL scripts

• Use of advanced TSQL functions to manipulate stored data

• Writing Stored Procedures for complex data transformations

• Creating user defined functions to simplify transformation logic

• Creating Triggers for automated actions and audit trails

• Handling Locking Issues

• Implementing Error Handling.

Covers all versions of Microsoft SQL up to and including SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, Azure SQL Database, Azure SQL Data Warehouse, Azure Synapse, Fabric.

This course can be offered in a face to face classroom and virtual setting.

Delegates should have SQL Server SQL language experience to the level of the PTR Advanced Querying of SQL Server Databases.