Home About Courses Schedule Services Webinars Contact Search

Transact-SQL Programming


Duration: 3.0 days

Method: Instructor led with hands-on.

Price: $1920.00

Course Code: SS1020


SQL Server Developers looking to extend the functionality of the database.


Transact-SQL allows you to use the SQL language to write procedural scripts for use with your databases. This language is used to write Stored Procedures, User-defined Functions and Triggers. This course will get you ready to do all of the above.


Upon successful completion of this course, the student will be able to:

  • Work with SQL Server Management Studio
  • Code and test scripts
  • Implement Stored Procedures
  • Implement User-defined Functions
  • Write Triggers


A working knowledge of SQL.


  • I. Working with SQL Server Management Studio
    • Connecting to SQL Server
    • Navigating Databases
    • Writing SQL in Management Studio
  • II. Coding Scripts
    • Transact-SQL statements for script processing
    • Scalar variables
    • Table variables
    • Temporary tables
    • Comparison of types of Transact-SQL table objects
    • Debugging Scripts
  • III. Controlling the Execution of Scripts
    • Conditional processing
    • Testing for the existence of database objects
    • Repetitive processing
    • Using cursors
    • Handling errors
  • IV. Advanced Scripting Techniques
    • Using system functions
    • Changing session settings
    • Using dynamic SQL
  • V. Stored Procedures
    • Creating a stored procedure
    • Declaring and working with parameters
    • Calling a stored procedure with parameters
    • Returning data from a stored procedure
    • Validation and raising errors
    • Passing a table as a parameter
    • System supplied stored procedures
  • VI. User-defined Functions (UDFs)
    • Creating a UDF
    • Scalar UDFs
    • Table-valued Functions
  • VII. Triggers
    • Creating and using an AFTER Trigger
    • Creating and using INSTEAD OF Triggers
    • Enforcing business rules with Triggers
  • VIII. Transactions and Locking
    • Working with transactions
      • COMMIT
      • ROLLBACK
    • Concurrency and locking