Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services
Course Code: MS2092
Duration: 5 Days
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
