Forgot My Password Support
 
◊ SQL SERVER 7 ADMIN ONLINE TRAINING SERIES

Online SQL Server 7 Admin Training

Database » SQL Server

Check out these great money-saving course packages:

Only $49.95

SQL Server 7 Admin Series (60 hours)

ONLINE TRAINING FEATURES

  • Learn online with these interactive online courses.
  • Affordable Pricing (Only $49.95 for the complete series)
  • A full year to complete the courses
  • Retake the courses as many times as you like
  • Measure your progress with assessment tests after each course
  • Earn completion certificates after passing each assessment test

1. Security Strategy

Time: 3 hours
This course shows users how to plan the security policies for a SQL Server 7 installation.

Objectives

  • 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


2. System Requirements

Time: 3 hours
This course shows users how to prepare for the hardware needs of a SQL Server 7.0 installation.

Objectives

  • 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


3. Migration Planning

Time: 3 hours
This course shows users how to migrate data from other sources into a SQL Server 7.0 installation.

Objectives

  • 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


4. Replication Plans

Time: 3 hours
This course shows users how to develop a strategy for system replication.

Objectives

  • 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


5. Installing the Server

Time: 4 hours
This course shows users how to go through the installation process for servers and clients.

Objectives

  • 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


6. Other Installations

Time: 2 hours
This course shows users how to perform unattended setups or upgrade from a previous version of SQL Server.

Objectives

  • 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


7. Configuring

Time: 3 hours
This course shows users how to configure SQL server and its services.

Objectives

  • 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


8. Security Management

Time: 3 hours
This course shows users how to assign access and roles to server users and databases.

Objectives

  • 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


9. Managing Accounts

Time: 2 hours
This course shows users how to administer login IDs, Database IDs, and roles.

Objectives

  • 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


10. Managing Permissions

Time: 4 hours
This course shows users how to administer permissions and monitor server and database activity.

Objectives

  • 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


11. Database Management

Time: 3 hours
This course shows users how to create and maintain SQL server databases.

Objectives

  • 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


12. Loading Databases

Time: 3 hours
This course shows users how to load data from other sources into SQL Server databases.

Objectives

  • 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


13. Backups and Restores

Time: 4 hours
This course shows users how to back up and restore data on SQL Servers.

Objectives

  • 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


14. Managing Replication

Time: 3 hours
This course shows users how to create and administer database replication.

Objectives

  • Configure servers, including distributors, publishers, and subscribers
  • Create publications

Topics

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


15. Management Tasks

Time: 3 hours
This course shows users how to manage a variety of administrative tasks, including server jobs, events, alerts, linked servers, and remote servers.

Objectives

  • 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


16. Monitoring Events

Time: 3 hours
This course shows users how to monitor and trace engine events.

Objectives

  • 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


17. Watching and Optimizing

Time: 3 hours
This course shows users how to monitor and tune resource usage by SQL Server.

Objectives

  • 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


18. Server Repair

Time: 4 hours
This course shows users how to troubleshoot problems with installation upgrading and access to servers.

Objectives

  • 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


19. More Troubleshooting

Time: 4 hours
This course shows users how to resolve problems with database management and linked server issues.

Objectives

  • 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



Resources for SQL Server 7 Admin