Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More .NET

Transact-SQL Programming

Recommended Duration:
3 Days
Benefits
Participants will learn to use Transact-SQL (T-SQL) to enhance SQL Server applications. Several exercises take students from the basics of T-SQL through advanced features enabling improved programming and enhanced performance.
Audience
Application developers and designers who will use create Stored Procedures and triggers using T-SQL in their applications.
Prerequisites
Prior knowledge of SQL Server fundamentals and basic SQL is necessary. No previous experience with T-SQL or Stored Procedures is required.
Major Topics
  • T-SQL, syntax and fundamentals
  • SQL Server variables and parameters
  • Global Variables
  • Built-in functions
  • Arithmetic, Looping, and Conditional
  • Logic
  • Error handling (Try-Catch)
  • Using cursors
  • Temporary Tables
  • Using Table variables
  • Implicit and Explicit Cursors
  • Stored Procedures
  • Dynamic queries
  • Executing remote procedures
  • User-Defined Functions
  • Dependencies
  • Triggers
  • RETURN
  • New features of T-SQL
  • Security
  • Performance and T-SQL
  • Transactions and Locking
  • Snapshot Isolation
  • Using Hints
Exercises
There are nine machine exercises.