Working with Subqueries in Microsoft® SQL Server„¢ 2005 (4330)


In this course, you write subqueries and correlated subqueries by using Transact-SQL (T-SQL) in Microsoft SQL Server 2005. You determine the best option among subqueries, joins, and temporary tables to get your desired result. You refine subqueries by using the ANY, ALL, and SOME operators.

In addition, this course explains common table expressions (CTEs) to write recursive queries.

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.


  • Write basic subqueries.
  • Write correlated subqueries.
  • Compare subqueries with joins and temporary tables.
  • Use common table expressions in queries.


User Reviews

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

Course Info

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

Next Step

Enquire Now
Tell a Friend