SQL Server 2000: DTS Professional Training Series

Entire course includes...

  • 4 CDs
  • Over 6 hours of instruction
  • Over 300 pages of courseware on CD-ROM
  • Step-by-step hands-on-labs Sample code
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


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.

Regular price: $595.95padSale price: $495.95pad

Click here for Secure Yahoo Order: SQL Server 2000: DTS Professional Training Series

Get Train in SQL
SQL Training CD

Best Regards,
Oracle Database, SQL, Application, Programming Tips

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site www.erpgreat.com is not affiliated with or endorsed by any company listed at this site.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.