MCTS Accelerated: SQL Server 2008, Business Intelligence

5 Day Course
Hands On
Official Microsoft Curriculum
Code QAMCTSQ08BI

Book Now - 1 Delivery Method Available:

Scheduled Online Onsite

Overview

This Accelerated certification programmes provide you with everything you need to gain certification in a shortest time. Including:

  • Full Microsoft Official Curriculum
  • All events delivered by QA’s expert MCT team
  • Extended delivery days – normally 8:30am – 6:00pm
  • Practice tests taken with full support from your instructor
  • Exam 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance taken on the final day of your course

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.

Modules

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

Prerequisites

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).

or call:408-759-5074

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections