Experience Digitally Assisted Learning at it's Best

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

 

 


© 2003 Bridgeway Cyber Academy
 334 Second Street
Catasauqua PA 18032

Designed & Administered by PolyWeb Development