SQL Server 2000 DTS & OLAP
|
SQL Server 2000 DTS & OLAP: 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
9 Sessions
27 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
Session 5
Section A: Introduction - Section B: OLAP Model - Section C: Analysis Services - Section D: Analysis Manager - Section F: Dimension Structure - Section G: Dimension Types
Session 6
Section A: Properties - Section B: More Properties - Section C: Parent-Child Dimension - Section D: Level Properties - Section E: Hierarchies & Groupings - Section F: Time Dimensions - Section G: Advanced Dimensions - Section H: Introduction to Cubes - Section I: Measures
Session 7
Section A: Derived Measures - Section B: Cube Properties - Section C: Storage Design - Section D: Storage Design Wizard - Section E: Cube Optimization - Section F: Processing Dimensions - Section G: Methods of Cube Processing
Session 8
Section A: Optimizing Cube Processing - Section B: Creating a Partition - Section C: Advanced Partitions - Section D: Virtual Cubes - Section E: Calculating Members - Section F: Calculated Member Builders - Section G: Function List Basics - Section H: Function List Basics (cont.)
Session 9
Section A: Members, Tuples, & Sets - Section B: Percent of a Total - Section C: Growth Calculation - Section D: More Calculated Members - Section E: Cube Features - Section F: Security - Section G: Deploying a Database - Section H: Microsoft Excel & OLAP
More Information...
$930.00
|
|
|
SQL Server 2000 DTS & OLAP: 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
9 Sessions
27 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 Server 2000 DTS & OLAP: 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
9 Sessions
27 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 Server 2000 DTS & OLAP: 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
9 Sessions
27 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 Server 2000 DTS & OLAP: 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
9 Sessions
27 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
|
|
|
|
SQL Server 2000 DTS & OLAP: Session 05
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
9 Sessions
27 Hours of Interactive Training
Session content
Session 5
Section A: Introduction - Section B: OLAP Model - Section C: Analysis Services - Section D: Analysis Manager - Section F: Dimension Structure - Section G: Dimension Types
More Information...
$135.45
|
|
|
|
SQL Server 2000 DTS & OLAP: Session 06
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
9 Sessions
27 Hours of Interactive Training
Session content
Session 6
Section A: Properties - Section B: More Properties - Section C: Parent-Child Dimension - Section D: Level Properties - Section E: Hierarchies & Groupings - Section F: Time Dimensions - Section G: Advanced Dimensions - Section H: Introduction to Cubes - Section I: Measures
More Information...
$135.45
|
|
|
|
SQL Server 2000 DTS & OLAP: Session 07
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
9 Sessions
27 Hours of Interactive Training
Session content
Session 7
Section A: Derived Measures - Section B: Cube Properties - Section C: Storage Design - Section D: Storage Design Wizard - Section E: Cube Optimization - Section F: Processing Dimensions - Section G: Methods of Cube Processing
More Information...
$135.45
|
|
|
|
SQL Server 2000 DTS & OLAP: Session 08
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
9 Sessions
27 Hours of Interactive Training
Session content
Session 8
Section A: Optimizing Cube Processing - Section B: Creating a Partition - Section C: Advanced Partitions - Section D: Virtual Cubes - Section E: Calculating Members - Section F: Calculated Member Builders - Section G: Function List Basics - Section H: Function List Basics (cont.)
More Information...
$135.45
|
|
|
|
SQL Server 2000 DTS & OLAP: Session 09
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
9 Sessions
27 Hours of Interactive Training
Session content
Session 9
Section A: Members, Tuples, & Sets - Section B: Percent of a Total - Section C: Growth Calculation - Section D: More Calculated Members - Section E: Cube Features - Section F: Security - Section G: Deploying a Database - Section H: Microsoft Excel & OLAP
More Information...
$135.45
|
|
- «« Start
- « Prev
- 1
- Next »
- End »»
Results 1 - 10 of 10