SQL Server 7.0 Data Warehousing Using SQL Part II

This course is a multi-step process of collecting, cleansing, and storing data for use in analyses and reporting applications, 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.

Data Warehousing Using SQL Part II training covers such topics as:

Data Transformation Services
Replication

Learn exactly what you need to know about describing the DTS architecture and the Import and Export process. You will be able to explain the transformation process, describe the DTS Package Designer, explain the three replication methods, and explain the process of Conflict Resolution.

Description
This course is a multi-step process of collecting, cleansing, and storing data for use in analyses and reporting applications, 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, work flow, and transformations necessary to build a data warehouse.
Audience
SQL Server 7.0 Data Warehousing is designed for information system professionals whose role it is to gather, store and provide data for business reporting purposes, and who want 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 interested people who are familiar with fundamental relational database concepts and terms.
Prerequisites
The audience should be familiar with fundamental database concepts and client/server operations and architecture. Knowledge of earlier versions of MS SQL Server is essential to understand the importance of recent upgrades included in the SQL Server 7.0 product.
Course Duration
» 5 hours
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
Everything Courseware
SQL Server 7.0 Data Warehousing Using SQL Part II
Objectives
» 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

System Requirements CD-Based » Pentium class computer » 200 MHz processor (266 MHz recommended) » 32 MB RAM (64 MB recommended) » CD-ROM drive » Any one of Windows 95, Windows 98, Windows Me, Windows NT 4.0, Windows 2000 or Windows XP (both Windows NT 4.0 and Windows 2000 require at least 64 MB RAM) » SVGA monitor capable of 16-bit color and 800 x 600 screen resolution » Sound card with speakers or headphones (optional)