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
Course Classification:
Technical Training Course
This is an instructor led training course taught in a classroom based environment.
Scheduled course dates
| September 2010 | October 2010 | November 2010 | December 2010 | January 2011 |
| - | - | - | - | - |
View full schedule of SQL Server 2000 courses
Print / Download PDF Version of full course schedule
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite SQL Training and bespoke SQL courses