Training Classes | Learning and Development Resources | Training Directory | New Training Seminars | New Training Providers | Site Map | Promote Training Seminars | Training Keywords | Training Seminars | Training Providers | Regions | Training Search | Advertise Training Seminars | Login
Provided by: Serebra Learning Corporation

Implementing MS SQL Server 7.0

Click here for more information or to take this course
Serebra Learning Corporation


  home  : Computer  : Databases and SQL  : MS SQL Server

Get More Information
Search for Training
Find Your Genius!
What do you want to learn about?

Training Provided by Serebra Learning Corporation

This course provides the student with an introduction to the core technologies, architecture, and various features of Microsoft SQL Server 7.0. It also provides the student with the preliminary knowledge and skills required for planning and installing SQL Server 7.0. In addition, the course prepares the student to take the Microsoft Certification Administering Microsoft SQL Server 7.0.

Training Avaliability and Delivery

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
Schedule:3 hours
Training Presented in:English

Related Keywords:  server   sql   microsoft   student   implementing   sql   server 

Training Program Details


Course Outline - IP0180 - Implementing MS SQL Server 7.0

Implementing MS SQL Server 7.0

Course Code IP0180

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 provides the student with an introduction to the core technologies, architecture, and various features of Microsoft SQL Server 7.0.  It also provides the student with the preliminary knowledge and skills required for planning and installing SQL Server 7.0.  In addition, the course prepares the student to take the Microsoft Certification Administering Microsoft SQL Server 7.0.

Audience

This course is intended for all System Administrators, Help Desk/Support personnel, and Application Developers who implement a database solution with Microsoft SQL Server client/server database management system.

Prerequisites

The student should be familiar with the relational database 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:

  • identify the features of SQL Server 7.0
  • identify the advantages of integrating SQL Server with Windows NT Server and Microsoft BackOffice
  • identify the elements of the client/server architecture for SQL Server 7.0
  • identify the elements of the database architecture for SQL Server 7.0
  • identify the elements of the SQL Distributed Management Framework
  • identify the features of Transact-SQL
  • develop a plan for data storage in SQL Server
  • plan the use of filegroups
  • plan data migration
  • use the Import and Export Wizards to migrate data
  • identify the hardware and software requirements for SQL Server 7.0 installation
  • identify the communication requirements for SQL Server 7.0 installation
  • identify the Windows NT Server 4.0 configuration features that are essential for SQL Server 7.0 installation
  • install SQL Server install SQL client utilities
  • perform an unattended setup
  • plan an upgrade from a previous version of SQL Server
  • upgrade from a previous version

Topics Include

Introduction to SQL Server

  • SQL Server Fundamentals
  • SQL Server Architecture

Planning SQL Server Implementation

  • Planning Data Storage
  • Planning Data Migration

Setting up SQL Server 7.0

  • Preparing for Installation
  • Installing SQL Server
  • Upgrading SQL Server

Duration

3 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, 600 - 1188 West Georgia, Vancouver, BC    V6E 4A2 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 Serebra Learning Corporation - Training Provider

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...

More Training from Serebra Learning Corporation

Click here for more information or to take this course

Training Directory | New Training Seminars | New Training Providers | Search | Site Map | Promote Training | Login | Links


Connecting people who want to learn with people who love to teach
 Are you a Server training provider?
You could be on this page today - for FREE!