Using Programming Objects for Data Retrieval in Microsoft® SQL Server„¢ 2005 (4333)


Description:

In this course, you retrieve data by using the various programming objects provided by Microsoft SQL Server 2005. You encapsulate expressions with user-defined functions and SQL Server views. You also utilize stored procedures, and triggers to encapsulate T-SQL logic.

In addition, you perform distributed queries and learn how SQL Server works with heterogeneous data such as databases, spreadsheets, and other servers.

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:

  • Encapsulate expressions by using user-defined functions.
  • Encapsulate queries by using views.
  • Explain how stored procedures encapsulate T-SQL logic.
  • Write distributed queries.

 




User Reviews

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

Course Info

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

Next Step

Enquire Now
Tell a Friend