 |
 |
|
|
|
 Technical Training - Designing and
Implementing a Data Warehouse Using Microsoft SQL Server 7.0
Course
No: M1502 Course Lengh: 5 Days |
|
Who
Should Attend: This
course is designed for people who are 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).
- Understanding
of basic database design, administration, and implementation concepts.
|
|
|
|
|
| Introduction
to Data Warehousing
- What is data warehousing?
- Data marts and
data warehouses
- The data warehousing
process
- Data in a data
warehouse
Installing
Windows 98 in a Network Environment
- Business analysis
process
- Data warehousing
system
- Modeling a data
warehouse
- Choosing the grain
- Establishing dimensions
- Establishing a
fact table
- Implementing a
star schema
Populating
a Data Warehouse
- Process overview
- Methods of populating
a data warehouse
- Tools for populating
a data warehouse
- Populating a data
warehouse by using DTS
Creating
Cubes
- Introduction to
cubes
- Defining cubes
- Managing access
to cubes
- Demonstration:
using OLAP manager
- Storing cubes
- Processing cubes
- Customizing cubes
Aalyzing
Cube Data Using Clients
- Concepts of data
analysis
- Analyzing local
cubes
- Analyzing data
using the Web
- Tools for analyzing
data
|
Title
- What Is MDX?
- Parts of an MDX
statement
- Writing an MDX
query
Building
OLAP Clients
- Introducing the
OLAP Services architecture
- Analyzing existing
cube metadata
- Creating and populating
a cellset
- Retrieving data
- Creating local
cubes
Building
Applications by Using Microsoft English Query
- Introduction to
English Query
- Database normalization
requirements
- Creating an English
Query application
- Designing an English
Query application for multidimensional databases
- Deploying an English
Query application
Maintaining
a SQL Server Data Warehouse
- Developing a maintenance
plan
- Synchronizing data
- Maintaining SQL
Server data
- Maintaining OLAP
Services data
- Backing up and
restoring databases
- Automating administrative
tasks
- Archiving enterprise
data
Managing
a SQL Server Data Warehouse
- Managing slowly
changing dimensions
- Optimizing your
configuration
- Optimizing your
server configuration
- Optimizing data
warehouse performance
- Optimizing cube
design
- Creating partitions
- Optimizing based
on usage
|
|
|
 |
|
Desktop Courses