Custom Search

Managing MS SQL Server 7.0 Security

MS SQL Server

Serebra Learning Corporation
Training Provided by Serebra Learning Corporation This course enables the student to plan a backup and restoration strategy for preventing data loss. It also provides the student with an introduction to SQL security concepts and the security accounts used by SQL Server. In addition, the course prepares the student to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-028).
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
Managing MS SQL Server 7.0 Security Course Outline - IP0200 - Managing MS SQL Server 7.0 Security

Managing MS SQL Server 7.0 Security

Course Code IP0200

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 enables the student to plan a backup and restoration strategy for preventing data loss.  It also provides the student with an introduction to SQL security concepts and the security accounts used by SQL Server.  In addition, the course prepares the student to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-028).

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:

  • back up system and user databases describe the role of a standby server
  • plan a restore strategy for backing up data
  • restore a database
  • describe the authentication modes used by SQL Server
  • define a strategy for securing database access
  • grant login access to an SQL Server for a Windows NT user or group
  • grant access to an SQL Server database for a Windows NT user or group
  • create SQL Server roles grant statement and object permissions to database users and roles
  • define an application security strategy using application roles
  • define an application security strategy using Transaction Server

Topics Include

Preventing Data Loss

  • Backing-up SQL Data
  • Restoring SQL Data

Securing SQL Security

  • Introducing SQL Security
  • Configuring Security Accounts

Advanced Security Issues

  • Managing Database Security
  • Managing Application Security

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...
Sell managing training?
tcw11-gfc-v396M-10/25/09-10:39:44-()[B]-[B]-[B] -04:01:58