Synopsis
SQL Server 7 Admin: Configuring shows users how to configure SQL server and its services.

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: LA7C07
After completing SQL Server 7 Admin: Configuring the user should be able to:

Register a server with a SQL Server network
Configure Microsoft SQL Server 7 including installing and configuring SQL Mail and configuring the default ANSI settings
Install and configure the Full-Text Search service including enabling Full-Text Search on specific columns and tables and creating and managing indexes to support Full-Text Search

Using the Register Server Wizard
Registering servers
Registration Wizard: step by step
Registering without the wizard

Configuring the Server
Changing the sa password
Managing the server configuration

Configuring SQL Mail and ANSI Settings
Using SQL Server Mail
Configuring SQL Mail
Configuring default ANSI settings

Installing the Full-Text Search Service
Using the Full-Text Search Service (FTS)
Installing the Full-Text Search Service
Configuring Full-Text Service properties

Configuring the Full-Text Search Service
Enabling Full-Text Search Service
Using the Full-Text Indexing Wizard
Confirming the process

This course has the following features:

Exercises that allow users to practice in 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)
SQL Server 7 Admin: Installing the Server (LA7C05)
SQL Server 7 Admin: Other Installations (LA7C06)

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.


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