Technology:

 

Windows 2000 / SQL 2000

Course:

Populating a Data Warehouse with Microsoft SQL Server 2000

Data Transformation Services

MS-2092

Type:

DBA/Development

Duration:

5 Days

Description:

 

Delivery Method:

Instructor led

 

Summary Description:

 

Audience:

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.

 

Network administrators with some limited knowledge and/or experience using Windows 2000 Professional or Server. A good understanding of the concept of Directory Services is necessary.

Objectives:

 

Comments:

This course will help the student prepare for the following Microsoft Certified Professional exams:

                There are no exams associated with this course.

 

ü        Experience using the Microsoft Windows® 2000 operating system

ü        An understanding of basic relational database concepts

ü        Knowledge of basic Transact-SQL syntax (SELECT, UPDATE, and INSERT statements).

ü        Familiarity with the role of the database administrator.

Topics Covered:

By the end of this course, the student should 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.

 

 

Prerequisites:

 Student should be able to:

ü        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.

ü        The course materials, lectures, and activities are in English. To benefit fully from the instruction, students need an understanding of the English language and completion of the prerequisites.