Register to win
Over $5,000 in Prizes
- (Ends August 26th) -

Home
Login
FREE Training
Course List
Features
Certification
Resources
About Us
News
Contact Us
SQL Server 7 Admin Series
Total Time: 62 hours
SQL Server 7 Admin: Security Strategy Time: 3 hours LA7C01
SQL Server 7 Admin: Security Strategy 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

SQL Server 7 Admin: System Requirements Time: 3 hours LA7C02
SQL Server 7 Admin: System Requirements 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

SQL Server 7 Admin: Migration Planning Time: 3 hours LA7C03
SQL Server 7 Admin: Migration Planning 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

SQL Server 7 Admin: Replication Plans Time: 3 hours LA7C04
SQL Server 7 Admin: Replication Plans 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

SQL Server 7 Admin: Installing the Server Time: 4 hours LA7C05
SQL Server 7 Admin: Installing the Server shows users how to go through the installation process for servers and clients.
  • Installation Prerequisites
  • Installing Components
  • Choosing Database Options
  • Installing Network Libraries & Protocols
  • Installing Services and Clients

SQL Server 7 Admin: Other Installations Time: 2 hours LA7C06
SQL Server 7 Admin: Other Installations 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

SQL Server 7 Admin: Configuring Time: 3 hours LA7C07
SQL Server 7 Admin: Configuring 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

SQL Server 7 Admin: Security Management Time: 4 hours LA7C08
SQL Server 7 Admin: Security Management 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

SQL Server 7 Admin: Managing Accounts Time: 3 hours LA7C09
SQL Server 7 Admin: Managing Accounts 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

SQL Server 7 Admin: Managing Permissions Time: 4 hours LA7C10
SQL Server 7 Admin: Managing Permissions 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

SQL Server 7 Admin: Database Management Time: 3 hours LA7C11
SQL Server 7 Admin: Database Management shows users how to create and maintain SQL server databases.
  • Creating a Database
  • Managing Database Size
  • Database Options and Scripts
  • Managing and Deleting Databases

SQL Server 7 Admin: Loading Databases Time: 3 hours LA7C12
SQL Server 7 Admin: Loading Databases 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

SQL Server 7 Admin: Backups and Restores Time: 4 hours LA7C13
SQL Server 7 Admin: Backups and Restores 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

SQL Server 7 Admin: Managing Replication Time: 3 hours LA7C14
SQL Server 7 Admin: Managing Replication shows users how to create and administer database replication.
  • Using Replication
  • Configuring Servers
  • Creating Publications
  • Subscribing to Publications

SQL Server 7 Admin: Management Tasks Time: 3 hours LA7C15
SQL Server 7 Admin: Management Tasks 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

SQL Server 7 Admin: Monitoring Events Time: 3 hours LA7C16
SQL Server 7 Admin: Monitoring Events 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

SQL Server 7 Admin: Watching & Optimizing Time: 3 hours LA7C17
SQL Server 7 Admin: Watching & Optimizing 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

SQL Server 7 Admin: Server Repair Time: 4 hours LA7C18
SQL Server 7 Admin: Server Repair 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

SQL Server 7 Admin: More Troubleshooting Time: 4 hours LA7C19
SQL Server 7 Admin: More Troubleshooting 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

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