Online Dts eLearning - Training Resources
Dts Training Provider? - Tell us about your Training!
 online course |
 instructor-led class |
 learn at home |
 group study |
 self-directed study |
 cd-based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer-based learning |
 discount pricing |
 online tutorial |
From 123-CBT Computer Based Training
SQL Server 2000 Design Implement Databases Part 5 Dist Data Locks
...to import and export data, and how to transform data with DTS. Additionally, users will learn how to manage distributed queries and linked servers, create transactions, manage locks, and how to troubleshoot transactions and locking. Learn To: o Identify guidelines for importing and exporting data. o Match SQL Server 2000 tools used to import and export data with their functions. o
more...
SQL Server 2000 Design Implement Databases Part 5 Dist Data Locks
...to import and export data, and how to transform data with DTS. Additionally, users will learn how to manage distributed queries and linked servers, create transactions, manage locks, and how to troubleshoot transactions and locking. Learn To: o Identify guidelines for importing and exporting data. o Match SQL Server 2000 tools used to import and export data with their functions. o
more...
SQL Server 2000 Database Admin Part 4 Managing Data
...atures 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 (DBCC). Identify the guidelines
more...
...atures 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 (DBCC). Identify the guidelines
more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 5
.... Identify the benefits of Microsoft Repository. Save a DTS Package in Microsoft Repository. Identify the benefits of metadata. Identify the characteristics of the types of metadata. Import metadata from a Microsoft Access database into Microsoft Repository by using Enterprise Manager. Display data lineage by using the metadata browser. Identify the benefits of Type Information Model.
more...
.... Identify the benefits of Microsoft Repository. Save a DTS Package in Microsoft Repository. Identify the benefits of metadata. Identify the characteristics of the types of metadata. Import metadata from a Microsoft Access database into Microsoft Repository by using Enterprise Manager. Display data lineage by using the metadata browser. Identify the benefits of Type Information Model.
more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 3
...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 by using the Program Manager.
more...
...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 by using the Program Manager.
more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 2
...ehouse 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 Transformation Services (DTS)
more...
...ehouse 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 Transformation Services (DTS)
more...
SQL Server 7 0 System Administration - Part 4
....
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 the features of Data
more...
....
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 the features of Data
more...
From Serebra Learning Corporation
Transferring and Transforming Data in SQL Server 2000
To enable students to extract and transform data in SQL Server 2000 Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
To enable students to extract and transform data in SQL Server 2000 Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Transferring and Transforming Data in SQL Server 2000
To enable students to extract and transform data in SQL Server 2000 Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
To enable students to extract and transform data in SQL Server 2000 Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Microsoft SQL Server 7.0: System Administration - Part 4
This is the fourth course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.
more...
This is the fourth course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.
more...
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...
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...
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...
MS SQL Server 2000: Database Administration Part 4: Managing Data
This course deals with transferring data, managing replication services, and maintaining high availability.
more...
This course deals with transferring data, managing replication services, and maintaining high availability.
more...
MS SQL Server 2000: Design and Implementation Part 5: Distributed Data and Locks
This is the final course in a five part series that teaches how to manage SQL Server 2000 transactions and locks. This course will cover how to import and export data, and how to transform data with DTS. Additionally, users will learn how to manage distributed queries and linked servers, create transactions, manage locks, and how to troubleshoot transactions and locking.
more...
This is the final course in a five part series that teaches how to manage SQL Server 2000 transactions and locks. This course will cover how to import and export data, and how to transform data with DTS. Additionally, users will learn how to manage distributed queries and linked servers, create transactions, manage locks, and how to troubleshoot transactions and locking.
more...
Microsoft Commerce Server 2000 Design and Implementation Part 5: Infrastructure, Security, & Admin.
This is the final course in a five part series that covers designing a network infrastructure to support Commerce Server 2000, describing the infrastructure components including Web Farms, staging servers and development servers, and covering network performance improvement by using switches to connect servers. The course focuses on providing network security, including configuring firewalls and
more...
This is the final course in a five part series that covers designing a network infrastructure to support Commerce Server 2000, describing the infrastructure components including Web Farms, staging servers and development servers, and covering network performance improvement by using switches to connect servers. The course focuses on providing network security, including configuring firewalls and
more...
MS SQL Server 2000: Design and Implementation Part 5: Distributed Data and Locks
This is the final course in a five part series that teaches how to manage SQL Server 2000 transactions and locks. This course will cover how to import and export data and how to transform data with DTS. Additionally users will learn how to manage distributed queries and linked servers create transactions manage locks and how to troubleshoot transactions and locking.
more...
This is the final course in a five part series that teaches how to manage SQL Server 2000 transactions and locks. This course will cover how to import and export data and how to transform data with DTS. Additionally users will learn how to manage distributed queries and linked servers create transactions manage locks and how to troubleshoot transactions and locking.
more...
From Teach Me IT
Optimizing an SQL 7.0 Data Warehouse
The Optimizing an SQL 7.0 Data Warehouse is the fourth course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. This curriculum prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019) exam. It helps students to identify tasks for data warehouse maintenance and optimization. The students will be able to optimize query
more...
The Optimizing an SQL 7.0 Data Warehouse is the fourth course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. This curriculum prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019) exam. It helps students to identify tasks for data warehouse maintenance and optimization. The students will be able to optimize query
more...
