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

Transact SQL Programming

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