SQL Server 7 Admin Series

SQL Server 7 Admin Series shows users how to plan the security policies for a SQL Server 7 installation, before moving onto implementation and admnistration.

This course 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.

Note: SQL 6.5 Server is also available - please contact the college

Syllabus

SECURITY STRATEGY

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

SYSTEM REQUIREMENTS

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

MIGRATION PLANNING

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

REPLICATION PLANS

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

INSTALLING THE SERVER

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

OTHER INSTALLATIONS

SQL Server 7 Admin: Other Installations shows users how to perform unattended set-ups 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

CONFIGURING

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

SECURITY MANAGEMENT

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

MANAGING ACCOUNTS

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

MANAGING PERMISSIONS

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

DATABASE MANAGEMENT

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

LOADING DATABASES

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

BACKUPS AND RESTORES

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
• File group Backups
• Backing Up System Databases

MANAGING REPLICATION

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

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

MANAGEMENT TASKS

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

MONITORING EVENTS

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

WATCHING AND OPTIMISING

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

SERVER REPAIR

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

MORE TROUBLESHOOTING

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

Qualifications

Qualification: Printable Transcript

On completion of this course you may print a transcript off as evidence of your progression throughout the course.

Requirements for Entry

There is no experience or previous qualifications required for enrolment on this course. It is available to all students, of all academic backgrounds.

Study Options

If you do not have Internet access, or would prefer to study this course via the traditional paper/postal based study method, you can find more information on the course by clicking on the link below.

Study Hours

This is only an approximate figure and is dependant upon how much time you can dedicate to your studies and how well you grasp the learning concepts in the course material. Furthermore, at the end of each lesson there is a question paper that needs to be completed and returned to your tutor. You should allow at least 1 - 2 hours of study to complete each question paper.

The approximate amount of time required to complete the course is: 40 hrs.