Send to a Friend
 
Content to send

Transact-SQL Programming

Course Number: 714-JK
Recommended Duration: 3 days

Intended Audience: Application developers and designers who will use create Stored Procedures and triggers using T-SQL in their applications.

Course Overview

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. Course is for SQL Server 2008 and SQL Server 2005.

Prerequisites

Prior knowledge of SQL Server fundamentals and basic SQL is necessary. No previous experience with T-SQL or Stored Procedures is required.

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

Share with others

Please provide the following information
Your Name
Your Email Address
Recipient Emails
Message

Can't Read? Click to Generate New Code
Enter the verification code shown above into the text box below