|
Description
In this course, students will be presented with a task-based, real-world scenario covering the implementation, administration and troubleshooting of Microsoft SQL Server 6.5. Implementation of SQL Server includes the installation of the software and the setup of the SQL database. Administration of SQL Server includes managing storage, the setting up of user accounts and assigning permissions. The optimization and configuration of the SQL Server and the diagnostics of system problems with also be covered.
Audience
This course is designed for system administrators responsible for implementation and maintenance of Microsoft SQL Servers in an enterprise network.
Prerequisites
The student should have a Microsoft Windows NT Server 3.51 course or equivalent and two years experience performing system administration or support in a networked environment.
Objective
Install and configure hardware and software for Microsoft SQL Server 6.5 Respond to Microsoft SQL 6.5 hardware and software related queries Maintain, troubleshoot and repair network and communication connections Configure SQL Server environment to meet specific needs or requirements Administer SQL Server environment to meet specific needs or requirements Create and maintain SQL databases to meet specific needs or requirements Recommend specific system products
Topics Include
Installing SQL Server 6.5
- Install and Upgrade SQL 6.5: Verify Hardware Requirements
- Determine Software Requirements
- Create a SQL Executive Account
- Install SQL 6.5 Server
- Identify SQL Network Protocols
- Upgrade to Server 6.5
- Verify SQL Installation
- Install SQL Client
- Integrate SQL Server 6.5: Determine Security Requirements
- Integrate SQL Login Security
- Examine the NT Registry
- Examine Server Integration
- Examine SQL and MAPI
- Troubleshoot SQL Installation: Determine Install Failure
- Examine Upgrade Problems
- Examine SQL Mail Problems
Configuring SQL Server 6.5
- Configure Enterprise Database: Use the Enterprise Manager
- Configure SQL Server
- Manage SQL Server
- Administer SQL Server
- Set Alerts and Task Schedules: Examine SQL Executive Services
- Schedule Tasks
- Set Alerts
- Create an Operator
- Create an Alert
- Troubleshoot SQL Configuration: Examine Alert Problems
Administering SQL Databases
- Create SQL Databases: Explore System Databases
- Create a Database Device
- Estimate Database Space
- Create a Database
- Administer SQL Databases
- Create a Database Object
- Alter a Device
- Alter a Database
- Troubleshoot SQL Databases: Check Object Integrity
- Investigating a Suspect Database
Duration
3 hrs
Minimum Requirements
IBM 486 Compatible PC; VGA color monitor (256 colors); 8 MB RAM; 20MB hard disk space; MS Windows 3.x/Windows 95 or Windows NT 3.5 x/4.x; IBM 0S/2, Microsoft Mouse, 3.5 inch diskette drive.
Media
Diskette
CDROM
Web Based Training
|
