MCTS Accelerated: SQL Server 2008, Business Intelligence

5 Day Course
Hands On
Official Microsoft Curriculum

This course has been retired. Please view currently available Microsoft Windows 2008 Training Courses.


Course Topics (26 topics)

  • Microsoft SQL Server Analysis Services
  • Creating Multidimensional Analysis Solutions
  • Working with Cubes and Dimensions
  • Working with Measures and Measure Groups
  • Querying Multidimensional Analysis Solutions
  • Customizing Cube Functionality
  • Maintaining a Multidimensional Solution
  • Introduction to Data Mining
  • Introduction to SQL Server 2008 Integration Services
  • Developing Integration Services Solutions
  • Implementing Control Flow
  • Implementing Data Flow
  • Implementing Logging
  • Debugging and Error Handling
  • Implementing Checkpoints and Transactions
  • Configuring and Deploying Packages
  • Managing and Securing Packages
  • Introduction to Microsoft SQL Server Reporting Services
  • Authoring Basic Reports
  • Enhancing Basic Reports
  • Manipulating Data Sets
  • Using Report Models
  • Publishing and Executing Reports
  • Using Subscriptions to Distribute Reports
  • Administering Reporting Services
  • Programming Reporting Services


This course is intended for individuals who design and maintain business intelligence solutions for their organization. They should have experience in: * Conceptual understanding of OLAP solutions. * Experience navigating the Microsoft Windows Server environment. * Experience with Windows services (starting and stopping). * Experience creating service accounts and permissions. * Experience with Microsoft SQL Server, including: SQL Server Agent, SQL Server query language (SELECT, UPDATE, INSERT, and DELETE), SQL Server System tables and SQL Server accounts (users and permissions).

Course PDF