|
|
 |
Microsoft SQL Server 2000
Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services (2092)
|
|
|
Who Should Attend
| Suitable for for developers of database client applications, including Internet and N-tiered application clients, SQL Server database developers who need to query, insert, update, or delete data from a database by using XML, and for SQL Server database administrators who need to publish SQL data as XML. |
Prerequisites
| Completion of courses (832) System Administration for Microsoft SQL Server 7.0 and course (833) Implementing a Database on Microsoft SQL Server 7.0, and knowledge of SQL Server 7.0 or 2000, Transact-SQL usage, basic understanding of programming principles and understanding of basic database design, administration, and implementation concepts or the equivalent knowledge |
Course Objectives
| This course provides the knowledge and necessary to design a data warehouse and to populate data marts by using Data Transformation Services (DTS) in SQL Server 2000. Students will learn how to 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, design insert based transformation by using the Transform Data Task, implement a data driven query solution, execute packages and design package security, understand the basics of the DTS Object Model, modify DTS package properties, implement DTS in specific real-world data load scenarios and apply tuning techniques to DTS data loads. |
Course Content
| 1. Using DTS in a Data Warehouse
|
| 2. Defining Data Warehouse Structures
|
| 3. Populating Data Warehouse Structures
|
| 4. Using the DTS Import/Export Wizard
|
| 5. Understanding DTS Package Elements
|
| 6. Copying and Managing Data
|
| 7. Performing Data Transformations
|
| 8. Extending Transformations
|
| 9. Implementing Data Driven Query Solutions
|
| 10.Storing DTS Packages and Metadata
|
| 11.Executing Packages
|
| 12.Managing Package Properties
|
| 13.Building Advanced Workflows
|
| 14.Applying Best Practices
|
| 15.Case Study - Populating the Shipments Star |
|
|
|
|
Top