Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

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


 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
© Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy