Wronski Associates
Twitter
LinkedIn
Login
Contact Us
Company
Leadership Development
Training Solutions
Consulting Services
In The Spotlight
Close
Company
Leadership Development
Training Solutions
Consulting Services
In The Spotlight
Login
Contact Us
Twitter
LinkedIn
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