Transact-SQL Programming
- Recommended Duration:
- 3 Days
- Version
- SQL Server 2008 and SQL Server 2005.
- 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
- T-SQL, syntax and fundamentals
- Exercises
- There are nine machine exercises.