|
|
|
|
MCTS: SQL Server 2008, Business Intelligence Development and Maintenance |
Click Here to register
|
|
Description: |
|
This track is about creating Business Intelligence (BI) solutions by using
Microsoft SQL Server 2008. Candidates typically work with the full suite of BI
technologies in SQL Server 2008, including Reporting Services, Analysis
Services, and Integration Services. |
|
General Objectives: |
|
During this track the students will learn how to extract, transfer and transform
data using Microsoft SQL Server 2008 Integration Services. The track also
discusses how to create an Analysis Services Database, OLAP cube, and how to use
the Reporting Services Management and Administrative tools to manage a Reporting
Services solution. |
|
|
|
Skills Earned: |
- How to use Microsoft SQL Server 2008 Management Studio.
- How to retrieve and filter data.
- How to group and summarize data by using Transact-SQL.
- How to display data from multiple table.
- How to modify data in tables.
- Learn the structure of the SQL Serve reporting service.
- How to create reports.
- How to publish and distribute reports.
- Learn the structure of the SQL Server integration service.
- How to develop integration services solutions.
- How to deploy integration services packages to production servers.
- How to secure integration services packages.
- How to create multidimensional analysis solutons.
- How to implement dimensions and cubes in an analysis services solution.
- How to deploy and secure an analysis services database.
|