SQL 2000 DTS for Developers
|
SQL 2000 DTS for Developers: Complete
Overview
Data Transformation Services (DTS) is a set of tools that allow data to be modified and moved between wide varieties of databases. In the SQL Server 2000 DTS course from LearnKey, database developers and administrators will show you how to use DTS with SQL Server. Expert instructor Leslie Koorhan demonstrates how to transfer data from SQL Server to other databases and the use of package components – tasks, steps and connections. At the conclusion of this course, you will know how to incorporate DTS into any automated data transfer process.
Prerequisites: Understanding of relational databases required. Previous database design experience recommended. Data warehouse knowledge helpful.
Benefits
- Gain technical mastery of databases and increase your IT credibility.
- Your IT knowledge and proficiency will open doors and maximize earning potential.
- LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.
Also available for purchase as individual sessions
Club Training Australia understand that you may already have experience with this product and are looking to expand your knowledge. With this in mind Club Training Australia is proud to offer each of the sessions in this course for sale on a session-by-session basis.Simply select the session that contains the information you wish to learn and select the corresponding number from the drop down list on this page and then click on add to cart.
Sessions
4 Sessions
12 Hours of Interactive Training
Session content
Session 1
Section A: Introduction - Section B: Transactional Databases - Section C: Data Warehouse - Section D: Schemas & Data Marts - Section E: OLAP Cubes - Section F: DTS - Section G: DTS Import/Export Wizard - Section H: Using DTS Wizard - Section I: Object Transferring - Section J: Prototype Package
Session 2
Section A: DTS Package - Section B: DTS Connections - Section C: Data Link Connections - Section D: DTS Tasks - Section E: DTS Steps - Section F: Bulk Insert Task - Section G: Format Files - Section H: Executing Bulk Insert
Session 3
Section A: Execute SQL Tasks - Section B: Transform Data Task - Section C: Data Type Conversion - Section D: Error Handling - Section E: Transform Script - Section F: Advanced Transformation - Section G: Lookup Queries - Section H: Multi-phase Data Pump
Session 4
Section A: Data Driven Query Task - Section B: Storing DTS Packages - Section C: Data Lineage - Section D: Package Execution - Section E: Modular Packages - Section F: Property Management
More Information...
$410.00
|
|
|
SQL 2000 DTS for Developers: Session 01
Overview
Data Transformation Services (DTS) is a set of tools that allow data to be modified and moved between wide varieties of databases. In the SQL Server 2000 DTS course from LearnKey, database developers and administrators will show you how to use DTS with SQL Server. Expert instructor Leslie Koorhan demonstrates how to transfer data from SQL Server to other databases and the use of package components – tasks, steps and connections. At the conclusion of this course, you will know how to incorporate DTS into any automated data transfer process.
Prerequisites: Understanding of relational databases required. Previous database design experience recommended. Data warehouse knowledge helpful.
Benefits
- Gain technical mastery of databases and increase your IT credibility.
- Your IT knowledge and proficiency will open doors and maximize earning potential.
- LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.
Also available for purchase as individual sessions
Club Training Australia understand that you may already have experience with this product and are looking to expand your knowledge. With this in mind Club Training Australia is proud to offer each of the sessions in this course for sale on a session-by-session basis.Simply select the session that contains the information you wish to learn and select the corresponding number from the drop down list on this page and then click on add to cart.
Sessions
4 Sessions
12 Hours of Interactive Training
Session content
Session 1
Section A: Introduction - Section B: Transactional Databases - Section C: Data Warehouse - Section D: Schemas & Data Marts - Section E: OLAP Cubes - Section F: DTS - Section G: DTS Import/Export Wizard - Section H: Using DTS Wizard - Section I: Object Transferring - Section J: Prototype Package
More Information...
$135.45
|
|
|
|
SQL 2000 DTS for Developers: Session 02
Overview
Data Transformation Services (DTS) is a set of tools that allow data to be modified and moved between wide varieties of databases. In the SQL Server 2000 DTS course from LearnKey, database developers and administrators will show you how to use DTS with SQL Server. Expert instructor Leslie Koorhan demonstrates how to transfer data from SQL Server to other databases and the use of package components – tasks, steps and connections. At the conclusion of this course, you will know how to incorporate DTS into any automated data transfer process.
Prerequisites: Understanding of relational databases required. Previous database design experience recommended. Data warehouse knowledge helpful.
Benefits
- Gain technical mastery of databases and increase your IT credibility.
- Your IT knowledge and proficiency will open doors and maximize earning potential.
- LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.
Also available for purchase as individual sessions
Club Training Australia understand that you may already have experience with this product and are looking to expand your knowledge. With this in mind Club Training Australia is proud to offer each of the sessions in this course for sale on a session-by-session basis.Simply select the session that contains the information you wish to learn and select the corresponding number from the drop down list on this page and then click on add to cart.
Sessions
4 Sessions
12 Hours of Interactive Training
Session content
Session 2
Section A: DTS Package - Section B: DTS Connections - Section C: Data Link Connections - Section D: DTS Tasks - Section E: DTS Steps - Section F: Bulk Insert Task - Section G: Format Files - Section H: Executing Bulk Insert
More Information...
$135.45
|
|
|
|
SQL 2000 DTS for Developers: Session 03
Overview
Data Transformation Services (DTS) is a set of tools that allow data to be modified and moved between wide varieties of databases. In the SQL Server 2000 DTS course from LearnKey, database developers and administrators will show you how to use DTS with SQL Server. Expert instructor Leslie Koorhan demonstrates how to transfer data from SQL Server to other databases and the use of package components – tasks, steps and connections. At the conclusion of this course, you will know how to incorporate DTS into any automated data transfer process.
Prerequisites: Understanding of relational databases required. Previous database design experience recommended. Data warehouse knowledge helpful.
Benefits
- Gain technical mastery of databases and increase your IT credibility.
- Your IT knowledge and proficiency will open doors and maximize earning potential.
- LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.
Also available for purchase as individual sessions
Club Training Australia understand that you may already have experience with this product and are looking to expand your knowledge. With this in mind Club Training Australia is proud to offer each of the sessions in this course for sale on a session-by-session basis.Simply select the session that contains the information you wish to learn and select the corresponding number from the drop down list on this page and then click on add to cart.
Sessions
4 Sessions
12 Hours of Interactive Training
Session content
Session 3
Section A: Execute SQL Tasks - Section B: Transform Data Task - Section C: Data Type Conversion - Section D: Error Handling - Section E: Transform Script - Section F: Advanced Transformation - Section G: Lookup Queries - Section H: Multi-phase Data Pump
More Information...
$135.45
|
|
|
|
SQL 2000 DTS for Developers: Session 04
Overview
Data Transformation Services (DTS) is a set of tools that allow data to be modified and moved between wide varieties of databases. In the SQL Server 2000 DTS course from LearnKey, database developers and administrators will show you how to use DTS with SQL Server. Expert instructor Leslie Koorhan demonstrates how to transfer data from SQL Server to other databases and the use of package components – tasks, steps and connections. At the conclusion of this course, you will know how to incorporate DTS into any automated data transfer process.
Prerequisites: Understanding of relational databases required. Previous database design experience recommended. Data warehouse knowledge helpful.
Benefits
- Gain technical mastery of databases and increase your IT credibility.
- Your IT knowledge and proficiency will open doors and maximize earning potential.
- LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.
Also available for purchase as individual sessions
Club Training Australia understand that you may already have experience with this product and are looking to expand your knowledge. With this in mind Club Training Australia is proud to offer each of the sessions in this course for sale on a session-by-session basis.Simply select the session that contains the information you wish to learn and select the corresponding number from the drop down list on this page and then click on add to cart.
Sessions
4 Sessions
12 Hours of Interactive Training
Session content
Session 4
Section A: Data Driven Query Task - Section B: Storing DTS Packages - Section C: Data Lineage - Section D: Package Execution - Section E: Modular Packages - Section F: Property Management
More Information...
$135.45
|
|
- «« Start
- « Prev
- 1
- Next »
- End »»