System Administration for Microsoft SQL Server 7.0 Curriculum CBT Training CDs

by NetG

Product Details

• ASIN: B00065B4PY
• Date first available at Amazon.com: September 28, 2004
• Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)

Customer Reviews

Most Helpful Customer Reviews

5.0 out of 5 stars System Administration for Microsoft SQL Server 7.0 Curriculu, October 27, 2004

By 

David Pan Ceo - See all my reviews
(REAL NAME)   

This review is from: System Administration for Microsoft SQL Server 7.0 Curriculum CBT Training CDs (CD-ROM)

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... Read more ›