SQL Server 7.0 Data Warehousing Part II

This course is a multi-step process of collecting cleansing and storing data for use in analyses and reporting applicaitions and making information available to a wide audience of end-users. Using the Data Transformation Services Package Designer the student will be able to define steps workflow and transformations necessary to build a data warehouse.

This is primarily online training This is an online eLearning or CBT training program Contact Serebra Learning Corporation for more information

Duration: 5 hours Training Presented in: English

Audience

SQL Server 7.0 Data Warehousing is designed for imformation system professionals whose role it is to gather store and provide data for business reporting purposes and who wants to utilize the powerful new features of SQL Server 7.0. It can also be used by IS Managers who need to understand the capabilities of SQL Server 7.0. It can provide a greater understanding of the intricacies of data warehousing to intersted people who are familiar with fundamental relatinal datavase concepts and terms.

Prerequisites

Should be familiar with fundamental database concepts and client/server operations and architecture. Knowledge of earlier versions of MS SQL Server is essential to uderstand the importance of recent upgrades included in the SQL Server 7.0 product.

Objective

Upon completion of this course the student will be able to:

• Describe the DTS architecture and the Import and Export process
• Explain the transformation process
• Describe the DTS Package Designer
• Explain the three replication methods
• Explain the process of Conflict Resolution

Topics Include

Data Transformation Services

• Data Transformation Architecture
• Importing and Exporting Data
• Transforming Data
• DTS Package Designer

Replication

• Overview
• Snapshot Method
• Transactional Method
• Merge Method
• Conflict Resolution

Duration

5 Hours

Minimum Requirements

IBM-compatible PC with 166 MHz or higher processor 32 MB RAM (64 MB RAM recommended); 800x600 SVGA color monitor with 16-bit high color display; Internet Explorer 4 or Netscape Navigator 4 or later with Shockwave 7.0.1; Windows 95 Windows 98 Windows NT; 3.5 diskette (for tracking); 28.8 kbps connection or higher for on-line use.

Media

CDROM
Web Based Training