Custom Search
Home > Computer > Databases and SQL > Serebra Learning Corporation > Managing MS SQL Server 7.0
Provided by: Serebra Learning Corporation

Managing MS SQL Server 7.0

MS SQL Server

 Serebra Learning Corporation
Training Provided by Serebra Learning Corporation This course provides the student with ways to configure SQL Server and managing data in SQL Server. It also presents ways to manage various administrative tasks. In addition, the course prepares the student to take the Microsoft Certification Administering Microsoft SQL Server 7.0.
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
Click here for more information or to take this course
Managing MS SQL Server 7.0 Course Outline - IP0190 - Managing MS SQL Server 7.0

Managing MS SQL Server 7.0

Course Code IP0190

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 ways to configure SQL Server and managing data in SQL Server.  It also presents ways to manage various administrative tasks.  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. This course would also help IT professionals seeking Microsoft Certified Systems Engineer or Certified Product Specialist status.

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:

  • configure SQL Mail
  • configure default ANSI settings
  • perform full-text search for specific columns and tables
  • create indexes to support full-text search
  • identify the parts of an SQL Server database
  • create an SQL Server database
  • oad data using Bulk Copy Program utility
  • data using BULK INSERT command
  • data using SELECT INTO statements
  • load data using Data Transformation Services
  • describe the process of automated administration
  • create jobs, operators, and alerts
  • plan security requirements for linked servers
  • set up a linked server
  • define components of replication
  • define the process of replication
  • define the replication models
  • define the types of replication
  • configure the publishing distribution, and subscribing servers
  • create a publication for replication
  • create a push subscription
  • create a pull subscription

    • Topics Include

    Configuring SQL Server 7.0

    • Configuring SQL Server Options
    • Configuring Full Text Search Service

    Managing Data

    • Creating Databases
    • Loading Data

    Managing Administrative Tasks

    • Automating Administrative Tasks
    • Managing Linked Servers

    Setting–up Data Replication

    • Planning SQL Server Replication
    • Configuring Data Replication
    • Configuring Subscriptions

    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, 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...
    Click here for more information or to take this course
    Home > Computer > Databases and SQL > Serebra Learning Corporation > Managing MS SQL Server 7.0
    Advertise With Us
    Do you teach administrative ?
    tcw11-gfc-v396M-10/25/09-10:39:44-()[B]-[B]-[A] -04:32:52