SQL Server as a Data Warehousing platform
Defining the business problem. Contrasting OLTP and OLAP environments. Overview of the Data Warehousing concepts and architectures. Exploring the SQL Server components and features as part of a Data Warehousing solution. SQL server Integration Services for Data Integration. Comparing the various Microsoft Business Intelligence tools for data-driven decision making and business analysis.