MS SQL Server 6.5: Management & Optimization

Outline

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

Description

In this course, students will be presented with a task-based, real-world scenario covering the, administration optimization, troubleshooting of Microsoft SQL Server 6.5. Administration of SQL Server includes managing storage, the setting up user accounts, and assigning permissions. The optimization, configuration, and diagnostics of SQL Server will also be covered.

Audience

This course is designed for system administrators responsible for implementation and maintenance of Microsoft SQL Servers in an enterprise network.

Prerequisites

The student should have a Microsoft Windows NT Server 3.51 course or equivalent , two years experience performing system administration or support in a networked environment and completed the FirstClass Systems course 'MS SQL Server 6.5 – Installation and Administration.

Objective

Manage database storage through the manipulation of a SQL Database Manage user accounts through the creation and administration of group and individual user accounts Manage the security of SQL databases by granting and/or revoking permissions Manage data by performing backup and recovery procedures Identify and implement SQL Server replication Monitor SQL Server performance using Windows NT Performance Monitor Use the SQL Enterprise Manage to monitor server activity Monitor and configure server memory for optimum performance Troubleshoot system errors related to database configuration and SQL Server optimization

Topics Include

Managing SQL Databases

• Manage User Account: Examine Security Levels
• Examine Types of Security
• Create a Group
• Create a Login ID
• Manage Users
• Use Integrated Security Groups
• Utilize SQL Security Strategies
• Assign User Permissions
• Examine Permissions
• Assign Statement Permissions
• Assign Object Permissions
• Supplement Security Strategies
• Examine Ownership Chains
• Explore Backup and Recovery
• Formulated a Data Backup Plan
• Create Backup Devices
• Perform a Database Backup
• Perform a Transaction Log Backup
• Explore Backup Types
• Examine Recovery Methods
• Restore a Database
• Examine Data Transfer Tools
• Examine TMI
• Examine the Bulk Copy Program
• Troubleshoot SQL Databases: Recover from Media Failure
• Recreate a Lost Device
• Restore a Corrupted Database

Exploring Replication

• Examine Replication: Choose a Distributed Data Option
• Examine SQL Replication
• Examine the Replication Process
• Choose a Replication Scenario
• Examine Replication Options
• Implement Replication: Configure Server for Replication
• Enable Distributing
• Enable Publishing
• Create a Publication
• Set Synchronization
• Secure a Publication
• Enable Subscribing
• Define Subscriptions
• Trace the Replication Process
• Troubleshoot SQL Data: Examine Replication Setup

Resolve Fault-tolerance Problems

• Optimize SQL Server
• Administer Client Networking: Set Network Protocols
• Use Extended Stored Procedures
• Optimize Microsoft SQL Server: Examine Performance Factors
• Use the Performance Monitor
• Examine Memory Configurations
• Allocate SQL Server Memory
• Set Procedure Cache Configuration
• Use DBCC MEMUSAGE
• Examine the tempdb RAM Option
• Configure Lock Values
• Monitor Log Space
• Set Database Options
• Set Data Maintenance Tasks
• Troubleshoot SQL Server: Resolve Network Error Messages
• Resolve Memory Allocation Errors
• Resolve System Configuration Errors

Duration

3 hrs

Minimum Requirements

IBM 486 Compatible PC; VGA color monitor (256 colors); 8 MB RAM; 20 MB hard disk space; MS Windows 3.x/Windows 95 or Windows NT 3.5 x/4.x; IBM 0S/2, Microsoft Mouse, 3.5 inch diskette drive.

Media

Diskette
CDROM
Web Based Training

© Copyright Serebra Learning Corp., 2002