Program with Transact-SQL

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Module 1: Get started with Transact-SQL programming

After completing this module, you will be able to:

Describe the language elements of T-SQL used for simple programming tasks.
Describe batches and how they're handled by SQL Server.
Declare and assign variables and synonyms.
Use IF and WHILE blocks to control program flow.

Module 2: Create stored procedures and table-valued functions

After completing this module, you will be able to:

Return results by executing stored procedures.
Pass parameters to procedures.
Create simple stored procedures that encapsulate a SELECT statement.
Construct and execute dynamic SQL with EXEC and sp_executesql.
Create simple inline table-valued functions and write queries against them.

Module 3: Implement error handling with Transact-SQL

After completing this module, you will be able to:

Raise errors using the RAISERROR statement.
Raise errors using the THROW statement.
Use the @@ERROR system variable.
Create custom errors.
Create alerts that fire when errors occur.

Module 4: Implement transactions with Transact-SQL

After completing this module, you will be able to:

Describe transactions.
Compare transactions and batches.
Create and manage transactions.
Handle errors in transactions.
Describe concurrency.