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.

 

© 1999-2004 SK Max. All rights reserved.

General IT

Web Design

Microsoft Certs

Desktop Computing

Business Skills

Personal Skills

Combo Packages

Business Videos

Articles

Features

Instant Mentoring

Benefits

FAQs

HTML

A+

Windows 2000

Excel 2000

Office 2000

More Courses

e-Learning Links

e-Learning Forum

Certification Info

Other Resources

Home PageContact InformationSearch the Site
HomeOur Course Cataloge-Learning EdgeFree CoursesStudent Centere-ResourcesCorporate Information