IT Training | Business Training | Corporate Training | IT Higher Education | Business Higher Education

Library 6 : Technical MCSE

SQL Server 7 Admin Series

Total Time: 72 hours

SQL Server 7 Admin: Security Strategy4 hoursLA7C01
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 Requirements4 hoursLA7C02
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 Planning4 hoursLA7C03
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 Plans4 hoursLA7C04
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 Server4 hoursLA7C05
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 Installations4 hoursLA7C06
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: Configuring4 hoursLA7C07
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 Management4 hoursLA7C08
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 Accounts4 hoursLA7C09
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 Permissions4 hoursLA7C10
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 Management4 hoursLA7C11
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 4 hoursLA7C12
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 Restores4 hoursLA7C13
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 Replication3 hoursLA7C14
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 Tasks3 hoursLA7C15
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 Events3 hoursLA7C16
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
  • Analysing Traces


SQL Server 7 Admin: Watching & Optimising3 hoursLA7C17
SQL Server 7 Admin: Watching & Optimising 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
  • Optimising Server Performance


SQL Server 7 Admin: Server Repair4 hoursLA7C18
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 Troubleshooting4 hoursLA7C19
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

Back






©2002 Purpletrain.Com Pte Ltd, Purpletrain.Com Logo and Informatics Holdings Ltd and the Informatics logo are registered trademarks of Informatics Holdings Ltd and Purpletrain.Com Pte Ltd. Informatics Holdings and Purpletrain.Com is a trademark herein used under license. All other brand names mentioned herein are used for identification purposes only and are trademarks of their respective owners.

This study guide and/or material is not sponsored by endorsed by or affiliated with Cisco Systems, Inc. Cisco®, Cisco Systems®, CCDA™, CCNA™, CCDP™, CCNP™, CCIE™, CCSI™, the Cisco Systems logo and the CCIE logo are trademarks or registered trademarks of Cisco Systems, Inc. in the United States and certain other countries. All other trademarks are trademarks of their respective owners.