|
Provided by: 123-CBT Computer Based Training SQL Server 7 0 System Administration - Part 1 |
 |
Training
Provided by 123-CBT Computer Based Training
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.
Content Emphasis
Skills-Based
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.
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: SQL Server Introduction
Duration: 2 - 3 Hour(s)- 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
Duration: 2 - 3 Hour(s)- 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.
- S
This is primarily online training 
This is an online eLearning or CBT training program 
This program may be available on CD 
Contact 123-CBT Computer Based Training for more information Training Presented in: English
SQL Server 7 0 System Administration - Part 1
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
