|
Description
In this course, students will be presented with a task-based, real-world scenario covering the, administration optimization, troubleshooting of Microsoft SQL Server 6.5. Administration of SQL Server includes managing storage, the setting up user accounts, and assigning permissions. The optimization, configuration, and diagnostics of SQL Server will 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 , two years experience performing system administration or support in a networked environment and completed the FirstClass Systems course 'MS SQL Server 6.5 – Installation and Administration.
Objective
Manage database storage through the manipulation of a SQL Database
Manage user accounts through the creation and administration of group and individual user accounts
Manage the security of SQL databases by granting and/or revoking permissions
Manage data by performing backup and recovery procedures
Identify and implement SQL Server replication
Monitor SQL Server performance using Windows NT Performance Monitor
Use the SQL Enterprise Manage to monitor server activity
Monitor and configure server memory for optimum performance
Troubleshoot system errors related to database configuration and SQL Server optimization
Topics Include
Managing SQL Databases
- Manage User Account: Examine Security Levels
- Examine Types of Security
- Create a Group
- Create a Login ID
- Manage Users
- Use Integrated Security Groups
- Utilize SQL Security Strategies
- Assign User Permissions
- Examine Permissions
- Assign Statement Permissions
- Assign Object Permissions
- Supplement Security Strategies
- Examine Ownership Chains
- Explore Backup and Recovery
- Formulated a Data Backup Plan
- Create Backup Devices
- Perform a Database Backup
- Perform a Transaction Log Backup
- Explore Backup Types
- Examine Recovery Methods
- Restore a Database
- Examine Data Transfer Tools
- Examine TMI
- Examine the Bulk Copy Program
- Troubleshoot SQL Databases: Recover from Media Failure
- Recreate a Lost Device
- Restore a Corrupted Database
Exploring Replication
- Examine Replication: Choose a Distributed Data Option
- Examine SQL Replication
- Examine the Replication Process
- Choose a Replication Scenario
- Examine Replication Options
- Implement Replication: Configure Server for Replication
- Enable Distributing
- Enable Publishing
- Create a Publication
- Set Synchronization
- Secure a Publication
- Enable Subscribing
- Define Subscriptions
- Trace the Replication Process
- Troubleshoot SQL Data: Examine Replication Setup
Resolve Fault-tolerance Problems
- Optimize SQL Server
- Administer Client Networking: Set Network Protocols
- Use Extended Stored Procedures
- Optimize Microsoft SQL Server: Examine Performance Factors
- Use the Performance Monitor
- Examine Memory Configurations
- Allocate SQL Server Memory
- Set Procedure Cache Configuration
- Use DBCC MEMUSAGE
- Examine the tempdb RAM Option
- Configure Lock Values
- Monitor Log Space
- Set Database Options
- Set Data Maintenance Tasks
-
Troubleshoot SQL Server: Resolve Network Error Messages
- Resolve Memory Allocation Errors
- Resolve System Configuration Errors
Duration
3 hrs
Minimum Requirements
IBM 486 Compatible PC; VGA color monitor (256 colors); 8 MB RAM; 20 MB 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
|
