SQL Server 7 Admin Series
Total Time: 62 hours

Includes 12 months unlimited access (1 user) to ALL of the courses listed below:

StaffKit provides one of the largest online e-learning libraries of training material available anywhere. Our online training is accessible 24 hours a day, 7 days a week -- no downloads or CD's to install. You have UNLIMITED ACCESS to the courses for a full 12 Months! Access your training account from work, home, Anywhere you can access the internet.

100% Satisfaction Money Back Guarantee.

Why is our courseware superior to CD, Video or Classroom training?
Skill Assessment Testing.
Online Simulations.
Print Certificates.
An extensive Online Glossary
12 months FREE access to any updates
Search ability on the complete course material
Unlimited testing with the ability to view your score anytime.
Search the entire course library on any single or group of keywords
Earn CEU's (Continuing Education Units) that are nationally recognized

A great learning tool.
A great reference tool.

Includes 1 year unlimited access (1 user) to all courses listed below:

SQL Server 7 Admin: Security Strategy Time: 3 hours LA7C01
SQL Server 7 Admin: Security Strategy 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

SQL Server 7 Admin: System Requirements Time: 3 hours LA7C02
SQL Server 7 Admin: System Requirements 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

SQL Server 7 Admin: Migration Planning Time: 3 hours LA7C03
SQL Server 7 Admin: Migration Planning 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

SQL Server 7 Admin: Replication Plans Time: 3 hours LA7C04
SQL Server 7 Admin: Replication Plans 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

SQL Server 7 Admin: Installing the Server Time: 4 hours LA7C05
SQL Server 7 Admin: Installing the Server shows users how to go through the installation process for servers and clients.
  • Installation Prerequisites
  • Installing Components
  • Choosing Database Options
  • Installing Network Libraries & Protocols
  • Installing Services and Clients

SQL Server 7 Admin: Other Installations Time: 2 hours LA7C06
SQL Server 7 Admin: Other Installations 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

SQL Server 7 Admin: Configuring Time: 3 hours LA7C07
SQL Server 7 Admin: Configuring 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

SQL Server 7 Admin: Security Management Time: 4 hours LA7C08
SQL Server 7 Admin: Security Management 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

SQL Server 7 Admin: Managing Accounts Time: 3 hours LA7C09
SQL Server 7 Admin: Managing Accounts 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

SQL Server 7 Admin: Managing Permissions Time: 4 hours LA7C10
SQL Server 7 Admin: Managing Permissions 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

SQL Server 7 Admin: Database Management Time: 3 hours LA7C11
SQL Server 7 Admin: Database Management shows users how to create and maintain SQL server databases.
  • Creating a Database
  • Managing Database Size
  • Database Options and Scripts
  • Managing and Deleting Databases

SQL Server 7 Admin: Loading Databases Time: 3 hours LA7C12
SQL Server 7 Admin: Loading Databases 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

SQL Server 7 Admin: Backups and Restores Time: 4 hours LA7C13
SQL Server 7 Admin: Backups and Restores 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

SQL Server 7 Admin: Managing Replication Time: 3 hours LA7C14
SQL Server 7 Admin: Managing Replication shows users how to create and administer database replication.
  • Using Replication
  • Configuring Servers
  • Creating Publications
  • Subscribing to Publications

SQL Server 7 Admin: Management Tasks Time: 3 hours LA7C15
SQL Server 7 Admin: Management Tasks 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

SQL Server 7 Admin: Monitoring Events Time: 3 hours LA7C16
SQL Server 7 Admin: Monitoring Events 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

SQL Server 7 Admin: Watching & Optimizing Time: 3 hours LA7C17
SQL Server 7 Admin: Watching & Optimizing 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

SQL Server 7 Admin: Server Repair Time: 4 hours LA7C18
SQL Server 7 Admin: Server Repair 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

SQL Server 7 Admin: More Troubleshooting Time: 4 hours LA7C19
SQL Server 7 Admin: More Troubleshooting 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

Get more out of your Software
Improve your Skills
Prepare for Certification
Save time every time and reduce frustration.

Our online training material lets you:
TEST your skills
LIST the areas where you need additional training
Take lessons that TEACH SKILLS to improve these areas
Tests your skills again

NO HIDDEN CHARGES.
NO SETUP or SHIPPING CHARGES.
NO ads or banners in the training material.
No selling of your personal information, no email lists.
Just 100% Quality Training at one low price.

Repeat the courses as often as you need, you have 12 months of unlimited access and can view your scores anytime so you can easily track your progress.

Our training is tested and guaranteed to provide RESULTS and save you TIME.

All courseware is online 24 hours a day.
Our courseware is optimized so content delivery is fast even with a 28.8 modem connection.
If you can get on the Internet you can access the training, ANYWHERE, ANYTIME.

Home | Training | Products | Specials | Tips | Resources
Copyright © 2001 - 2003 StaffKit, Inc.
All Rights Reserved.