Course 3175: Selecting Microsoft SQL Server 2005 Services to Support Business Needs

Introduction In this 2 hour course you will learn how to select the right SQL Server service for a particular business requirement. You will also learn how to evaluate the considerations for using database enhancements in SQL Server 2005. This knowledge will allow you to choose the best mix of server solutions and the associated coding strategies.

This course will also help prepare you for certification exam 70-441.

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

• Evaluate when to use the new SQL Server 2005 services
• Evaluate when to use the database engine enhancements

Modules & Lessons Course Overview Module Introduction Navigation Overview Designing a Server-Side Solution for SQL Server 2005 Selecting SQL Server 2005 Services to Support Business Needs Module Introduction Evaluating When to Use the New SQL Server Services Lesson Introduction The Architecture of SQL Server 2005 The Full-Text Search Service Considerations for Using HTTP Endpoints Considerations for Using Notification Services Considerations for Using Service Broker Considerations for Using Reporting Services Self Test Evaluating When to Use the Database Engine Enhancements Lesson Introduction Transact-SQL Enhancements Considerations for Using Embedded CLR Considerations for Using SQLXML Self Test Lab: Selecting SQL Server Services That Support Business Needs Lesson Introduction Scenario Exercise: Selecting Services to Meet Business Requirements Exercise: Selecting Services to Meet Line of Business Requirements Proposed SQL Server Services Solution Lab Review Module Summary Glossary Module Introduction System 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
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• 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)

Test your computer's capabilities to see if it supports this course. 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