SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4

Course Overview

This is the fourth 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 methods of aggregating and accessing data from relational data structures; identify the methods of data access from multidimensional data structures; identify the features and functionality of Pivot Table Service, Local Cubes, Client/Server Cache; identify the features of MS English Query; and create and deploy an English Query application.

Learn To:

• Identify the methods of aggregating and accessing data from relational data structures.
• Create an MDX.
• Identify the methods of data access from multidimensional data structures.
• Identify the features and functionality of Pivot Table Service, Local Cubes, Client/Server Cache.
• Identify the features of MS English Query.
• Create and deploy an English Query application.

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 three courses in this series.

Total Learning Time

6 - 8 Hour(s)

Course Contents

Unit 1: Data Access: Relational Data Structures

• Retrieve data by using the SELECT statement with a WHERE clause.
• Aggregate data by using the aggregation functions.
• Group the aggregated data by using the GROUP BY keyword.
• Retrieve specific groups of the aggregated data by using the HAVING keyword.
• Calculate totals and subtotals of the groups in the aggregated data by using the ROLLUP keyword.
• Calculate totals and subtotals for all combination of values in the aggregated data by using the CUBE keyword.
• Access data from multiple tables by using Joins.
• Access data by using Subqueries.
• Create views using by using SQL statements.
• Sequence the steps to access data from a remote server.

Unit 2: Data Access: Multidimensional Structures

• Match the components of a multidimensional schema with their descriptions.
• Identify the benefits of MDX SELECT statement as compared to SQL.
• Match the MDX expressions with their examples.
• Match the different methods of axis content specification with their examples.
• Match the keywords for dimension specification with their definitions.
• Match the groups of MDX advanced functions with their members.
• Define the slices of a cube by using MDX.
• Create an MDX by using MDX components.
• Match the ADO MD objects with their properties.
• Match the DDL statements provided in OLE DB for OLAP specifications with their functions.
• Connect to an OLAP database by using ADO MD.
• Read the definition of a cube by using ADO MD.
• Retrieve data from a cube by using ADO MD.
• Display the cube data by using a graph.
• Identify the features of OLE DB for data access.
• Create a DSN for data access by using ODBC Administrator.

Unit 3: Pivot Table Service

Duration: 2 Hour

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

Click here for more information or to take this course