Description

Summary: This course will provide you with a technically deep learning experience on installing and securing Microsoft® SQL Server^TM 2005. The course provides detailed reference content and in-depth practical and hands-on activities for database developers with Microsoft® SQL Server^TM 2005.

Audience: IT Pro
Available Offline: Yes
Subscription: 12 months

Course Type: Self-paced Course
Estimated Time of Completion: 6 Hours
Language: English

Description:
This course will enable database developers experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. The course is broken into three modules:

• Using Service Broker
• Using Native HTTP Support
• Using Notification Services

Course Objectives

At the end of the course, students will be able to:

• Describe the Service Broker architecture.
• Use Service Broker for message-based communication.
• Describe the native HTTP support features in SQL Server 2005.
• Implement a Web service using native HTTP endpoints.
• Describe the architecture of a Notification Services solution.
• Design and implement a simple Notification Services solution.

Technical Requirements

To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Macromedia Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.
For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:
• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Accessibility Requirements

The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled