Northern Ireland based Beckinridge specialises in Technology, IT, Sales and Management training for the ICT, Corporate, SME and Government Sectors.

  Public Courses
General Training

  On-Site Courses
Tailored Training

  ILM Qualifications
Level 4 & 5 Awards

  Beck-Bites
Articles & Reviews

  Team Building
Activities & Events

  Why Choose Us?
Our Clients
Our Services
Quality and Expertise
Financial Support
Course Tailoring
Our Support Team
Talk To Us

Join Mailing List

 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.

 

 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

© Beckinridge Ltd.

Privacy Policy | Quality Policy

Site by redrhino

Beckinridge specialises in Technology, IT, Sales and Management training for the ICT, Corporate, SME and Government Sectors in Northern Ireland.
Privacy Policy | Capability, Improvement, Through Training & Development