Microsoft SQL Server 7.0: Data Warehousing

Overview/Description
To introduce the student to Microsoft's concept of data warehousing; describe the architecture and features of SQL Server 7.0 Data Warehouses and Data Mart implementation; and to teach the student how to use Microsoft's OLAP server, code-named 'Plato'

Target Audience
Information technology professionals who are early adopters of SQL Server 7.0, including database administrators, application developers, independent software vendors, system integrators, and Internet consultants

Prerequisites
Prior working knowledge of Microsoft SQL Server 6.5

Expected Duration
5:00 Hours

Objectives:

Microsoft SQL Server 7.0: Data Warehousing

  • To outline Microsoft's data warehousing strategy, products, and services
  • To show how to design and process a data cube and how to use it to browse and filter information
  • To describe how to partition and modify a cube and create a virtual cube
  • To describe Microsoft SQL Server Data Transformation Services.
  • To outline the tools and services used to access OLAP data


    • Course Number: SQ7004E