Back to Search Results

Training Course Summary:

This course provides students 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.

Pre-Requisites:

Before attending this course, students must have:

Familiarity with Microsoft SQL Server version 7.0 or Microsoft SQL Server 2000.
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.
Knowledge of Transact-SQL usage in the development of online transaction processing (OLTP) systems.
Basic understanding of programming principles (especially experience with a scripting language such as Microsoft Visual Basic® Scripting Edition development software).
Understanding of basic database design, administration, and implementation concepts.

Training Course Overview/Content:

At the end of the course, students will be able 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.
Design insert based transformation by using the Transform Data Task.
Implement a Data Driven Query solution.
Execute packages and design package security.
Understand the basics of the DTS Object Model.
Modify DTS package properties.
Implement DTS in specific real-world data load scenarios.
Apply tuning techniques to DTS data loads.

Qualifications:

There are no exams associated with this course.