Online Data Transformation Services eLearning
Data Transformation Services Training Provider? - Tell us about your Training!
From Online Training Directory
SQL Server 2000 Data Warehousing
This course will teach you the knowledge and skills necessary to design a data warehouse and to populate data marts by using Data Transformation Services (DTS) in Micorsoft SQL Server 2000
This course will teach you the ins and outs of in Micorsoft SQL Server 2000 by providing the knowledge and skills necessary to understand the underlying design and principles of a data warehouse.
You will
more...
SQL Server 2000 Data Warehousing
From 123-CBT Computer Based Training
SQL Server 7 0 System Administration - Part 4

...transfer tool names with uses.
Identify the features of Data Transformation Services (DTS).
Identify data source and data destination types provided in SQL Server.
Match each Data Transformation Services (DTS) tool with its function.
Identify the features of restructuring and mapping data.
Select the functions that can be performed using Data Transformation Services (DTS) steps.
more...
SQL Server 7 0 System Administration - Part 4
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 2

...schemas; identify the data warehouse models; identify the Data Transformation Services (DTS) components and the components of the DTS object model; identify the methods of distributing data; and identify the replication types and techniques. L earn To: Identify the design characteristics of OLAP systems and Aggregate schemas. Identify the data warehouse models. Identify the Data
more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 3

... Create an index on a table. Maintain an index. Build a Data Transformation Services (DTS) package to transfer data from a Microsoft SQL Server 7.0 database to a data warehouse database. Unit 2: Replication Duration: 1 - 2 Hour(s) Create a publication in a SQL Server 7.0 database by using the Enterprise Manager. Create a Microsoft Access data mart for subscribing to a publication
more...
SQL Server 2000 Database Admin Part 4 Managing Data

...ir functions. Identify the features and functions of the Data Transformation Services (DTS) process. Identify the features of distributed data. Identify the different methods of distributing data. Identify the features of the publisher-subscriber metaphor. Identify the features of the Database Maintenance Plan Wizard. Troubleshoot a database by using the Database Consistency Checker
more...
SQL Server 2000 Design Implement Databases Part 5 Dist Data Locks

...functions. o Identify the features and functions of the Data Transformation Services (DTS) process. o Identify the features of distributed data. o Identify the different methods of distributing data. o Match the replication types with their characteristics. o Identify the considerations for using transactions and locks. o Create a Transact-SQL script to define a transaction. o
more...
From Serebra Learning Corporation
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 2
This is the second course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the design characteristics of OLAP systems and Aggregate schemas; identify the data warehouse models; identify the Data
more...
SQL Server 7.0 Data Warehousing SQL Part I
This course is designed to help students gain knowledge of the core components of data warehousing application development tools and SQL management tools. The course introduces basic concepts terminology for understanding SQL Server 7.0 relational databases Structured Query Language and new or improved features. It builds on this foundation to cover client/server web applications programming
more...
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.
more...
