Training
Provided by 123-CBT Computer Based Training
Course Overview This is the second course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the design characteristics of OLAP systems and Aggregate schemas; identify the data warehouse models; identify the Data Transformation Services (DTS) components and the components of the DTS object model; identify the methods of distributing data; and identify the replication types and techniques. Learn To: - Identify the design characteristics of OLAP systems and Aggregate schemas.
- Identify the data warehouse models.
- Identify the Data Transformation Services (DTS) components and the components of the DTS object model.
- Identify the methods of distributing data.
- Identify the replication types and techniques.
Content Emphasis Skills-Based Audience This course series is designed for IT professionals responsible for planning, implementing, and maintaining a data warehouse using Microsoft SQL Server client/server database management system version 7.0. This series will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. It is recommended that participants take NETg course series 72470-72474, Microsoft SQL Server 7.0: System Administration and course series 72475-72479, Microsoft SQL Server 7.0: Implementing a Database or have equivalent knowledge and have completed the first course in this series. Total Learning Time 6 - 8 Hour(s) Course Contents Unit 1: OLAP Systems Duration: 1 - 2 Hour(s) - Identify the reasons why OLTP systems are inadequate for decision support.
- Identify the OLAP Services features.
- Identify the features of the OLAP Services architecture.
- Match the activities in building an OLAP Data Warehouse with the tasks involved in the activities.
- Identify the advantages of aggregation.
- Select the most appropriate table to answer a given user query.
- Identify the design issues that are relevant for the design of cubes, base tables, fact tables and dimension tables.
Unit 2: The Data Warehousing Process Duration: 1 - 2 Hour(s) - Identify the features of an enterprise data warehouse.
- Identify the situations in which you will use a data mart.
- Identify the features of an operational data store.
- Identify the features of a combination model.
- Match the logical components in a data warehouse framework with their function.
- Identify the design considerations for a data warehouse.
- Identify the activities in designing a data warehouse.
- Identify the factors that determine the frequency with which a data warehouse is refreshed.
- Identify the factors that determine the frequency with which a data warehouse is archived.
- Identify the factors that need to be considered to filter data in a data warehouse.
- Identify the features of the architectural approaches for data warehouse design.
- Identify the solution that meets the design requirements of a data warehouse for a given scenario.
- Identify the factors that determine the feasibility of implementing data warehouse architecture.
- Identify the reason based on which you will decide to use relational or multidimensional storage for a data warehouse.
- Match the approaches to data warehouse storage design with their descriptions.
- Identify the features of the elements in a star schema design.
- Identify the features of the dimensional models in dimensional modeling.
- Match e
Training Avaliability and Delivery
| This is primarily online training |  | This is an online eLearning or CBT training program |  | This program may be available on CD |  | Contact 123-CBT Computer Based Training for more information |
|
| Training Presented in: | English |
|
Related Keywords:
microsoft
sql
server
7.0
designing
implementing
data
warehouses
part
Training Program Details
--
About 123-CBT Computer Based Training - Training Provider
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6.10
- Access 2003
- Acrobat 6.0
- ASP
- ASP.NET
- C
- Captivate 1.0
- Crystal Reports 8.5
- Crystal Reports v10
- Dreamweaver MX
-...
More Microsoft SQL Server 7 0 Training from 123-CBT Computer Based Training
Click here for more information or to take this course
|
