Description

Summary: In this course you administer and program SQL Server 2005 Analysis Services. In addition, you design and deploy a Unified Dimensional Model as well as work with data mining solutions.
This course is intended for architects, database developers, database administrators, and business intelligence developers, who are experienced in Microsoft SQL Server.
This course also helps prepare you for certification exam 70-445.

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

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

Description:
In this course you administer and program SQL Server 2005 Analysis Services. In addition, you design and deploy a Unified Dimensional Model as well as work with data mining solutions. This course is intended for architects, database developers, database administrators, and business intelligence developers, who are experienced in Microsoft SQL Server. This course also helps prepare you for certification exam 70-445.

Course Objectives

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

• Understand the core concepts of SQL Server Analysis Services (SSAS) and the new features in the SSAS architecture.
• Design and deploy a Unified Dimensional Model.
• Upgrade to and configure SSAS 2005.
• Understand the new MDX and programming features in SSAS 2005.
• Understand data mining concepts and the tools used to develop data mining models.

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