Data Warehouse with MS SQL Server 2000 DTS

Solartech, Inc
New York, NY, United States

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

Course Description:

'' This course provides 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.

At Course Completion

At the end of the course, students will be able 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.
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.
Apply tuning techniques to DTS data loads.

Microsoft Certified Professional Exams

This course will help the student prepare for the following Microsoft Certified Professional exam:
There are no exams associated with this course.
...''

Phone:877.SOLARTECH

School Address:

110 Wall Street, Level 2
New York, NY 10004

621 Route 46, Level 2
Hasbrouck Heights, NJ 07604-3118


Jobs & Resumes: New York
Houses & Roommates: New York

Microsoft Solutions Framework Essentials
Microsoft Exchange Server 2007 Hands-on Lab
Designing and Planning an Exchange Server 2003 Organization
Troubleshooting Microsoft Exchange Server 2003
Customizing Microsoft SharePoint Products and Technologies 2003
Enabling Biz Pro. using XML, S Docs, S Client w the MS Office System
Bringing Data into Desktop Programs using the MS Office System 2003 RRT
Microsoft SQL Server 2000 Reporting Services
Office Live Communications Server
Windows 2000 Clustering
Programming with C Sharp
Microsoft Host Integration Server 2000
E-Business Solutions Using Microsoft BizTalk Server 2004
Microsoft Internet Security and Acceleration Server 2000
Active Directory
Windows Storage Server 2003
Windows XP Professional
Windows Server 2003
Windows Server 2003 Active Directory Infrastructure

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.