Database Design & Development

ScheduleRegister for this courseOutline860 | 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