Developing Applications that Use SQL Server Support Services


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
recognize how to develop and deploy SQL Service Support solutions with Notification Services and Service Broker

Target Audience
Developers who use Microsoft Office SQL Server 2005 and consultants providing consulting services for SQL Server 2005; individuals looking to pass the 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 certification exam and those individuals targeting toward the Microsoft certification: Microsoft Certified IT Professional (MCITP): Database Developer certification path.

Prerequisites
Three or more years database programming experience including expertise in troubleshooting triggers, queries, stored procedures, user-defined functions, and user-defined types, writing Transact-SQL queries, performing database performance optimization, designing and troubleshooting the data access layer of the application, designing databases, iImplementing databases at the physical level, and gathering business requirements.

Expected Duration (hours)
2.2

Lesson Objectives

Developing Applications that Use SQL Server Support Services

  • recognize the features of Notification Services platform that are used to create notifications for subscribers or applications.
  • recognize how to configure Notification Services Applications database, event, subscription, and notification classes.
  • recognize how to optimally configure Notification Services applications to provide events, and generate and distribute notifications.
  • recognize how to configure Notification Services instances and deploy Notification Services instances to build Notification Services applications.
  • recognize the various features and objects of Service Broker.
  • recognize how to create a Service Broker application.
  • determine how to design and optimize a Notification Services solution and implement Service Broker solutions for applications.
  • Course Number:
    256270_eng