Microsoft SQL Server 7 Admin

SQL Server 7 Admin online training courses
Total Courses: 19    Estimated Training Time: 60 Hour(s)

Summary

1 Year Unlimited access to all 19 courses listed below, includes over 60 hours of online courseware.

This series is designed to help users understand 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.

Current Price: $59.95 | List Price: $119.99

This Microsoft SQL Server 7 Admin online training series provides 60 hours of self-paced courseware. This web-based training provides 1 year of unlimited access to all of the following lessons:

  1. Security Strategy
  2. System Requirements
  3. Migration Planning
  4. Replication Plans
  5. Installing the Server
  6. Other Installations
  7. Configuring
  8. Security Management
  9. Managing Accounts
  10. Managing Permissions
  11. Database Management
  12. Loading Databases
  13. Backups and Restores
  14. Managing Replication
  15. Management Tasks
  16. Monitoring Events
  17. Watching and Optimizing
  18. Server Repair
  19. More Troubleshooting

Lesson Detail:

  • Microsoft SQL Server 7 Admin: Security Strategy
    This course shows users how to plan the security policies for a SQL Server 7 installation.

    • SQL Server Authentication Methods
    • Using Windows NT Groups
    • Planning the Use of SQL Server Roles
    • Developing a Security Strategy
    • Other Security Issues

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

    • Data File Placement and Space
    • Capacity Planning
    • Communication and Backup Strategies
    • Data Availability

  • Microsoft SQL Server 7 Admin: Migration Planning
    This course shows users how to migrate data from other sources into a SQL Server 7.0 installation.

    • Planning an Upgrade
    • Upgrade Method and Upgrade Wizard
    • Migration Issues
    • Migrating Data from Other Sources
    • Using the Import Wizard

  • Microsoft SQL Server 7 Admin: Replication Plans
    This course shows users how to develop a strategy for system replication.

    • Choosing a Replication Model
    • Additional Options
    • Choosing a Replication Type
    • Designing and Planning Replication
    • Data Definition Considerations

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

    • Installation Prerequisites
    • Installing Components
    • Choosing Database Options
    • Installing Network Libraries and Protocols
    • Installing Services and Clients

  • Microsoft SQL Server 7 Admin: Other Installations
    This course shows users how to perform unattended setups or upgrade from a previous version of SQL Server.

    • Performing an Unattended Setup
    • Preparing for a Version 6.x Upgrade
    • Running the SQL Server Upgrade Wizard
    • Completing the Upgrade

  • Microsoft SQL Server 7 Admin: Configuring
    This course shows users how to configure SQL server and its services.

    • 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

  • Microsoft SQL Server 7 Admin: Security Management
    This course shows users how to assign access and roles to server users and databases.

    • Overview of SQL Server Security
    • Security Modes
    • Creating and Managing Logins
    • Database User IDs and Roles
    • Using the Create Login Wizard

  • Microsoft SQL Server 7 Admin: Managing Accounts
    This course shows users how to administer login IDs, Database IDs, and roles.

    • Viewing ID Information
    • Viewing Roles
    • Managing Login IDs
    • Managing Database IDs and Roles
    • Server Roles and Management Procedures

  • Microsoft SQL Server 7 Admin: Managing Permissions
    This course shows users how to administer permissions and monitor server and database activity.

    • Permissions
    • Permission Management Tools
    • Displaying Permissions Information
    • Granting and Revoking Permissions
    • Auditing Server and Database Activity

  • Microsoft SQL Server 7 Admin: Database Management
    This course shows users how to create and maintain SQL server databases.

    • Creating a Database
    • Managing Database Size
    • Database Options and Scripts
    • Managing and Deleting Databases

  • Microsoft SQL Server 7 Admin: Loading Databases
    This course shows users how to load data from other sources into SQL Server databases.

    • The INSERT and SELECT INTO Statements
    • Bulk Copying Data
    • Importing and Exporting Data with DTS
    • Managing DTS Packages

  • Microsoft SQL Server 7 Admin: Backups and Restores
    This course shows users how to back up and restore data on SQL Servers.

    • Introduction to Backups
    • Database Backups
    • Differential Backups
    • Transaction Log Backups
    • Filegroup Backups
    • Backing Up System Databases

  • Microsoft SQL Server 7 Admin: Managing Replication
    This course shows users how to create and administer database replication.

    • Using Replication
    • Configuring Servers
    • Creating Publications
    • Subscribing to Publications

  • Microsoft SQL Server 7 Admin: Management Tasks
    This course shows users how to manage a variety of administrative tasks, including server jobs, events, alerts, linked servers, and remote servers.

    • Configuring the SQL Server Agent
    • Implementing Jobs
    • Multiserver Jobs
    • Managing Server Events
    • Linked Servers

  • Microsoft SQL Server 7 Admin: Monitoring Events
    This course shows users how to monitor and trace engine events.

    • Introduction to Monitoring
    • Understanding Trace Architecture
    • Creating Traces with the Trace Wizard
    • Creating Traces with Other Tools
    • Managing Traces
    • Analyzing Traces

  • Microsoft SQL Server 7 Admin: Watching and Optimizing
    This course shows users how to monitor and tune resource usage by SQL Server.

    • Monitoring Disk I/O Performance
    • Monitoring CPU and Memory Usage
    • Other Monitoring Processes
    • Optimizing Server Performance

  • Microsoft SQL Server 7 Admin: Server Repair
    This course shows users how to troubleshoot problems with installation upgrading and access to servers.

    • Overview of Troubleshooting
    • Solving Installation Problems
    • Solving Upgrading Problems
    • More About Upgrading Problems
    • Troubleshooting Server Access Problems
    • Troubleshooting SQL Server Permissions

  • Microsoft SQL Server 7 Admin: More Troubleshooting
    This course shows users how to resolve problems with database management and linked server issues.

    • Troubleshooting Backups and Restores
    • Troubleshooting the SQL Server Agent
    • Troubleshooting Jobs and Alerts
    • Troubleshooting Replication
    • Linked Server Issues and Recovery Planning

Certification

Microsoft SQL Server 7 Admin

Audience

This series is for database administrators who want to learn how to administer SQL Server 7.0.

Features

  • Activities that allow users to apply course concepts in an interactive questioning environment.
  • Exercises allow learners to practice in the actual application being studied.
  • A file containing the text of the exercises.
  • A glossary provides a reference for definitions of unfamiliar terms.
  • A skill assessment generates a customized learning path based on the results of a pre-test.

Technical Requirements

  • Internet connection
  • Browser: Internet Explorer, FireFox, Chrome, Safari, Opera or any standards compliant browser.
  • Authorware and Macromedia Flash player recommended but not required.
  • JavaScript must be enabled.

What You Get

You will receive Unlimited Access to all of the Microsoft SQL Server 7 Admin training tutorials listed above. Your online training courses will be available from anywhere you have internet access.This e-learning series includes all of the online training tutorials listed and is provided in an interactive, self-paced format. Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 1 year unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.

StaffKit is an e-learning leader in providing computer training tutorials and online education. We have satisifed online learning customers in over 50 countries. We have been providing web based training for the past 9 years.

Web-Based Training Products

You might also be interested in our Microsoft Certifications Package which includes all of the Microsoft SQL Server 7 Admin training courses listed above plus over 749 hours related training courses

Microsoft Certifications

Learn the latest in technical Microsoft topics and help prepare for the MCTS, MCITP, and MCSE core and elective exams required to earn Microsoft certifications.

81 Series

Price: $149.95