Custom Search

Implementing an MS SQL Server 7.0 Data Warehouse

MS SQL Server

Serebra Learning Corporation
Training Provided by Serebra Learning Corporation This course teaches the student how to design a database and enhance the efficiency of queries by using different types of indexes. It also describes the process of crating files and filegroups and helps students to select an application programming interface for accessing a data source. In addition, the course prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019).
This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Contact Serebra Learning Corporation for more information
Duration:3 hours
Training Presented in:English
Implementing an MS SQL Server 7.0 Data Warehouse Course Outline - IP0280 - Implementing an MS SQL Server 7.0 Data Warehouse

Implementing an MS SQL Server 7.0 Data Warehouse

Course Code IP0280

Contents

  1. Contents
  2. Description
  3. Audience
  4. Prerequisites
  5. Objectives
  6. Topics Include
  7. Duration
  8. Minimum Requirements
  9. Media

Screenshot


click to enlarge

Description

This course teaches the student how to design a database and enhance the efficiency of queries by using different types of indexes.  It also describes the process of crating files and filegroups and helps students to select an application programming interface for accessing a data source. In addition, the course prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019).

Audience

This course is intended for 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

The student should be familiar with the relational database and data warehousing concepts and terminology and should have an experience in designing database management systems. The student 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:

  • describe the design time considerations for a database
  • create files and filegroups for a database
  • identify API considerations for accessing warehouse data
  • select an API for accessing warehouse data
  • describe the various indexing schemes provided by SQL Server 7.0
  • create and optimize indexes
  • identify SQL Server tools used for summarizing data
  • summarize data using aggregate functions in the SELECT statement
  • summarize data using the GROUP BY, WHERE, and HAVING clauses in the SELECT statement
  • summarize data using the CUBE and ROLLUP operators
  • create views for filtering data
  • create joins on tables
  • identify the methods used for importing and exporting warehouse data
  • describe the architecture and working of Data Transformation Services
  • use the DTS Import and Export Wizards to create a DTS package
  • use the DTS Designer to create a custom package

Topics Include

Managing Databases

  • Creating Databases
  • Accessing a Data Source
  • Indexing Tables

Managing Data

  • Summarizing Data
  • Manipulating Data

Populating a Data Warehouse

  • DTS Architecture
  • Using Import Export Tools

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

Serebra Learning Corporation, 1660 - 999 West Hastings, Vancouver, BC    V6C 2W2 Canada
Tel: (604) 676-5480 or 1-800-567-7766 - Fax: (604) 676-5490
E-Mail: sales@serebra.com - Web Site: www.serebra.com
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1, 825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
Want to Sell More data training?
tcw11-gfc-v396M-10/25/09-10:39:41-()[A]-[B]-[A] -04:41:41