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 all versions of SQL Server 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.. This course will help you to prepare for Microsoft 70-761 exam: Querying Data with Transact-SQL and the Microsoft 70-762 exam: Developing SQL Databases, which credits towards MCSA and MCSE certifications. This course can be offered in a face to face classroom and virtual setting.