Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services Course
Course Description
This course provides delegates with the knowledge and skills necessary to design a data warehouse and to populate data marts by using Data Transformation Services (DTS) in Microsoft SQL Server 2000.
Course pre-requisites:
Delegates must be familiar with Microsoft SQL Server version 7.0 or Microsoft SQL Server 2000. Delegates should also have knowledge of Transact-SQL usage in the development of OnLine Transaction Processing (OLTP) systems plus a basic understanding of programming principles and basic database design, administration, and implementation concepts.
Topics covered on the 5 day Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services course
Delegates will learn how to:
- Understand data warehousing concepts and applications
- Build relational data marts by using star schemas
- Develop a data warehouse data load strategy
- Use the DTS import/export Wizard
- Understand DTS package components
- Use DTS to copy and manage data
- Implement a data driven query solution
- Understand the basics of the DTS object model
- Modify DTS package properties
This is an instructor led training course taught in a classroom based environment.
Course Classification:
Technical Training Course
Course Fee = £1500 (excl.VAT)
Scheduled course dates
| May 2008 |
June 2008 |
July 2008 |
August 2008 |
September 2008 |
| - | - | - | - |
|
|
If you want to attend the course but can't make the dates published then click here for details of our one-to-one training packages.
PTR Associates Limited
21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
Tel: 0118 979 4000 Fax: 0118 979 4035
Email: training@ptr.co.uk
|
