KT-2778-05 Writing Queries Using Microsoft SQL Server 2005 Transact-SQL Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University


Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training



 Course Search
Course #

 Training Delivery
Training Delivery
Custom Curriculum
Course List
 Main Menu
View Courses
Site Index

Writing Queries Using Microsoft SQL Server 2005 Transact-SQL


2778.  In this course, you will learn how to build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL. You'll learn about the new enhancements to the Transact-SQL programming language including improved support for error handling and hierarchical queries, and programmers can now use .NET languages like C# and Visual Basic to build database objects.

In this course, you will

  • Understand basic database design principles and how to implement them in SQL Server.
  • Learn the fundamentals of writing Transact-SQL queries that retrieve or modify data.
  • Understand the differences between view, stored procedures, triggers, and user-defined functions.
  • Use the new Common Table Expressions for creating hierarchical queries.
  • Perform calculations with Visual Basic and Visual C# code rather than T-SQL.

Click here to view the Course Outline

This course is designed for database developers and SQL Server administrators who need to understand Transact-SQL. To get the most out of this course, you should have a solid understanding of relational databases. No particular programming experience is required, but the course is taught from a developer's perspective.

3 Days  

View Printer Friendly Page


To Inquire About Future Classes

Request a class date

if one is not scheduled.