Learn how to install and configure a SQL 2000 Server, create SQL 2000 databases, manage, monitor and troubleshoot SQL 2000 databases, extract and transform data and manage and monitor SQL 2000 security.
Price: excl. VAT
Level 1
1.0 Introduction
1.1 Topic Overview
1.2 Transactional vs. Analytical Data Systems
1.3 Data Warehouse Defined
1.4 Data Warehouses vs. Data Marts/OLAP
2.0 Dimensional Modeling & Planning
2.1 Entity-Relationship modeling vs. Dimensional modeling
2.2 Elements of the Dimensional model
2.3 The Role of User Requirements
2.4 Identifying Source data
34 Implementing the Data Warehouse Bus
3.0 Planning Facts
3.1 What is a fact?
3.2 Measures
4.0 Planning Dimensions
4.1 Planning a Hierarchy
Level 2
1.0 Building a Data Mart
1.1 Creating the Database
1.2 Creating the Fact Table
1.3 Creating Dimension Tables
1.4 Creating Constraints and indexes
2.0 Loading the Data-Mart
2.1 Using Staging Tables
2.2 Using Transact SQL for Data Migration
2.3 Loading Data using Data Transformation Services
excellent:
"The CBT product is easy to use and an excellent combination of reading material, video on CD and interactive labs. " thank you :
"Thank you! i have received the complete order today.
thank you for your swift service and i hope to be in touch soon with regards further training.
Once again thank you very much" glad:
"I am glad to report that the CBT packages arrived successfully.
I really appreciate all the help and assistance you gave me since my initial enquiry with yourselves"
