SQL Server 7 Admin: Installing the Server

Synopsis
SQL Server 7 Admin: Installing the Server shows users how to go through the installation process for servers and clients.

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
4 hours

Product Code: LA7C05

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

Install the SQL Server 7.0 prerequisites

Install the SQL Server 7.0 Database Server component

Choose an appropriate character set Unicode collation sequence and sort order

Install network libraries and protocols

Install the SQL Server 7.0 services and the appropriate startup options

Install and configure the SQL Server 7.0 client software on client machines

Installation Prerequisites
Installation overview

System requirements

Installing SQL Server 7.0 Main Setup Screen

Installing prerequisite components

Installing Components
Installing the Database Server component

Database Server component levels

Using the Database Server Setup wizard

Installing OLAP and English Query

Choosing Database Options
Choosing a character set

Choosing the appropriate sort order

Choosing the Unicode collation sequence

Installing Network Libraries & Protocols
Choosing Net-Libraries

Named pipes

TCP/IP sockets

Multi-protocol

NWLink IPX/SPX

AppleTalk ADSP

Banyan VINES

The Shared Memory Net-Library

Network library overview

Installing Services and Clients
Installing services

Completing server installation

Installing and configuring SQL Server clients

This course has the following features:

Exercises that allow users to practice the skills needed to install SQL Server 7.0

A file containing the text of the exercises

Simulations that allow users to practice course skills even if they don't have access to SQL Server 7.0

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)

SQL Server 7 Admin: System Requirements (LA7C02)

SQL Server 7 Admin: Migration Planning (LA7C03)

SQL Server 7 Admin: Replication Plans (LA7C04)

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.