Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training          Email Us   Phone :
Contact Us   -   About Us   -   Clients    
Loading
Order CD-ROMs   Order Videos 
Microsoft SQL Server 2000: DTS
with Leslie Koorhan

View the Course Outline

In this course, you will learn how to use Data Transformation Services (DTS) in Microsoft SQL Server 2000. This course presents DTS as an integral part of a data warehousing solution. You will learn how DTS works, how to set up DTS packages, and how to use the graphical tools for creating and maintaining packages. You will also learn how to use the various components of DTS packages: connections, tasks, steps, and global variables. Learning DTS not only benefits those who design and build data warehouses and data marts, but also anyone who works with data that is stored in different formats throughout an organization. This course shows you how Data Transformation Services can be used in any situation involving data transfer or maintaining the consistency of data.

Course includes 18+ hours of total training time...

  • 4 CDs
  • Over 6 hours of media run time
  • Over 300 pages of courseware on CD-ROM
  • Step-by-step hands-on-labs
  • Sample code
Format Modules Retail Price
Microsoft SQL Server 2000: DTS
CD-ROM

  4 CD-ROMs

$195.00  
CD-ROM & Books

 4 CD-ROMs + Printed Books
$235.00  
• Read about Leslie Koorhan .
Course Outline (Outlines are subject to change.)

Microsoft SQL Server 2000: DTS


Modules Run Time Pages
4 CDs 6 hours 300

In this course, you will learn how to use Data Transformation Services (DTS) in Microsoft SQL Server 2000. This course presents DTS as an integral part of a data warehousing solution. You will learn how DTS works, how to set up DTS packages, and how to use the graphical tools for creating and maintaining packages. You will also learn how to use the various components of DTS packages: connections, tasks, steps, and global variables. Learning DTS not only benefits those who design and build data warehouses and data marts, but also anyone who works with data that is stored in different formats throughout an organization. This course shows you how Data Transformation Services can be used in any situation involving data transfer or maintaining the consistency of data.



In this course, you will learn to...
  • Understand what a data warehouse is and how to use it.
  • Use the DTS Import/Export Wizard.
  • Work with the components of a DTS package.
  • Use the DTS Package Designer.
  • Copy and manipulate data using DTS.
  • Use the Transfer Data Task.
  • Use the Bulk Insert Task.
  • Store DTS packages.
  • Execute and secure DTS packages.
  • Modify the properties of DTS packages.

Prerequisites :

This course is appropriate for database administrators and database developers who want to learn how to use the tremendous functionality of Data Transformation Services. Knowledge of SQL Server and the Enterprise Manager tool is a prerequisite, but you do not necessarily have to be using SQL Server for all of your database needs to benefit from this course.

SESSION 1

Introduction to Data Warehouses and Cubes
  • Database Technology
  • Data Warehouses
  • OLAP Cubes
  • Data Transformation Services
DTS Import/Export Wizard
  • What Is the Import/Export Wizard?
  • Copying
  • Transferring SQL Server Objects
  • Prototype Package
 SESSION 2

DTS Packages
  • DTS Package
  • DTS Package Designer
  • Connections
  • Tasks
  • Steps
DTS Common Tasks
  • Bulk Insert Task
SESSION 3

DTS Common Tasks (continued)
  • Execute SQL Task
  • Transform Data Task
Extending Transformations
  • Transformation Scripts
  • Advanced Transformations
  • Lookup Queries
  • Multiphase Data Pump
 SESSION 4

Extending Transformations (continued)
  • Data Driven Query Task
Package Administration
  • Overview of Administration
  • Storing DTS Packages
  • Using Metadata
  • Executing Packages
  • Managing Properties

back to top

Your Instructor

Leslie Koorhan is the owner of TeraCore, where he specializes in development using Visual Studio.NET and Microsoft SQL Server 2000. Leslie is a Microsoft Certified Trainer, a Microsoft Certified Solution Developer (MCSD), a Microsoft Certified Systems Engineer (MCSE) using Windows NT 4.0 and a Microsoft Certified Database Administrator (MCDBA). Leslie has used many development products over the years, most recently Visual Basic.NET, Visual C#.NET and database technologies such as ADO.NET and ADO. He has also worked with Internet technologies such as ASP.NET, ASP, XML, and XSLT. Leslie has done courseware design, written numerous articles and has been teaching computer development courses for over nine years. Most recently, Leslie co-authored and tech edited "SAMS Teach Yourself Object-Oriented Programming with Visual Basic.NET in 21 Days."

back to top
Contact Information
WINTRAC INC. - the one stop shopping center for IT training.
16523 S.W. McGwire Ct. Beaverton OR -97007
Phone: (503) 259-0312
Fax: 707-598-2268
Email: sales@wintrac.com

Send mail to webmaster@wintrac.com with questions or comments about this web site.
Copyright © 2012 Wintrac Inc.