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
Keyword
Course #
State

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


Writing Queries Using Microsoft SQL Server 2005 Transact-SQL


Description: 

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
     
Prerequisite: 

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.

 
   
     
Duration: 
3 Days  
     
     

View Printer Friendly Page

 


To Inquire About Future Classes

Request a class date

if one is not scheduled.