Designing & Populating a Data Warehouse With Microsoft SQL Server 2000

Global Knowledge UK
Coventry, Dublin, London, Wakefield, Wokingham, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This five-day instructor led, hands-on course is designed to provide students 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

Objectives
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 dataDesign 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 scenariosApply tuning techniques to DTS data loads

Pre-Requisites

Delegates are required to meet the following:

Familiarity with MS SQL Server V7.0 / 2000
Knowledge of Transact-SQL usage in the development of OLTP systems
Understanding of programming principlesUnderstanding of basic database design, administration & implementation concept

Target Audience
This course is intended for system administrators who wish to design and populate a data warehouse with Microsoft SQL Server 2000

Content

Using DTS in a Data Warehouse

Defining Data Transformation Services
Identifying DTS Applications
Defining the Data Warehouse System
Applying DTS to the Data Warehouse

Defining Data Warehouse Structures

Defining the Polaris Data Warehouse
Identifying Source and Destination Structures
Defining Dimension & Fact Tables
Implementing the Star Schema

Populating Data Warehouse Structures

Reviewing the Star Schema Data Load
Defining the Dimension Data Load
Defining the Fact Table Data Load
Implementing Staging Tables
Applying Data Transformation Services
Using DTS to Populate the Sales Star

Using DTS Import/Export Wizard

Defining the Import/Export Wizard
Copying Objects Between Heterogeneous Databases
Copying Tables from Microsoft Access 2000 to SQL Server
Creating a Prototype Package
Loading the Employee_dim Dimension
Loading the Product_dim Dimension

Case Study - Populating the Shipments Star

Defining & Populating the Shipments Star
Migrating the Shipments Star

Applying Best Practices

Defining the Data Load Scenario
Developing Packages & Choosing Tasks
Designing Transformations
Defining Workflows
Storing, Executing and Managing Packages

Understanding DTS Package Elements

Learning Package Components
Using DTS Package Designer
Defining Package connections, Tasks & Steps
Storing and Executing Packages
Adding a Parallel Data Load to Product_dim

Copying and Managing Data

Identify DTS Tasks that copy & manage Data
Using the Bulk Insert Task
Loading Staging Tables
Using the Execute SQL Task
Using the Copy SQL Server Objects Task

Performing Data Transformations

Performing Transformations in DTS
Defining the Transform Data Task
Setting Up the Source and Destination
Creating Transformations
Configuring Error Handling
Optimizing for SQL Server Destinations

Extending Transformations

Building Microsoft ActiveX Script Transformations
Creating Advanced Transformations

Using Lookup Queries
Implementing SQL SolutionsUsing the Multiphase Data Pump
Implementing Data Driven Query Solutions

Using the Data Driven Query Task
Building a Data Driven Query Task Solution
Maintaining Slowly Changing Dimensions
Refreshing the New_product_dim Table
Learning Best Practices for the DDQ

Storing DTS Packages and Metadata

Understanding Package Versions
Storing & Securing DTS Packages
Storing Metadata & Tracking Data Lineage

Executing Packages

Defining Package Executions
Executing Packages Interactively
Using Package Execution Utilities
Creating Package Execution Logs
Executing Modula & Scheduling Packages

Managing Package Properties

Reviewing DTS Package Elements
Understanding Disconnected Edit
Using the Dynamic Properties Task
Managing Connection Properties

Building Advanced Workflows

Implementing Asynchronous Workflows
Implementing Package Transactions
Creating a Package Loop

...''

Phone:+44 (0) 118 977 7766

School Address:

Global Knowledge UK
Mulberry Business Park,
Fishponds Rd, Wokingham, RG41 2GY

Jobs & Resumes: Coventry, Dublin, London, Wakefield, Wokingham
Houses & Roommates: Coventry, Dublin, London, Wakefield, Wokingham

Exchange 2007
Microsoft Vista Preview
FrontPage 2000
XML-Based Web Applications
XML and XSLT
Exchange Server 2003
Troubleshooting Microsoft Exchange Server 2003
Microsoft Office SharePoint Portal Server 2003
Microsoft Office Live Communications Server 2003
Windows 2000 Clustering
C# Programming
E-Business Solutions Using Microsoft BizTalk Server 2004
Microsoft Windows XP Operating System
MS Windows Server 2003 Active Directory & Network Infrastructure
Microsoft Windows XP Professional
ASP.NET Web Application Using Visual Studio .NET
Programming the Microsoft .NET Framework with C#
Visual Basic.Net
ADO.NET

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later.