SQL Server 6.5 Administration

Course Description
Course Outline

Prerequisites

Working knowledge of DOS, Windows and networking.

We offer a range of SQL Server training courses

Introduction to Microsoft SQL Server
Exploring the components of SQL Server Identifying SQL Server administration tasks
SQL Server 6.5 Installation
Server and client pre-requisites Planning an installation The Setup program Troubleshooting an installation
Data storage and management
Data organisation in SQL Server and NT Database devices Creating databases and logs Optimal placement of data and logs Managing growth of data and log space Segments and segmaps Planning data storage
Importing and exporting data
Bulk Copy Program Transfer Manager Using Access to transfer data Setting up databases for distributable media
Securing access to SQL Server databases
Setting up NT accounts Integrated, mixed and standard security modes Using Security Manager Security - logins and users Users, guests and aliases
Managing database permissions
The permissions hierarchy Creating user groups Giving Backup but not Create rights Assigning rights to groups Using ownership chains Useful secure views and procedures
Safeguarding against data loss
Hardware and software mirroring and striping SQL Server mirroring Automatic recovery Creating dump devices File level backup vs SQL Server Automating SQL Server backup Improving the performance of a large backup
Automating tasks
Setting up SQLMail Tasks, events and alerts Setting up alerts
Data replication
Uses of replication SQL Server replication Setting up replication
Troubleshooting, monitoring and optimisation
Troubleshooting SQL Server Monitoring SQL Server Hardware optimisation memory, CPUs and disks NT dedication

Publisher:	Microsoft
Version:	6.5
Length:	3 Days
Course-ID:	044460

	Printer Friendly Version
	Download Outline As PDF

Related Courses

SQL Server 6.5 Administration

One of the best external courses I have ever attended

- Bayer