Course not currently available

Business Intelligence in MS SQL Server 2008 Training Course

Nobleprog Limited

Course

Online

£ 1,850 VAT inc.

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

Training is dedicated to the basics of create a data warehouse environment based on MS SQL Server 2008.
Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008.
Gain knowledge of how to build a simple ETL process based on the SSIS and then design and implement a data cube using SSAS.
The participant will be able to manage OLAP database: create and delete database OLAP Processing a partition changes on-line.
The participant will acquire knowledge of scripting XML / A and MDX.

About this course

Knowledge of Windows, basic knowledge of SQL and relational databases.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • XML training
  • XML
  • Server
  • Database
  • SQL
  • Database training
  • Design
  • Construction
  • Project
  • Business Intelligence

Course programme

  • basis, objectives and application of data warehouse, data warehouse server types
  • base building ETL processes in SSIS
  • basic design data cubes in an Analysis Services: measure group measure
  • dimensions, hierarchies, attributes,
  • development of the project data cubes: measures calculated, partitions, perspectives, translations, actions, KPIs,
  • Build and deploy, processing a partition
  • the base XML / A: Partitioning, processes and overall Incremental, delete partitions, processes of aggregation,
  • base MDX language

Additional information

14 hours (usually 2 days including breaks)

See related categories

Business Intelligence in MS SQL Server 2008 Training Course

£ 1,850 VAT inc.

The best SQL Server courses

See all

See all