Management Sales Technology training courses, Dublin Belfast Cork Ireland, Beckinridge
Management Sales Technology training courses, Dublin Belfast Cork Ireland, Beckinridge

Microsoft SQL Server 2000 Administration

Course Code - CT-303 Duration - 4 Days

This course covers all the administrative aspects of SQL Server 2000.

Who Should Attend

Administrators of Microsoft SQL Server 2000


Delegates should have experience in using SQL. This can be obtained by attendance on the Beckinridge course 'Programming with SQL' ('MC-104'). Previous experience in a structured programming language is also required.

Course Content

Installation & Upgrading of Microsoft SQL Server 2000

This unit covers the steps you must get right in the installation and upgrading of SQL Server.

  • Server prerequisites
  • Client prerequisites
  • Planning an installation
  • Understanding SQL Server 2000 Editions
  • Troubleshooting an installation

Data Storage & Management

This module covers all aspects of data storage in SQL Server, including where to put the data, how to get the best performance and fault tolerance from your hardware.

  • How data is organised in SQL Server
  • Creating Databases and Logs
  • Optimal placement of Data and Logs through Filegroups.

Data Transformation Services

This unit covers DTS, a powerful way of getting data into and out of SQL Server 2000. It covers the creation of sophisticated DTS Packages with complex workflows.

  • What is DTS?
  • Using the Data Import Wizard
  • Using DTS as a Data Pump
  • Advanced DTS Packages

Securing Access to SQL Server Databases

This unit covers the SQL Server security model.

  • Version 2000 security overview
  • Windows Authenticated or Mixed Security
  • Setting Up NT Accounts for SQL Server
  • Setting Up Roles, Logins and Users

Managing User Rights

This section covers the granting of rights to users using SQL Server's new security regime.

  • Defining Roles within a Database
  • Assigning rights to Users and Roles
  • Using Application Roles
  • Setting Permissions

Safeguarding Against Data Loss

This section covers all aspects of fault tolerance, from hardware mirroring to SQL Server logs and backups.

  • SQL Server 2000's new Database
  • Recovery Models
  • When to do a File-level Back Up and when to use SQL Server
  • Implementing an SQL Server Backup Strategy
  • On-line Backup; How it works
  • Improving the performance of a large Backup
  • Recovering a Database
  • The New Log-shipping Feature
  • Fail-over Clustering

Scheduling Jobs in SQL Server 2000

This module follows on from the Back-Up topic, detailing how many routine administrative jobs can be scheduled using SQL Agent.

  • Setting Up SQL Mail
  • Setting Up Operators in Microsoft SQL Server
  • Jobs, Events and Alerts
  • Jobs and the scope of the SQL Agent.
  • Multi-server Jobs
  • Creating User-defined Error Messages
  • Setting Up Alerts
  • Advanced Job Scripting

Data Replication in Microsoft SQL Server 2000

This section covers the extensive topic of replication and how to set it up in SQL Server 2000.

  • Uses for SQL Server Replication
  • Replication Topologies
  • Microsoft SQL Server 2000 Replication
  • How it works
  • Bi-Directional Replication and Conflict Management
  • Troubleshooting Replication

Troubleshooting, Monitoring & Optimising

This section covers hardware and software aspects of improving SQL Server Performance.

  • The scope of SQL Server's Self-Tuning features
  • Monitoring SQL Server with the SQL Profiler and Query Analyser
  • SQL Server Configuration options
  • Database Index usage
  • Application De-normalisation
  • Locking problems and solutions

« Back to last page

Why Choose Us?

ILM Qualifications


Team Building

Public Schedule

© web design by redrhino

Privacy Policy