Chapter 2 -- Applications of Data Warehousing
Chapter 2
About This Chapter
In the previous chapter, the key focus was on the basic concepts and especially the benefits of data warehousing. This chapter discusses different aspects of data warehousing in greater detail, examines the life cycle flow of information from other systems into the data warehouse, and evaluates how data warehousing supports the objective of various sample business scenarios.
Before You Begin
To complete the lessons in this chapter, you must
- Have installed SQL Server 7
- Have installed OLAP Services for SQL Server 7
- Have installed the OLAP Services sample Foodmart database
Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit
ISBN: 0735606706
EAN: 2147483647
EAN: 2147483647
Year: 1999
Pages: 114
Pages: 114
- Using SQL Data Manipulation Language (DML) to Insert and Manipulate Data Within SQL Tables
- Working with Queries, Expressions, and Aggregate Functions
- Using Keys and Constraints to Maintain Database Integrity
- Performing Multiple-table Queries and Creating SQL Data Views
- Exploiting MS-SQL Server Built-in Stored Procedures