Learn Online with StaffKit Training Courses
Online Employee Business and Computer Training

Microsoft SQL Server 7 Admin Training


Summary:

This series is designed to help users understand a comprehensive array of topics, including planning a security strategy, SQL Server 7.0 system requirements, planning for system migration and replication, and server installation. System configuration, man

This Microsoft SQL Server 7 Admin online training series provides over 60 hours of self-paced courseware. This web-based training provides 6 months of unlimited access to all of the following lessons:

1 . Backups and Restores
2 . Configuring
3 . Database Management
4 . Installing the Server
5 . Loading Databases
6 . Management Tasks
7 . Managing Accounts
8 . Managing Permissions
9 . Managing Replication
10 . Migration Planning
11 . Monitoring Events
12 . More Troubleshooting
13 . Other Installations
14 . Replication Plans
15 . Security Management
16 . Security Strategy
17 . Server Repair
18 . System Requirements
19 . Watching and Optimizing

Lesson Detail:

Backups and Restores
This course shows users how to back up and restore data on SQL Servers.


  • Introduction to Backups
  • Database Backups
  • Differential Backups
  • Transaction Log Backups
  • Filegroup Backups
  • Backing Up System Databases

Configuring
This course shows users how to configure SQL server and its services.


  • Using the Register Server Wizard
  • Configuring the Server
  • Configuring SQL Mail and ANSI Settings
  • Installing the Full-Text Search Service
  • Configuring the Full-Text Search Service

Database Management
This course shows users how to create and maintain SQL server databases.


  • Creating a Database
  • Managing Database Size
  • Database Options and Scripts
  • Managing and Deleting Databases

Installing the Server
This course shows users how to go through the installation process for servers and clients.


  • Installation Prerequisites
  • Installing Components
  • Choosing Database Options
  • Installing Network Libraries and Protocols
  • Installing Services and Clients

Loading Databases
This course shows users how to load data from other sources into SQL Server databases.


  • The INSERT and SELECT INTO Statements
  • Bulk Copying Data
  • Importing and Exporting Data with DTS
  • Managing DTS Packages

Management Tasks
This course shows users how to manage a variety of administrative tasks, including server jobs, events, alerts, linked servers, and remote servers.


  • Configuring the SQL Server Agent
  • Implementing Jobs
  • Multiserver Jobs
  • Managing Server Events
  • Linked Servers

Managing Accounts
This course shows users how to administer login IDs, Database IDs, and roles.


  • Viewing ID Information
  • Viewing Roles
  • Managing Login IDs
  • Managing Database IDs and Roles
  • Server Roles and Management Procedures

Managing Permissions
This course shows users how to administer permissions and monitor server and database activity.


  • Permissions
  • Permission Management Tools
  • Displaying Permissions Information
  • Granting and Revoking Permissions
  • Auditing Server and Database Activity

Managing Replication
This course shows users how to create and administer database replication.


  • Using Replication
  • Configuring Servers
  • Creating Publications
  • Subscribing to Publications

Migration Planning
This course shows users how to migrate data from other sources into a SQL Server 7.0 installation.


  • Planning an Upgrade
  • Upgrade Method and Upgrade Wizard
  • Migration Issues
  • Migrating Data from Other Sources
  • Using the Import Wizard

Monitoring Events
This course shows users how to monitor and trace engine events.


  • Introduction to Monitoring
  • Understanding Trace Architecture
  • Creating Traces with the Trace Wizard
  • Creating Traces with Other Tools
  • Managing Traces
  • Analyzing Traces

More Troubleshooting
This course shows users how to resolve problems with database management and linked server issues.


  • Troubleshooting Backups and Restores
  • Troubleshooting the SQL Server Agent
  • Troubleshooting Jobs and Alerts
  • Troubleshooting Replication
  • Linked Server Issues and Recovery Planning

Other Installations
This course shows users how to perform unattended setups or upgrade from a previous version of SQL Server.


  • Performing an Unattended Setup
  • Preparing for a Version 6.x Upgrade
  • Running the SQL Server Upgrade Wizard
  • Completing the Upgrade

Replication Plans
This course shows users how to develop a strategy for system replication.


  • Choosing a Replication Model
  • Additional Options
  • Choosing a Replication Type
  • Designing and Planning Replication
  • Data Definition Considerations

Security Management
This course shows users how to assign access and roles to server users and databases.


  • Overview of SQL Server Security
  • Security Modes
  • Creating and Managing Logins
  • Database User IDs and Roles
  • Using the Create Login Wizard

Security Strategy
This course shows users how to plan the security policies for a SQL Server 7 installation.


  • SQL Server Authentication Methods
  • Using Windows NT Groups
  • Planning the Use of SQL Server Roles
  • Developing a Security Strategy
  • Other Security Issues

Server Repair
This course shows users how to troubleshoot problems with installation upgrading and access to servers.


  • Overview of Troubleshooting
  • Solving Installation Problems
  • Solving Upgrading Problems
  • More About Upgrading Problems
  • Troubleshooting Server Access Problems
  • Troubleshooting SQL Server Permissions

System Requirements
This course shows users how to prepare for the hardware needs of a SQL Server 7.0 installation.


  • Data File Placement and Space
  • Capacity Planning
  • Communication and Backup Strategies
  • Data Availability

Watching and Optimizing
This course shows users how to monitor and tune resource usage by SQL Server.


  • Monitoring Disk I/O Performance
  • Monitoring CPU and Memory Usage
  • Other Monitoring Processes
  • Optimizing Server Performance

Certification:
Microsoft SQL Server 7 Admin


Audience:
This series is for database administrators who want to learn how to administer SQL Server 7.0.


Features:

  • Activities that allow users to apply course concepts in an interactive questioning environment.
  • Exercises allow learners to practice in the actual application being studied.
  • A file containing the text of the exercises.
  • A glossary provides a reference for definitions of unfamiliar terms.
  • A skill assessment generates a customized learning path based on the results of a pre-test.

Technical Requirements:


What You Get:

You will receive Unlimited Access to all of the Microsoft SQL Server 7 Admin training tutorials listed above. Your online training courses will be available from anywhere you have internet access.This e-learning series includes all of the online training tutorials listed and is provided in an interactive, self-paced format. Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 6 months of unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.


Web-Based Training Products:


Microsoft SQL Server 7 Admin Online Training Series

Only $99.95    staffkit

You might also be interested in our Microsoft Certifications Package which includes all of the Microsoft SQL Server 7 Admin training courses listed above plus hundreds of hours of related online training courses

 

Microsoft Certifications Package

Only $249.95   staffkit

Microsoft SQL Server 7 Admin
Training Series
Total Courses: 19
Total Time: 60+ hours
$119.99
Only $99.95
Available in Package only
Total Courses: 829
Total Time: 1776+ hours
$499.99
Only $249.95
Satisfaction Guaranteed    BBB Online Accredited Business          Fruad Protection Guaranteed By American Express            Paypal World Seller

Reviews:

'offers employers an excellent way to train their staff economically and without having to send them out of the office.'
HRMReport.com

'this is a must have resource'
California Technology Magazine

'this is theUltimate
Career Development
Package.'
MidWest Technology Journal

Read more customer
reviews about our
e-learning training tutorials

StaffKit offers a centralized e-learning solution for business, computer, technical, compliance and employee training.
Copyright © 2001-2014 StaffKit All Rights Reserved