Microsoft Certified Technology Specialist (MCTS): SQL Server 2005 Business Intelligence

Overview

The Microsoft Certified Technology Specialist (MCTS): SQL Server 2005 Business Intelligence credential provides you with the knowledge and skills required to implement and maintain business intelligence solutions using the Microsoft SQL Server 2005 Business Intelligence Development tool suite. This course will provide you with the know-how to debug, monitor and troubleshoot Business Intelligence solutions, and work with the Microsoft .NET Framework. You will learn to use SQL Server Analysis Services (SSAS) data mining algorithms, and create and deploy SQL Server Reporting Services (SSRS) reports and SQL Server Integration Services (SSIS) packages.

To help prepare for the exams, we provide you with all the required resources including the online self-paced courses, access to an Exam Coach to help plan your study and answer course related questions, access to live servers to practice your skills, and an online reference library of eBooks (including Microsoft Press and SAMS books) and how-to articles.

Click here for a free consultation

Our Quality Guarantee

Our courses are of the highest quality – In fact we partnered with Microsoft to develop them. Not only are they Microsoft authorised, Microsoft uses them in their own internal training – the ultimate seal of approval!

Who is this course aimed at?

  • Database Administrator
  • Database Developer
  • Business Intelligence Developer
  • Enterprise Developer

What’s included?

  • Online self-paced courses,
  • vLab virtual labs
  • Exam Coach and Mentoring
  • Online Reference Library
  • Discussion Forum
Study Time Approximately 18 hrs Duration 12 months
Pre-requisites none
Requirements Click here for a list of technical requirements

Required Exams

70-445 TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance

Course Outline:

  • Exploring SSAS Core Concepts and Architecture
  • Designing and Deploying a Unified Dimensional Model
  • Administering SSAS
  • Programming in SSAS 2005
  • Working with Data Mining Solutions in SSAS
  • Exploring SSIS Architecture and Core Concepts
  • Designing and Debugging SSIS Packages
  • Rich Functionality in SSIS
  • Programming SSIS Tasks and Packages
  • Beyond ETL
  • Exploring the Features and Core Concepts of SSRS
  • Designing Reports Using Report Designer
  • Deploying and Managing Reports
  • Working with Ad Hoc Reports