System Administration for Microsoft SQL Server 7.0 Curriculum CBT Training CDs

Rating:
Summary: System Administration for Microsoft SQL Server 7.0 Curriculu
Review: Course Overview
The System Administration for Microsoft SQL Server 7.0 Curriculum is designed for IT professionals responsible for installing, configuring, administering and troubleshooting Microsoft SQL Server 7.0. This curriculum will help students prepare for Microsoft certification exam 70-028, Administering Microsoft SQL Server 7.0. Skills taught in this series include identify the main components of the SQL Server; upgrade to SQL Server 7.0; understand the basics of SQL Server databases and how to create databases and other objects; Identify the concepts, interfaces and fixed roles involved in performing backups; automate SQL Server 7.0 administrative tasks; and identify the methods and attributes of SQL Server 7.0 replication.

# This curriculum consists of five Skill Builder courses: Microsoft SQL Server 7.0: System Administration - Part 1
# Microsoft SQL Server 7.0: System Administration - Part 2
# Microsoft SQL Server 7.0: System Administration - Part 3
# Microsoft SQL Server 7.0: System Administration - Part 4
# Microsoft SQL Server 7.0: System Administration - Part 5

Certification Requirements: This curriculum contains content that will help prepare students for the MCSE Elective, MCSE+I Elective, MCDBA Core certifications and Exam 70-028.

Learn To
See individual course descriptions for specific course objectives and scope.

Audience
These courses are designed for IT professionals responsible for installing, configuring, administering and troubleshooting Microsoft SQL Server 7.0.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits Per Course
ITCAP credits: 2.5 Credit Hours
CEU credits: 3.50 CEUs

Language Options
US English

Total Learning Time
30 to 40 hours

Microsoft SQL Server 7.0: System Administration - Part 1 Training CD
Course Overview
This is the first course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.

Learn To
# Identify the main components of the SQL Server.
# Understand the properties of SQL Server Architecture, including the underlying technical details.
# Understand the components of SQL Server installation, including hardware and software requirements, types of installations, and installation options.
# Verify SQL Server installation, including reviewing installation results, starting SQL Server services, and connecting to SQL Server.
# Plan the upgrade of SQL Server, including hardware and software requirements, setting, backward compatibility levels, and database copy methods.
# Upgrade to SQL Server 7.0.


Audience
This course is designed for IT professionals responsible for installing, configuring, administering and troubleshooting Microsoft SQL Server 7.0. Participants should have completed course series 71410 - 71413, Supporting Windows NT 4.0 Server Core Technologies or have equivalent knowledge.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs

Language Options
US English

Total Learning Time
6 to 8 hours

Objectives
Unit 1: SQL Server Introduction 2 - 3 hours
# Identify the main attributes of SQL Server.
# Identify the administrative improvements of SQL Server 7.0.
# Identify the BackOffice applications that SQL Server uses via integration.
# Match the SQL Server Service to its characteristic.
# Identify the functions that can be performed with the SQL Server client software.
# Identify components of SQL Server communication architecture.
# Identify the natively supported Application Programming Interfaces and Data Object Interfaces.
# Match each management tool with its automated routine administrative task.
# Identify the types of login authentication recognized by SQL Server.
# Match the role to its definition.
# Sequence the steps for validating permissions.
# Match each system and user database with its description.
# Match each database object with its definition.
# Identify the valid formats of object names.
# Match each system table term to its definition.
# Match each method of metadata retrieval with its definition.
# Identify the logical layers of software applications.
# Sequence the steps for implementing a SQL Server database.
# Sequence the steps to administer a SQL Server database.
# Match each application deployment option with its description.


Unit 2: Installing and Configuring SQL Server 2 - 3 hours
# Identify the hardware and software installation requirements for installing SQL Server 7.0.
# Perform a typical SQL Server 7.0 installation using the using the SQL Server Setup program.
# Review the steps to complete an unattended installation of SQL Server 7.0.
# Identify the components that are installed by the SQL Server Setup program.
# Match the SQL Server licensing mode and installation path function with its description.
# Identify the properties of a character set.
# Identify the properties of sort orders.
# Identify the properties of Unicode collation.
# Identify the network libraries and protocols supported in SQL Server.
# Identify the SQL Server service account properties.
# Perform the steps to auto start SQL Server.
# Perform the steps to manually start SQL Server.
# Perform the steps to manually pause SQL Server services.
# Perform the steps to connect SQL Server Agent to SQL Server.
# Perform the steps to register the server.
# Sequence the steps to review the cnfgsvr.out file.
# Match each utility with its description.


Unit 3: Upgrading to SQL Server 7.0 2 hours
# Match the hardware or software requirement with its component.
# Estimate disk space.
# Identify the tasks requiring completion before upgrading to SQL Server 7.0.
# Set the memory option.
# Match the compatibility level with its description.
# Copy data from a database.
# Transfer data to SQL Server 7.0.
# Set the ANSI_NULLS option.
# Configure SQL Mail.
# Select the verification measures that SQL Server Upgrade Wizard performs.
# Identify the configuration tasks that may need to be performed after upgrading SQL Server.
# Remove SQL Server 6.x.


Microsoft SQL Server 7.0: System Administration - Part 2 Training CD
Course Overview
This is the second course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.

Learn To
# Work with Microsoft SQL Server 7.0, its architecture, security, and database structure.
# Understand the basics of SQL Server databases and how to create databases and other objects.
# Modify databases; manage data on multiple disks; assess database size requirements and to plan for growth.


Audience
This course is designed for IT professionals responsible for installing, configuring, administering and troubleshooting Microsoft SQL Server 7.0. Participants should have completed the first course in this series.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs

Language Options
US English

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Managing Security 2 - 3 hours
# Identify the elements of Windows NT Authentication.
# Identify the benefits of SQL Server Authentication.
# Sequence the steps to implement server authentication using Enterprise Manager.
# Perform the steps for setting Mixed Mode authentication using Enterprise Manager.
# Identify the three types of security accounts available for login creation.
# Perform the steps for adding a Windows NT login using Enterprise Manager.
# Perform the steps for adding a SQL Server login using Transact-SQL.
# Perform the steps to assign a login to a user account in SQL Server using Enterprise Manager.
# Identify the two types of default user accounts.
# Match each server role with the permission.
# Perform the steps for assigning logins to Fixed Server Roles using Transact-SQL.
# Match each database role with the permission.
# Perform the steps for assigning logins to Fixed Database Roles using Enterprise Manager.
# Perform the steps for creating User-Defined Database roles.
# Perform the steps to assign a security account to a User-Defined Database Role using Transact-SQL.
# Identify the three types of permissions for logins.
# Match each permission state with the definition.
# Perform the steps for granting permissions using Transact-SQL.
# Perform the steps for denying permissions using Enterprise Manager.
# Perform the steps for revoking granted or denied permissions using Transact-SQL.
# Identify the properties of default administrator logins.
# Deduce the function of a Guest User Account.
# Deduce the best use for the public Role Permissions.
# Map logins to user accounts and roles.
# Identify the recommended Fixed Database Roles used for object creation.
# Identify the principles of planning security for linked databases.
# Identify how views and stored procedures can be used to simplify security.
# Distinguish between application roles and other roles.
# Perform the steps for creating an application role for users/logins within SQL Server Enterprise Manager.
# Perform the steps for activating an application role for users/logins using Transact-SQL.
# Identify the recommended practices for security implementation.


Unit 2: SQL Server Database Basics 2 - 3 hours
# Match each data storage term with its description.
# Sequence the steps for the transaction logging process.
# Perform the steps for creating a database using Enterprise Manager.
# Identify the tasks involved in implementing a full-text search.
# Perform a simulation using the Full-Text Indexing Wizard.
# Perform the steps to schedule a full-text index population.
# Match each frequently used database option with its function.
# Perform the steps for setting database options using Enterprise Manager.
# Perform the steps to view options for all databases using Transact-SQL.


Unit 3: Managing Databases 2 hours
# Identify the methods of managing data and log file growth.
# Perform the steps for adding a data and transaction log file to a database using Enterprise Manager.
# Perform the steps for expanding a transaction log using Enterprise Manager.
# Perform the steps for shrinking a database using Enterprise Manager.
# Perform the steps for dropping a database using Transact-SQL.
# Match the RAID levels with their description.
# Identify the benefits of using files and filegroups.
# Perform the steps for creating a filegroup using Transact-SQL.
# Perform the steps to change the default filegroup using Transact-SQL.
# Identify the benefits of using clustering.
# Sequence the steps for estimating the number of pages required for a table.
# Identify the actions that may be taken to affect system performance.


Microsoft SQL Server 7.0: System Administration - Part 3 Training CD
Course Overview
This is the third course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.

Learn To
# Identify the concepts, interfaces and fixed roles involved in performing backups.
# Gain a working knowledge of database, transaction log and filegroup backups and perform these backups as a system administrator.
# Restore damaged or incomplete databases.


Audience
This course is designed for IT professionals responsible for installing, configuring, administering and troubleshooting Microsoft SQL Server 7.0. Participants should have completed the first two courses in this series.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs

Language Options
US English

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Backup Concepts 2 - 3 hours
# Match the backup type with its features.
# Identify the fixed roles with permission to perform backups.
# Identify the circumstances that make system database backup necessary.
# Identify the situations in which Transact-SQL must be used to perform a function.
# Identify the available media for database backup.
# Identify activities that cannot be performed while a backup operation is in process.
# Match the three primary backup devices with their features.
# Perform the steps necessary to create a temporary backup file.
# Perform the steps necessary to create permanent backup files.
# Perform the steps necessary to add multiple files to a backup statement.
# Match six of the advanced options available in the Transact-SQL BACKUP statement with their functions.
# Associate the six tape backup options with their functions.


Unit 2: Performing Backups 2 - 3 hours
# Match the proper full backup frequency with its scenario.
# Perform the steps necessary to create a full database backup.
# Identify the scenarios for which differential backup would be appropriate.
# Perform the steps necessary to create a differential database backup.
# Identify the features of transaction log backups.
# Perform the steps necessary to back up the transaction log.
# Associate the options for clearing the transaction log with their functions.
# Identify situations in which filegroup backup is preferable to full database backup.
# Identify situations in which multiple files must be backed up as a unit.
# Perform the steps necessary to create a filegroup backup.


Unit 3: Restoring Databases 2 hours
# Identify the functions performed by SQL Server 7.0 when the system is restarted.
# Match the verification options with their functions.
# Identify the steps used to prepare the database for recovery.
# Associate restore options with their functions.
# Identify the units that must be restored to reinstate the system database.
# Identify cases in which the user databases must be attached to the master database.
# Perform the steps necessary for restoring a database from a full backup set.
# Perform the steps necessary to restore a database from a differential backup.
# Perform the steps necessary to recover a database from transaction log backups.
# Perform the steps necessary to restore a database from transaction log backups.
# Perform the steps necessary to recover a database file from a filegroup backup.
# Perform the steps necessary to restore a database filegroup from a filegroup backup.
# Identify the uses of a standby server.
# Sequence the steps necessary for entering the correct backup data in a standby server.
# Identify the functions of the STANDBY option.
# Sequence the steps for replacing a production server.
# Sequence the steps required for restoring a database that has no transaction log.
# Sequence the steps in a database restoration solution.
# Sequence the steps in a recovery strategy for a differential backup.
# Select a step in the recovery strategy for a filegroup backup.


Microsoft SQL Server 7.0: System Administration - Part 4 Training CD
Course Overview
This is the fourth course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.

Learn To
# Automate SQL Server 7.0 administrative tasks.
# Identify and use the SQL Server 7.0 tools for transferring and transforming data.
# Identify and use the tools for monitoring and maintaining SQL Server 7.0.


Audience
This course is designed for IT professionals responsible for installing, configuring, administering and troubleshooting Microsoft SQL Server 7.0. Participants should have completed the first three courses in this series.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs

Language Options
US English

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Automating Administrative Tasks 2 - 3 hours
# Select the reasons for automating SQL Server maintenance tasks.
# Identify SQL Server automation components.
# Identify the components of automated administrative tasks.
# Identify tasks to be completed in preparation for automating administrative tasks.
# Perform the steps to create a job.
# Perform the steps to define job steps.
# Configure action flow logic for a job step.
# Schedule the frequency of a job.
# Perform the step to create an operator for notification.
# Configure job history size.
# Identify the guidelines to help isolate and solve problems.
# Create an alert to respond to a specific error.
# Create an alert on a user-defined error.
# Define an alert response.
# Identify the factors that cause looping alerts.
# Identify the features of a multiserver environment.
# Define a master server.
# Define a target server.
# Identify the facts to consider when making changes to a job in a multiserver environment.
# Identify the features of SQL Server Web Assistant.
# Create an HTML file.
# Execute a defined Web Assistant job.


Unit 2: Transferring Data 2 - 3 hours
# Identify the steps for copying data from one environment to another.
# Select the tasks that are done when transforming data.
# Match data transfer tool names with uses.
# Identify the features of Data Transformation Services (DTS).
# Identify data source and data destination types provided in SQL Server.
# Match each Data Transformation Services (DTS) tool with its function.
# Identify the features of restructuring and mapping data.
# Select the functions that can be performed using Data Transformation Services (DTS) steps.
# Identify the features of Data Transformation Services (DTS) workflows.
# Create a Data Transformation Services (DTS) package.
# Schedule and execute a Data Transformation Services (DTS) package.


Unit 3: Monitoring and Maintaining SQL Server 2 hours
# Select the purposes for monitoring SQL Server.
# Identify the factors that affect SQL Server performance.
# Match the factors that can cause bottlenecks to the effects they have on the server.
# Match aspects of SQL Server performance with tools for monitoring.
# View the event log.
# Monitor SQL Server.
# View current server activity.
# Create a trace to monitor and respond to server events.
# Collect information on a specific table.
# Start the Flight Recorder.
# Identify SQL Server Maintenance tasks.
# Start the Database Maintenance Plan wizard.
# Automate a database maintenance plan.


Microsoft SQL Server 7.0: System Administration - Part 5 Training CD
Course Overview
This is the final course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.

Learn To
# Identify the methods and attributes of SQL Server 7.0 replication.
# Identify and apply techniques for planning and setting up SQL Server 7.0 replication.
# Identify the procedures for replication maintenance.


Audience
This course is designed for IT professionals responsible for installing, configuring, administering and troubleshooting Microsoft SQL Server 7.0. Participants should have completed the first four courses in this series.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs

Language Options
US English

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Replication Basics 2 - 3 hours
# Identify the benefits of distributed data.
# Identify important considerations in data distribution.
# Match the distributed data method with its attribute.
# Identify the dynamic of the Publisher-Subscriber relationship.
# Choose the appropriate attributes of Articles and Publications.
# Match the data filtering method with its appropriate attributes.
# Identify the attributes of push and pull subscription methods.
# Match the replication agent with its appropriate attributes.
# Identify conflict resolution attributes.
# Analyze and label the components of the merge replication process.
# Analyze and label the components of the snapshot replication process.
# Analyze and label the components of the transactional replication process.
# Analyze and label the components of various replication models.
# Analyze and label the various types and models of replication.
# Analyze and label the components of a single publisher diagram.
# Analyze and label the components of a single subscriber diagram.
# Analyze and label the components of a multiple publisher diagram.


Unit 2: Replication Planning Considerations 2 - 3 hours
# Identify valid design considerations in implementing replication.
# Identify valid replication solutions.
# Identify the attributes of various data types.
# Identify important issues in network security.
# Perform the steps to set up a Distributor.
# Perform the steps to configure distribution database properties.
# Perform the steps to set publisher options.
# Perform the steps to enable and modify subscriber properties.
# Identify important issues in database publishing.
# Perform the steps to create publications.
# Identify the attributes of publication initialization.
# Perform the steps to set up a push subscription.
# Perform the steps to set up a pull subscription.
# Perform the steps to use the Immediate Updating Subscribers option.


Unit 3: Replication Management 2 hours
# Identify the uses of the replication monitor.
# Match the maintenance strategy with the appropriate attributes.
# Identify the benefits of using replication scripts.
# Match the replication system components with appropriate system stored procedures.
# Use the replication monitor to view agent histories.
# Use the SQL Server Query Analyzer to test connectivity.
# Identify the ODBC driver requirements for SQL Server replication.
# Use replication wizards to publish data to heterogeneous subscribers.
# Identify features of the SQL-DMO object structure.
# Perform the steps to script a replication topology.
# Perform the steps to publish on the Internet utilizing snapshot replication.