|
From:NETg
|
![Microsoft SQL Server 7.0: System Administration- Part 1 CBT Training CD]()
See Product Page
|
User Rating: Amazon Sales Rank:#23725 |
| |
Microsoft SQL Server 7.0: System Administration- Part 1 CBT , 2004-10-23
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.
|
|
|