Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services

Code: 2092
Course duration: 5 days

2092 - Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services
Duration: 5 Days.

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

Course Description:
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


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

Lesson 1: Using DTS in a Data Warehouse

Defining Data Transformation Services

Identifying DTS Applications

Defining the Data Warehouse System

Applying DTS to the Data Warehouse

Lesson 2: Defining Data Warehouse Structures


Guaranteed to Run

2019-08-28 09:00 to 2019-08-30 17:00
Attend Online
2019-08-14 09:00 to 2019-08-16 17:00
Attend Online
09:00 to 17:00
Fort Lauderdale, Florida (Instructor-Led)
2019-08-07 09:00 to 2019-08-09 17:00
Attend Online
09:00 to 17:00
Palm Beach County Florida (Instructor-Led)
2019-07-25 09:00 to 2019-07-26 17:00
NYC-23rd Street (Virtual Instructor-Led)
2019-07-25 09:00 to 2019-07-26 17:00
Attend Online
2019-07-24 09:00 to 2019-07-26 17:00
Washington, D.C. (Virtual Instructor-Led)

Course Reviews

No reviews found for this course.

Be the first to write a review