Online Data Transformation Services eLearning Training Certification Training

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

Online Data Transformation Services eLearning Training

Data Transformation Services Training Seminars and Classes