Home > SQL Server > Data Warehouse Development for SQL Server 2005/2008

Data Warehouse Development for SQL Server 2005/2008

Course Code:	SQSDWD
Duration:	3 days
Level:	Intermediate
Audience:	Data warehouse analysts, ETL specialists, data warehouse administrators.
Prerequisites:	Completion of our course Data Warehousing Terms, Concepts & Architecture and and 6 months experience of Microsoft SQL Server 2005 or equivalent knowledge.
Features:	Data warehouse/data mart and multidimensional cube development using realistic scenarios.
Summary:	Designed to emphasise SQL Server features specific to business intelligence (BI) and data warehousing (DW), this scenario and hands-on presentation details the following: Data mart design and load Business Intelligence Development Studio (BIDS) SQL Server Management Studio Building dimension tables Building fact tables Developing dimensions Hierarchies ETL via SQL Server 2005/2008 Integration Services (SSIS) Security SQL Server 2005/2008 Analysis Services (SSAS) SQL Server 2005/2008 Reporting Services (SSRS) Performance and good practices
Objectives:	Upon completion of this course, the delegate should understand how to deal with BI/DW design issues as they relate to SQL Server 2005/2008.
Format:	Lecture and hands-on (about 60%).
Detailed Outline

Course Schedule