MCTS Accelerated: SQL Server 2008, Business Intelligence

Level
Total time

Description

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

Course Description:

This Accelerated certification programmes provide you with everything you need to…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet.  

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

Course Description:

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

This course includes the following modules:

Course 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

For online live training advice please visit our Learning Advice Centre on our website. Be sure to follow us on Twitter to receive special course offers, news and updates!

There are no reviews yet. Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet.  

Download a free information brochure

Gender
(optional)
(optional)
(optional)
(optional)
(optional)

Do you have any questions?