Managing SQL Server 2008 Analysis Services Solutions


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


Overview/Description
SQL Server 2008 Analysis Services provides a powerful solution for analyzing extremely large amounts of data in a relational database. This course looks at Analysis Services from a management perspective. It outlines the considerations involved with deploying SSAS projects. This includes project deployments using various methods and synchronization. The course also covers analysis services security solutions related to securing an instance and securing user access. A discussion about disaster recovery, including high-availability solutions and backup solutions is also included in this course. In addition, the course looks at administration, including the tools that can be used to maintain analysis services, how you can process SSAS objects, and how you can use SQL Server Profiler to monitor analysis services.This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.

Target Audience
IT professionals working to develop and maintain Microsoft SQL Server 2008 business intelligence solutions or those pursuing a career as a database administrator or developer

Prerequisites
Familiarity with Microsoft .NET Framework; experience with SQL Server 2005 or SQL Server 2008 business intelligence components; experience performing queries on relational databases and using SQL Server Management Studio and Business Intelligence Development Studio

Expected Duration (hours)
2.0

Lesson Objectives

Managing SQL Server 2008 Analysis Services Solutions

  • recognize methods for deploying a SQL Server Analysis Services project
  • recognize how to implement security in SQL Server 2008 Analysis Services
  • identify disaster recovery solutions for SSAS
  • recognize how to back up and restore an SSAS database
  • detach and attach an SSAS database
  • manage SQL Server 2008 Analysis Services
  • recognize how to monitor an SSAS instance
  • administer SQL Server 2008 Analysis Services
  • Course Number:
    md_mqbm_a09_it_enus