Working with Subqueries Using Microsoft SQL Server 2008 (4330)


In this 2 hour course students are introduced to subqueries. Usingcommon table expressions in queries to generate hierarchical resultsets is also explored.

Topics covered in the courses within the course Include:

  • How to write basic sub queries.
  • How to write correlated sub queries.
  • Compare subqueries with joins and temporary tables.
  • Describe common table expressions

This course also helps prepare you for exam: 70-432: Microsoft SQLServer 2008, Implementation and Maintenance and 70-433: Microsoft SQLServer 2008, Database Development.

This course has the same content as the previous version in an updatedviewer with a new look and feel.


  • 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-WSUMS2008
  • Duration: 2 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend