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

Code: 2092
Course duration: 5 days
Price:

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

Prerequisites:
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

Objectives:

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

&n

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
2019-08-09
09:00 to 17:00
Fort Lauderdale, Florida (Instructor-Led)
2019-08-07 09:00 to 2019-08-09 17:00
Attend Online
2019-08-02
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