SQL Server 7 Training Tutorials - e-Learning - Distance Leaning - Self paced - Courses UK

Affordable Online Computer Courses



CCNP Training Pack CCNA Training Pack Cisco Training Pack COMPTIA Certification .NET Training Microsoft MCSE 2003 Microsoft MCSA 2003 Microsoft MCAD Microsoft MCDBA Microsoft MCSD MCDST Training Microsoft Office XP Microsoft Office 2003

Applicability:

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.

Get Certified!
Once you've completed your course, simply book the certification test online with Prometric.com, they have over 3,500 testing centres worldwide, they are also the provider for many of the most sought after professional qualifications, including: MCSE, CompTIA A+ and Cisco CCNA.

"Realistic Simulations"
So you can see how SQL Server 7.0 really works. All Courses also include pre and post-test which identifies individual strengths and weaknesses, allowing you to take only the units you haven't mastered and test how well you've mastered the completed Module.


		The Instant Mentoring window appears directly within your courses. Instant Mentoring allows you to type a question and receive a immediate response from a subject matter expert available 24/7 to help you succeed! MORE...

SQL Server 7 Admin Training




Try a Demo

Usual Price
£~~245~~

Our Price
12 Months Access:
UK:£149
US:$261
Eur:€219


	65%

This series is designed to help users prepare for the MCSE Exam 70-028: Administering Microsoft SQL Server 7.0. The series covers a comprehensive array of topics, including planning a security strategy, SQL Server 7.0 system requirements, planning for system migration and replication, and server installation. System configuration, management of security, accounts, permissions, and the database, and backup and restores are also covered. Additional topics covered include the management of a variety of tasks, including replication, server jobs, events, alerts, linked servers, and remote servers; monitoring events, system optimization, and tuning resource usage. Server repair and troubleshooting strategies are also discussed.

EASY.....start your online training course within the hour
Available 24 hrs/day 7 days/week
High quality Web-based Training / e-Learning
Train ALL YEAR for 1 low price


	Click the "Sign up Button" (above) to sign up for 12 months access to this course or buy our MCDBA Value Pack (this Course plus 8 other courses), if bought separately £~~1,192~~ Value Pack price: Only £299! Save £893 MORE...

SQL Server 7 Admin Modules Outline:

SQL Server 7 Admin- Security Strategy

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

Data File Placement and Space
Capacity Planning

Communication and Backup Strategies
Data Availability

SQL Server 7 Admin- Migration Planning

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

Choosing a Replication Model
Additional Options
Choosing a Replication Type

Designing and Planning Replication
Data Definition Considerations

SQL Server 7 Admin- Installing the Server

Installation Prerequisites
Installing Components
Choosing Database Options

Installing Network Libraries & Protocols
Installing Services and Clients

SQL Server 7 Admin- Other Installations

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

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

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

Viewing ID Information
Viewing Roles
Managing Login IDs

Managing Database IDs and Roles
Server Roles and Management Procedures

SQL Server 7 Admin- Managing Permissions

Permissions
Permission Management Tools
Displaying Permissions Information

Granting and Revoking Permissions
Auditing Server and Database Activity

SQL Server 7 Admin- Database Management

Creating a Database
Managing Database Size

Database Options and Scripts
Managing and Deleting Databases

SQL Server 7 Admin- Loading 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

Introduction to Backups
Database Backups
Differential Backups

Transaction Log Backups
Filegroup Backups
Backing Up System Databases

SQL Server 7 Admin- Managing Replication

Using Replication
Configuring Servers

Creating Publications
Subscribing to Publications

SQL Server 7 Admin- Management Tasks

Configuring the SQL Server Agent
Implementing Jobs
Multiserver Jobs

Managing Server Events
Linked Servers

SQL Server 7 Admin- Monitoring 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

Monitoring Disk I/O Performance
Monitoring CPU and Memory Usage

Other Monitoring Processes
Optimizing Server Performance

SQL Server 7 Admin- Server Repair

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

Troubleshooting Backups and Restores
Troubleshooting the SQL Server Agent
Troubleshooting Jobs and Alerts

Troubleshooting Replication
Linked Server Issues and Recovery Planning

Training Tutorials - e-Learning - Distance Learning - Self paced - Courses