Back to Search Results

Training Course Summary:

This course provides students with the technical skills required to plan, implement, and maintain a data warehouse using Microsoft® SQL Server™ client/server database management system version 7.0.

Pre-Requisites:

• Familiarity with Microsoft SQL Server 7.0.
• Course 832, System Administration for Microsoft SQL Server 7.0, and course 833, Implementing a Database on Microsoft SQL Server 7.0.
• Knowledge of Transact-SQL usage in the development of online transaction processing (OLTP) systems.
• Basic understanding of programming principles (especially experience with a scripting language like Microsoft Visual Basic® Scripting Edition or Microsoft JScript® development software).
• Understanding of basic database design, administration, and implementation concepts.

Training Course Overview/Content:

At Course Completion
At the end of the course, students will be able to:
• Describe basic data warehousing concepts.
• Design a data warehousing system, and implement a database designed with a star schema in SQL Server.
• Gather data from primary data sources, transform it, and place it in a SQL Server staging database.
• Create a cube using OLAP Services.
• Analyze cube data using existing client applications.
• Query cubes using MDX.
• Build custom OLAP clients using ADO MD, OLE DB for OLAP, and DSO.
• Query warehouse data using Microsoft English Query.
• Maintain a SQL Server data warehouse.
• Manage a SQL Server data warehouse.

Qualifications:

This course will help the student prepare for the following Microsoft Certified Professional exam:
• Exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0