Online Data Transformation Services eLearning - Training Resources
Data Transformation Services Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
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...
SQL Server 2000 Design Implement Databases Part 5 Dist Data Locks
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 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 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 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.
Identify
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...
From Software Training Academy, Inc
SQL Server 2005 Analysis Services SSAS

In this course, you will learn how to use Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to
more...
