• Back to Microsoft Courses

Overview

This course provides delegates with the knowledge and skills necessary to design a data warehouse and to populate data marts by using Data Transformation Services (DTS) in Microsoft SQL Server 2000.

Prerequisites

Delegates must be familiar with Microsoft SQL Server version 7.0 or Microsoft SQL Server 2000, and have taken course 832, System Administration for Microsoft SQL Server 7.0, and course 833, Implementing a Database on Microsoft SQL Server 7.0, or the equivalent Microsoft SQL Server 2000 courses. Delegates should also have knowledge of Transact-SQL usage in the development of OnLine Transaction Processing (OLTP) systems plus a basic understanding of programming principles and basic database design, administration, and implementation concepts.

Delegates will learn how to

• Understand data warehousing concepts and applications
• Build relational data marts by using star schemas
• Develop a data warehouse data load strategy
• Use the DTS import/export Wizard
• Understand DTS package components
• Use DTS to copy and manage data
• Implement a data driven query solution
• Understand the basics of the DTS object model
• Modify DTS package properties

Outline

Module 1: Using DTS in a Data Warehouse

Module 2: Defining Data Warehouse Structures

Module 3: Populating Data Warehouse Structures

Module 4: Using the DTS Import/Export Wizard

Module 5: Understanding DTS Package Elements

Module 6: Copying and Managing Data

Module 7: Performing Data Transformations

Module 8: Extending Transformations

Module 9: Implementing Data Driven Query Solutions

Module 10: Storing DTS Packages and Metadata

Module 11: Executing Packages

Module 12: Managing Package Properties

Module 13: Building Advanced Workflows

Module 14: Applying Best Practices

Module 15: Case Study – Populating the Shipments Star

• Back to Top
• Back to Microsoft Courses