Description
The Planning an SQL 7.0 Data Warehouse course is the first course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It provides students with an introduction to the core technologies, concepts, architecture, and various features of data warehouses. It also provides students with the preliminary knowledge for planning and implementing data warehouses using SQL Server 7.0. In addition, the course prepares students to take the Microsoft certification Administering Microsoft SQL Server 7.0 (70-019).
Audience
All System Administrators, Help Desk/Support personnel, and Application Developers who design and implement data warehouse solutions by using Microsoft SQL Server 7.0.
Prerequisites
Before taking this course, the user should be familiar with the relational database and data warehousing concepts and terminology and should have an experience in designing database management systems. The user should also have an understanding of Windows NT 4.0 Server and should have a knowledge of basic ANSI statements.
Objective
Upon completion of this course, the student will be able to:
identify the features of a data warehouse
identify the SQL Server features that support data warehousing
list the benefits of using a data warehouse
describe characteristics of data marts
describe the components of a data warehouse
identify different types of data warehouse models that are available
analyze business requirements for creating a data warehouse
describe the process of extracting and loading data in a data warehouse
select a schema design for a relational database
build a database
Topics Include
Introduction to Data Warehousing
- Data Warehousing Fundamentals
- Data Warehouse Architecture
- Quiz
Data Warehouse Models
- Data Warehouse Models
- Data Warehouse Design Plan
- Quiz
Designing a Data Warehouse
- Extracting and Loading Data
- Building a Data Warehouse
- Quiz
Duration
4 hrs
Minimum Requirements
Netscape or Internet Explorer (versions 4.0 or higher). Browsers should be capable of accepting cookies; SVGA Hi-color mode 800x600 resolution display. Macromedia Shockwave 6.02 or higher.
Media
Web Based Training
|
