Using Advanced Querying Techniques in Microsoft® SQL Server„¢ 2005 (4334)


In this course, you apply advanced querying techniques in Microsoft SQL Server 2005. You follow best practices to query complex data involving data/time and multinational data. You query complex table structures such as data stored in hierarchies and self-referencing tables. You also analyze query execution and optimize query performance.

In addition, you use Microsoft Visual SourceSafe for managing query source files.

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.


  • Explain the recommendations for querying complex data.
  • Query complex table structures.
  • Write efficient queries.
  • Use various techniques when working with complex queries.
  • Maintain query files.


User Reviews

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

Course Info

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

Next Step

Enquire Now
Tell a Friend