Training

860 | Transact SQL (T-SQL) for SQL Server 2005 for Developers

3 days (1.8 CEUs)
Delivery: Open Enrollment | Customized Onsite | Virtual Classroom
Price: $1,755 or 3 Vouchers

In this course, you'll learn how to build queries using Transact-SQL and how to build views, stored procedures, triggers, and user-defined functions. You'll learn about enhancements to the T-SQL programming language including error handling and hierarchical queries, and you will learn how you can use .NET languages like C# and VB.NET to build database objects.

By the end of the class students will be able to:

• Write and tune sophisticated T-SQL queries
• Work with SQL Server Management Studio
• Use T-SQL’s programming features such as functions and control flow
• Implement transactions and error-handling
• Build stored procedures and triggers
• Embed .NET code in their databases using SQLCLR
• Use advanced query techniques such as recursive queries, pivot queries, and full text search

• Prerequisites:
  800 Westlake Capstone: Fundamentals of Relational Databases, or equivalent industry experience working with databases. Experience with the .NET framework a plus.

• Follow-Ups:
  600 WestLake Capstone: .NET Web Developer
  691 Windows Communication Foundation