Layout Table~~~~4813~4813~~

4 Sessions - 12 Hours of Interactive Training~
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 training 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 training 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. .~~~4813~4814~~

Course Outline Table~~~~4813~4815~~

Session 1~Section A: Introduction
· CD Tour
· Database Functions
· Database History
· Design Issues
· OLTP
· Normalized Databases

Section B: Transactional Databases
· Indexing
· Index Issues
· Index Dilemma
· Double Databases
· Latency
· Retrieval Database
· Analysis Database

Section C: Data Warehouse
· Attributes
· Data Marts
· Data Mart Schema
· Fact Table
· Dimension Tables
· Hierarchies & Levels

Section D: Schemas & Data Marts
· Star Schemas
· Snowflake Schemas
· Data Mart Structure
· Creating a Data Mart
· Populate a Data Mart
· Staging Area

Section E: OLAP Cubes
· Structure
· Storage Modes
· Partitions
· Aggregation Design
· Virtual Cubes

Section F: DTS
· Solutions
· Components
· In the Data Mart
· In OLAP
· With Data Analysis

Section G: DTS Import/Export Wizard
· Wizard Startup
· Wizard Functionality
· Wizard Applications
· Wizard Steps
· Creating a Plan

Section H: Using DTS Wizard
· Database Setup
· Planning Import
· Select Source
· Destination
· Copy Options
· Save DTS Package
· Review Executed Package
· Verify

Section I: Object Transferring
· SQL to SQL
· Transfer Process
· Object Copy

Section J: Prototype Package
· Designing Package
· Column Mapping
· Dimension Load
· Use Query
· Select/Map Destination
· Map Columns
· Save/Verify
· View Package~~~4813~4816~~

Session 2~Section A: DTS Package
· Components
· Tasks/Steps
· Properties/Variables
· Package Designer
· Designer Toolbars
· Design Sheet

Section B: DTS Connections
· Connection Component
· Connection Sources
· Connection Types
· Connection Properties
· Connection Usage
· Parallel Data Loads
· Create Source
· Create Destination

Section C: Data Link Connections
· Connection Maintenance
· Change Connections
· Create Data Link File
· Set Properties
· Modify Package

Section D: DTS Tasks
· Tasks
· Transform Data
· Manage Data
· Job Functions
· Task Plan
· Create Task
· Setup Transformation
· Create Delete

Section E: DTS Steps
· Steps/Precedence
· Set Precedence
· Workflow Properties
· Package Organization
· Table Verification

Section F: Bulk Insert Task
· Create Bulk Insert Task
· Batch Size
· Performance Options
· Advanced Options

Section G: Format Files
· Structure
· Create Format File
· Use Bulk Insert
· Generate Format File

Section H: Executing Bulk Insert
· Bulk Insert Issues
· Staging Tables
· Bulk Insert Concepts
· Use Staging Table
· Run/Save Package
· Use Format File
· Run/Verify~~~4813~4817~~

Session 3~A: Execute SQL Tasks
· Considerations
· Parameterized Queries
· Add Global Variables
· Input Parameters
· Output Parameters
· Using SP with DTS
· Create Package
· Run/Verify

Section B: Transform Data Task
· DTS Data Pump
· Data Pump Process/Users
· Setup for Transformation
· Create Transform Task
· Transformation Options
· Column Mapping
· Middle of String

Section C: Data Type Conversion
· Transformation Flags
· Uppercase String
· DateTime Conversion
· Test Transformation

Section D: Error Handling
· Configure
· Data Movement
· SQL Server Setting
· Setup Error Reporting
· View Exception Report
· Run with Error
· Set Batch Size to 0

Section E: Transform Script
· ActiveX Script
· Transform Scripts
· Script Languages
· Components/Constants
· Script Management
· Script Performance
· Script Plan
· Skipping Row

Section F: Advanced Transformation
· One Row too Many
· Build Connections
· Select Task Properties
· Splitting Rows
· Counter Variable
· Setup Workflow

Section G: Lookup Queries
· Best Practices
· Query Plan
· Import Mapping Tables
· Create Connections
· Create Lookups

Section H: Multi-phase Data Pump
· Phases
· Usage~~~4813~4818~~

Session 4~Section A: Data Driven Query Task
· Design
· Usage
· ActiveX Script
· Planning
· Update with Data Query
· Destination & Source
· Create Package
· Update Query

Section B: Storing DTS Packages
· Package/Version GUIDs
· Save DTS Package
· Load/Edit Package
· Meta Data Services
· Structured Storage File
· Visual Basic Format
· Secure Packages

Section C: Data Lineage
· Metadata
· Meta Data Services
· Data Lineage
· Create Package
· Set Properties
· Save/View
· View Meta Data Info

Section D: Package Execution
· Package Behavior
· dtsrun.exe
· Property Parameters
· Run Package
· Alternative Actions
· dtsrunui.exe

Section E: Modular Packages
· Create Modular Package
· Failure Options
· Logging Options
· Modular Design
· Build Outer Package
· Add Inner Package

Section F: Property Management
· Disconnected Edit
· Connected Edit
· Steps/Task Edit
· Dynamic Property Tasks
· Add/Edit Assignment
· Dynamic Task Practices
· Connection Challenges~~~4813~4830~~

Ordering~~~~4813~4819~~

SQL Server 2000 DTS For Developers Training Course by LearnKey~Per Seat Licencing Available

Call 01223 894 136 for quotes for MULTIPLE USERS and Training Centre/Bootcamp & Education Solutions!~~PER USER%3A CD Course|411548|PER USER%3A ONLINE Course|!79232|LIBRARY LICENCE%3A CD Course|411545|~4813~4820~sql server 2000 dts Data Transformation Services~