SQL Server 7 Admin: System Requirements

Synopsis
SQL Server 7 Admin: System Requirements shows users how to prepare for the hardware needs of a SQL Server 7.0 installation.

Audience
This course is for database administrators who want to learn how to administer SQL Server 7.0 or who are preparing for the MCSE exam 70-028: Administering Microsoft SQL Server 7.0.

Time
3 hours

Product Code: LA7C02

After completing SQL Server 7 Admin: System Requirements the user should be able to:

Plan the physical placement of files including data files and log files

Plan the use of filegroups

Plan for growth over time

Plan the physical hardware system

Assess the server's communication requirements

Choose the appropriate backup and restore strategies

Assess whether to use a standby server

Assess whether to use clustering

Data File Placement and Space
Developing a SQL Server capacity plan

Estimating storage requirements

Capacity Planning
Performance versus fault tolerance

Using software-based RAID solutions

Using hardware-based RAID solutions

Making a choice

Implementing fault tolerance

Communication and Backup Strategies
Communication requirements

Planning communication requirements

Developing a data availability solution

Restoring backups

Data Availability
Benefiting from a standby server

Clustering Microsoft SQL Server 7.0

Clustering fundamentals

This course has the following features:

Exercises that allow users to practice the skills needed to identify system requirements for SQL Server 7.0

A file containing the text of the exercises

Activities that allow users to apply concepts in an interactive questioning environment

A glossary

A Skill Assessment

Courses on Relational Database Management Systems or equivalent experience

Courses on Windows NT administration or equivalent experience

Courses on Database Concepts or equivalent experience

Courses on SQL or equivalent experience

SQL Server 7 Admin: Security Strategy (LA7C01)

Microsoft® is a registered trademark of Microsoft Corporation.

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.