(<img height='1' width='1' border='0' src="http://www.googleadservices.com/pagead/conversion/1072619999/?value=1&label=Lead&script=0" />)
F1
About F1Course ScheduleOther ServicesSite MapContactHome

Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services

Exchange Server
Office (inc Access)
SQL Server
Visual Studio .NET
Windows
Web Development
Visual FoxPro
Programming
Business
Knowledge Management
Certification
Learning Options
Reserve a Place
12 May London
19 May Bath
09 Jun Bath
16 Jun London
14 Jul Bath
21 Jul London
11 Aug Bath
18 Aug London
08 Sep Bath
15 Sep London
06 Oct Bath
13 Oct London
03 Nov Bath
10 Nov London
01 Dec Bath
08 Dec London
05 Jan London
05 Jan Bath
02 Feb London
02 Feb Bath
02 Feb London
02 Feb London
02 Feb Bath
02 Feb Bath
View Other Courses in Same Category

Module 1: Understanding the Microsoft Data Warehouse Architecture

  • Understand data warehousing concepts and applications.
  • Describe characteristics, goals, and applications of a data warehouse.
  • Explain the relationship between data marts and a data warehouse.
  • Describe reasons for implementing relations and/or multidimensional data marts to meet decision support needs.
  • Describe tools to manage a data warehouse implementation.
Top

Module 2: Designing Data Warehouse Structures

  • Build relational data marts by using star schemas.
  • Describe a process for designing data warehouse systems.
  • Create conceptual data models for star schemas.
  • Design star schema dimensions and fact tables.
  • Explain common design issues for dimensions and fact tables.
  • Physically implement data models.
Top

Module 3: Populating the Data Warehouse

  • Develop a data warehouse load strategy.
  • Design specificiations for data extract and load programs.
  • Describe data load design requirements for data warehouses.
  • Determine the usage of staging, development, and test environments.
  • Identify the main SQL Server data movement tools.
  • Explain the unique data transfer functionality of DTS
Top

Module 4: Using the Data Transformation Services Wizard

  • Use the DTS Import/Export Wizard.
  • Access the DTS Designer Interface.
  • Create a basic DTS package by using the DTS Import/Export Wizard.
  • Set up source and destination data sources.
  • Define source to destination column mappings.
  • Execute a package.
  • View package results.
Top

Module 5: Understanding DTS Package Elements

  • Understand DTS package components.
  • Create a package by using the DTS Designer.
  • Set up connections for data sources and destinations.
  • Configure Universal Data Link Files.
  • Set up package tasks.
  • Define package workflow by using precedence constraints.
  • Create global variables.
  • Design package storage: SQL Server, Repository, File, and Visual Basic.
  • List best practices for designing packages.
Top

Module 6: Copying and Managing Data

  • Use DTS to copy and manage data.
  • Move objects by using the Transfer Objects Task.
  • Describe when to use the Copy Database Wizard Tasks.
  • Use the Bulk Insert Task to load files into SQL Server.
  • Use the Execute SQL Task to issue queries, execute stored procedures, and to populate global variables.
  • List best practices for applying the Execute SQL, Bulk Insert, and Transfer Objects tasks.
Top

Module 7: Performing Insert Based Transformations

  • Design insert based transformations by using the Transform Data Task.
  • Describe how and when to use the Transform Data Task.
  • Implement column data transformations.
  • Use input parameters to the Transform Data Task.
  • Implement SQL solutions with the Transform Data Task.
  • Design ActiveX solutions with the Transform Data Task.
  • Control the execution of the Data Pump by using DTSTransformStat constants.
  • Configure commit batches for the Transform Data Task.
  • List best practices for designing data transformations.
Top

Module 8: Implementing Data Driven Query Solutions

  • Implement a Data Driven Query solution.
  • Determine when and how to use the Data Driven Query task.
  • Perform inserts, updates, deletes, and user-defined queries by using the Data Driven Query Task.
  • Use the Data Driven Query to perform incremental updates.
  • List best practices for designing Data Driven Query solutions.
Top

Module 9: DTS Package Execution and Security

  • Execute packages and design package security.
  • Execute packages interactively, programmatically, and via the command line.
  • Describe how to automate and schedule packages.
  • Use the Execute Package task to execute child packages within a master package.
  • Set up package transactions.
  • Pass global variables between packages.
  • Enable package and step logging to the msdb database.
  • Use the MSMQ task to set up asynchronous package processing.
  • Configure package security.
  • Determine how DTS security integrates with SQL Sever and SQL Server Agent Security.
Top

Module 10: DTS Programming

  • Understand the basics of the DTS object model.
  • Describe DTS functionality accessible via the Object Model that goes beyond what is offered in the DTS Designer GUI.
  • Identify key objects and properties of the DTS Object Model.
  • List DTS package, tasks, and transform customization options.
Top

Module 11: Managing DTS Package Properties

  • Modify DTS package properties.
  • Modify package properties by using the Dynamic Properties task.
  • Use Disconnected Edit to perform off-line package modifications.
  • Use the Execute SQL Task to populate global variables that store package property values.
  • Use Global Variables as command line parameters to modify values for a single package execution.
  • List best practices for modifying package properties
Top

Module 12: Real World Data Load Scenarios

  • Implement DTS in specific real world data load scenarios.
  • Loop through all of the files in a source directory and load them into a destination table by using Microsoft ActiveX® scripts.
  • Implement data lineage by using the Repository.
  • Split one source record into many destination records by using ActiveX scripts.
  • Implement error handling by using the multi-phase data pump.
  • Perform in memory lookups by using global variables, ADO recordsets, and the multi-phase data pump.
Top

Module 13: Optimizing DTS Data Loads

  • Apply tuning techniques to DTS data loads.
  • List DTS load testing practices.
  • Describe how to scale DTS to move large datasets.
  • Describe techniques for implementing indexes and primary key/foreign key constraints for small and large data loads.
  • Review best practices for designing and managing packages.
Top
.

Exams:

  • There are no exams directly associated with this course

Price Options ex VAT:

Classroom Training
?		 Distance Learning
?		 eLearning Options
?		 Book Learning
?
£ 1750
(€2486) 		£ 995.00
(€1413) 		- No Books Supported for Course at present

Call Free on 0800 169 1890
Print 2 Page Flyer
Last Modified 01 May 2008