 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft SQL Server 6.5 Administration
Course Aims
SQL Server is a scaleable RDBMS designed for client/server applications. This course will prepare Database Administrators to set up and maintain an MSSQL systems in a networked environment. It provides both the theory and practical experience of installing, backing up, replicating and monitoring and tuning an SQL Server 6.x system. |
Assumed Knowledge
Basic administration experience with MS Windows NT. |
Course Audience
New, recent or intending MS SQL Server Systems Administrators. |
|
Table of Contents
|
SQL Server Feature
|
Relational Database Overview
|
|
Client/Server Architecture
|
|
SQL Server (a Brief History)
|
|
Access or SQL Server (Where to Draw the Line)
|
|
|
|
Installation and Upgrading of SQL Server 6.5
|
Hardware and Software Requirements
|
|
Where to Install SQL Server 6.5
|
|
Client Pre-requisites; Planning an Installation
|
|
Troubleshooting and Service Packs
|
|
|
|
Data Storage and Management
|
How Data is Organised in SQL Server and NT
|
|
Creating Databases and Logs
|
|
Optimal Placement of Data and Logs
|
|
Managing Growth of Data and Log Space
|
|
|
|
Importing and Exporting
|
BCP the Lowest Common Denominator
|
|
Programming BCP through DMO (Distributed Management Objects)
|
|
Using Dump and Load to Transfer Databases
|
|
Using Access to Transfer Data
|
|
Setting up Databases for Distributable Media
|
|
|
|
Securing Access to SQL Server Databases
|
SQL Server Security Overview
|
|
SQL Server Security (Logins and Users)
|
|
Setting up NT Accounts for SQL Server
|
|
Using Guests and Aliases in SQL Server Databases
|
|
Managing Database Permissions
|
|
The Permissions Hierarchy
|
|
Creating User Groups but not CREATE Rights
|
|
Assigning Rights to Groups
|
|
Useful Secure Views and Procedures
|
|
|
Safe Guarding Against Data Loss
|
Planning SQL Server Fault Tolerance
|
|
When to do a File-level Back up and When to Use SQL Server
|
|
Implementing an SQL Server Back up Strategy
|
|
Improving the Performance of a Large Back-up
|
|
|
|
|
Automatic Tasks in SQL Server 6.5
|
|
|
Data Replication in SQL Server 6.5
|
SQL Server 6.5 Replication
|
|
Setting up Replication through Enterprise Manager
|
|
|
|
SQL Server 6.5 Troubleshooting, Monitoring and Optimising
|
Troubleshooting, Monitoring and Optimising SQL Server 6.5
|
|
Hardware Optimisation (Memory, CPU's and Disks)
|
|
SQL Server Configuration Options
|
|
|
|
|
|
