Joining Data from Multiple Tables in Microsoft® SQL Server„¢ 2005 (4329)


Description:

In this course, you retrieve data from multiple tables by using Transact-SQL (T-SQL) in Microsoft SQL Server 2005. You apply the inner join, outer join, cross join, and self join to retrieve the desired result set. You also use the APPLY operator to join using a user-defined function.

In addition, you examine the various techniques provided by SQL Server 2005 to combine and limit result sets such as UNION, EXCEPT, INTERCEPT, TOP, and TABLESAMPLE.

This course also helps prepare you for certification exam 70-431.

ATTENTION: Depending on your subscription, the Virtual Labs (vLabs) for this course may not be available. If the Virtual Labs do not launch when you click the launch button, contact your company Training Administrator for more information about your subscription.

 

Objectives:

  • Query multiple tables by using joins.
  • Apply joins for typical reporting needs.
  • Combine and limit result sets.

 




User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: EL-JDFMS2005
  • Duration: 2 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend