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.
Installation & Upgrading of Microsoft SQL Server 2000
This unit covers the steps you must get right in the installation and upgrading of SQL Server.
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.
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.
Securing Access to SQL Server Databases
This unit covers the SQL Server security model.
Managing User Rights
This section covers the granting of rights to users using SQL Server's new security regime.
Safeguarding Against Data Loss
This section covers all aspects of fault tolerance, from hardware mirroring to SQL Server logs and backups.
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.
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.
Troubleshooting, Monitoring & Optimising
This section covers hardware and software aspects of improving SQL Server Performance.