Designing Asynchronous, Queued Operations Using SQL Server„˘ 2005 Service Broker(3180)


In this 2-hour premium course, you will learn how to incorporate Service Broker into your SQL Server™ 2005 Database solutions. Topics range from discussing Service Broker architecture to data flow and availability. In the lab, you will use these skills to build a SQL Server 2005 Service Broker solution.

Having this experience will enable you to design databases that utilize the integrated messaging system to perform asynchronous processing.

This course will also prepare you for exam 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 and 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005.



  • Identify Components of a Service Broker Solution
  • Design a Service Broker Solution Architecture
    • Implement a Service Broker Solution
    • Identify Services and Conversations
  • Design Service Broker Data Flow
    • Identify Conversation Groups
    • Identify Data-Staging Locations
    • Identify Service Routes
    • Identify Service Activation Methods
  • Design for Service Broker Solution Availability
    • Implement Service Broker Fault Tolerance
    • Implement Service Broker Backup Strategy


User Reviews

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

Course Info

  • Code: EL-DAQO-205SB
  • Duration: 2 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend