SQL Server 2005 Messaging and Querying Tools

This course is included in our On-demand training solution.


To implement Service Broker components and use full-text search in SQL Server 2005

Target Audience

Professionals typically pursuing a career as a Database Administrator, Database Developer or Business Intelligence Developer; individuals who do not work with SQL Server as a part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators among others


This is a high-level technical path and candidates for the exam, and hence learners should be expert in the following areas: Tools usage UI navigation Wizards usage Writing code in the appropriate language (Transact-SQL, CLR Language, other scripting languages, etc.) Code debugging or syntactic issue resolution Troubleshooting Accomplishing specific focused tasks through the use of code or UI navigation

Expected Duration

115 min.

Course Objectives

SQL Server 2005 Messaging and Querying Tools

  • create Service Broker components in a given scenario.
  • create a Service Broker service.
  • recognize the routing, networking, and security features provided by Security Broker.
  • identify the features of Full-Text Searches and recognize considerations for implementing them.
  • create and troubleshoot full-text queries in a given scenario.
  • use full-text search to query SQL Server 2005.