computer training image
Online Training Classes Purchased Securely
Shopping cart  Shopping cart
0 Product(s) in cart
Total $0.00
> Checkout
Online Payments

Benefits of Computer Coach's online computer training classes

  • Accessible 24 hours a day 7 days a week, so you can learn when you have time.
  • Cost-effective solutions, so you don’t go broke learning the skills you need.
  • Available Anytime, anywhere with an Internet connection, so you can study at your house, office, or where you feel comfortable.
  • Interactive & fun courses allow for greater retention of course topics.
  • Easy to use so you can start learning right away.
  • Full of hands-on labs so you can get the practice you need
  • HTML Based so you don’t need any additional downloads
  • Live Mentor Available to ask questions and get clarification

online computer training questions answered

SQL Server 7 Admin Online Course

12 Month Subscription - $70
Live Mentor +$30

This online class will teach you how to Administer SQL Server 7. This course is interactive and has hands-on activities. Enroll today!

Summary:
This series is designed to help users learn how to Administer 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.

Audience:
This series 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.

Features:
●  Exercises that allow users to practice the application
●  A file containing the text of the exercises
●  Activities that allow users to apply course concepts in an interactive questioning environment
●  A glossary
●  A Skill Assessment

What you learn in this SQL Server 7 course:
SQL Server 7 Admin : Security Strategy
SQL Server 7 Admin : System Requirements
SQL Server 7 Admin: Migration Planning
SQL Server 7 Admin : Replication Plans
SQL Server 7 Admin : Installing the Server
SQL Server 7 Admin : Other Installations
SQL Server 7 Admin : Configuring
SQL Server 7 Admin : Security Management
SQL Server 7 Admin : Managing Accounts
SQL Server 7 Admin : Managing Permissions
SQL Server 7 Admin : Database Management
SQL Server 7 Admin : Loading Databases
SQL Server 7 Admin : Backups and Restores
SQL Server 7 Admin : Managing Replication
SQL Server 7 Admin : Management Tasks
SQL Server 7 Admin : Monitoring Events
SQL Server 7 Admin : Watching and Optimizing
SQL Server 7 Admin : Server Repair
SQL Server 7 Admin : More Troubleshooting

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

Objectives:
After completing this course, students will be able to:
Assess whether to use Microsoft Windows NT or Microsoft SQL Server accounts
Decide whether to use the Windows NT group structure for a SQL Server 7.0 installation
Plan the use and structure of SQL Server roles
Assess whether to map Windows NT groups directly into a database or use SQL Server logins
Choose which NT accounts will be used to run SQL Server services
Plan an n-tier application security strategy and determine whether to use application roles or other mid-tier security mechanisms such as Microsoft Transaction Server
Plan the security requirements for linked databases

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

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

Objectives:
After completing this course, students will be able to:
Plan the physical placement of files, including data files and log files
Plan the use of filegroups
Plan for growth over time
Plan the physical hardware system
Assess the server's communication requirements
Choose the appropriate backup and restore strategies
Assess whether to use a standby server
Assess whether to use clustering

Topics:
Data File Placement and Space
Capacity Planning
Communication and Backup Strategies
Data Availability
top

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

Objectives:
After completing this course, students will be able to:
Plan an upgrade from a previous version of Microsoft SQL Server
Plan the migration of data from other data sources
Determine hardware and software requirements for migration
Use the Upgrade Wizard
Use the Import Wizard

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

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

Objectives:
After completing this course, students will be able to:
Design an appropriate replication model
Choose a replication type
Select an appropriate subscription model and type
Evaluate data type requirements

Topics:
Choosing a Replication Model
Additional Options
Choosing a Replication Type
Designing and Planning Replication
Data Definition Considerations
top

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

Objectives:
After completing this course, students will 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

Topics:
Installation Prerequisites
Installing Components
Choosing Database Options
Installing Network Libraries and Protocols
Installing Services and Clients
top

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

Objectives:
After completing this course, students will be able to:
Perform an unattended installation and uninstallation of Microsoft SQL Server 7.0
Prepare for upgrading a SQL Server system
Use the Upgrade Wizard to upgrade operations from SQL Server 6.x to SQL Server 7.0
Validate and verify the upgrade of the system

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

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

Objectives:
After completing this course, students will 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

Topics:
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
top

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

Objectives:
After completing this course, students will be able to:
Assign SQL Server access through Windows NT accounts, SQL Server logins, and built-in administrator logins
Assign database access to Windows NT accounts, SQL Server login accounts, the Guest account, and the DBO user account
Create and assign SQL Server roles

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

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

Objectives:
After completing this course, students will be able to:
Create and assign SQL server roles
Manage login IDs and database User IDs

Topics:
Viewing ID Information
Viewing Roles
Managing Login IDs
Managing Database IDs and Roles
Server Roles and Management Procedures
top

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

Objectives:
After completing this course, students will be able to:
Grant to database users and roles the appropriate permissions on database objects and statements
Audit server and database activity

Topics:
Permissions
Permission Management Tools
Displaying Permissions Information
Granting and Revoking Permissions
Auditing Server and Database Activity
top

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

Objectives:
After completing this course, students will be able to:
Create and manage databases
Create data files, filegroups, and transaction log files
Specify growth characteristics
Manage database size
Set database options
Document and script a database
Set up a database maintenance plan
Delete a database

Topics:
Creating a Database
Managing Database Size
Database Options and Scripts
Managing and Deleting Databases
top

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

Objectives:
After completing this course, students will be able to:
Load data using the INSERT statement
Load data using the SELECT INTO statement
Load data using the BCP Utility
Load data using the Data Transformation Services (DTS)
Load data using the BULK INSERT command

Topics:
The INSERT and SELECT INTO Statements
Bulk Copying Data
Importing and Exporting Data with DTS
Managing DTS Packages
top

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

Objectives:
After completing this course, students will be able to:
Back up system databases and user databases
Restore system databases and user databases

Topics:
Introduction to Backups
Database Backups
Differential Backups
Transaction Log Backups
Filegroup Backups
Backing Up System Databases
top

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

Objectives:
After completing this course, students will be able to:
Configure servers, including distributors, publishers, and subscribers
Create publications

Topics:
Using Replication
Configuring Servers
Creating Publications
Subscribing to Publications
top

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

Objectives:
After completing this course, students will be able to:
Automate administrative tasks
Configure SQL Server Agent
Define jobs and create multiserver jobs
Define operators and alerts
Set up SQLAgentMail for job notification and alerts
Set up linked servers
Set up security for linked databases

Topics:
Configuring the SQL Server Agent
Implementing Jobs
Multiserver Jobs
Managing Server Events
Linked Servers
top

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

Objectives:
After completing this course, students will be able to:
Monitor SQL Server engine event performance
Explain tracing and trace architecture
Create traces using the Create Trace Wizard SQL Server Profiler and extended stored procedures
Run and save traces
Modify and replay traces

Topics:
Introduction to Monitoring
Understanding Trace Architecture
Creating Traces with the Trace Wizard
Creating Traces with Other Tools
Managing Traces
Analyzing Traces
top

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

Objectives:
After completing this course, students will be able to:
Monitor SQL Server performance
Tune and optimize SQL Server
Limit resources used by queries

Topics:
Monitoring Disk I/O Performance
Monitoring CPU and Memory Usage
Other Monitoring Processes
Optimizing Server Performance
top

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

Objectives:
After completing this course, students will be able to:
Diagnose and resolve problems with upgrading from SQL Server 6.x
Use the Client Configuration utility to diagnose and resolve client connectivity problems
Diagnose and resolve problems regarding access to SQL Server databases and database objects

Topics:
Overview of Troubleshooting
Solving Installation Problems
Solving Upgrading Problems
More About Upgrading Problems
Troubleshooting Server Access Problems
Troubleshooting SQL Server Permissions
top

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

Objectives:
After completing this course, students will be able to:
Diagnose and resolve problems with backup and restore operations
Diagnose and resolve replication problems
Diagnose and resolve job or alert failures
Diagnose and resolve distributed query problems

Topics:
Troubleshooting Backups and Restores
Troubleshooting the SQL Server Agent
Troubleshooting Jobs and Alerts
Troubleshooting Replication
Linked Server Issues and Recovery Planning
top

12 Month Subscription - $70
Live Mentor +$30