.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk floridaC# training course UKC#.net training course UKvb.net training course UKSQL Server training course UK.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk florida
.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk floridaDelphi training course UKASP.net training courseJava training course UKASP.NET training class UK.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk florida

C#.Net training

VB.Net training

SQL Server training

ADO.NET training

ASP.net training

Delphi training

Java training

Web Tech, UK
+44 (0) 1452 814 303

Web Tech, USA


Quick Search:

If you have three or more developers needing this course consider having us customize this course for your specific needs - at your site or ours.

SQL Server 2000 Administration Training Course in the UK - SQL Server 2000 Training Course Outline

SQL Server 2000 System Administration
Next Course Dates Call for schedule
5 days


An understanding of basic relational database concepts. Knowledge of basic Transact-SQL syntax (SELECT, UPDATE and INSERT statements). Familiarity with the role of the database administrator.

Who Should Attend?

Those that want to deliver exceptional performance and scalability to your business information systems-and prepare for the Microsoft® Certified Professional (MCP) exam. Work at your own pace through a system of lessons and hands-on exercises to gain practical experience installing, configuring, and troubleshooting SQL Server" 2000. As you build these real-world database administration skills, you're also preparing for MCP Exam 70-228-an elective for MCSE/MCSA certification and a core exam on the MCDBA track.
Course Benefits

This SQL Server 2000 administration training course provides delegates with the knowledge and skills required to install, configure, administer and troubleshoot Microsoft SQL Server. The course provides extensive hands-on practical experience to build and develop competence and abilities in tasks such as installation, backup, recovery and managing security using SQL Server's tools. Official Microsoft courseware.

You Will Learn How To

  • Install or upgrade to SQL Server 2000
  • Configure database options-capacity, connectivity, and performance
  • Automate data transfer and manipulation with Data Transformation Services (DTS) packages
  • Use SQL Server replication services
  • Manage security-authentication, logins, permissions, and alerts
  • Monitor and fine-tune system performance with tools such as SQL Server Agent, SQL Profiler, and the Windows® System Monitor
  • Perform backups and restorations

Course Content

Overview of SQL Server 2000
What Is SQL Server 2000? | What Are the SQL Server 2000 Components? | What Is the Relational Database Architecture? | What Is the Security Architecture?

Installing SQL Server 2000
Planning to Install SQL Server 2000 | Deciding SQL Server 2000 Setup Configuration Options | Running the SQL Server 2000 Setup Program | Using Default, Named, & Multiple Instances of SQL Server 2000 | Performing Unattended & Remote Installations of SQL Server 2000 | Troubleshooting a SQL Server 2000 Installation

Preparing to Use SQL Server 2000
Reviewing the Results of Installation | Starting, Stopping, Pausing, & Modifying SQL Server 2000 Services | Working with Osql, SQL Query Analyzer, & SQL Server Enterprise Manager

Upgrading to SQL Server 2000
Preparing to Upgrade | Performing a Version Upgrade from SQL Server 7.0 | Performing an Online Database Upgrade from SQL Server 7.0 | Performing a Version Upgrade from SQL Server 6.5

Understanding System and User Databases
Understanding the Database Architecture | Understanding the Transaction Log Architecture | Understanding & Querying System & Database Catalogs

Creating & Configuring User Databases
Creating a User Database | Setting Database Options | Managing User Database Size Using Automatic File Growth Appropriately | Placing Database Files on Multiple Disks

Populating a Database
Transferring & Transforming Data | Introducing Microsoft Data Transformation Services (DTS) | Transferring & Transforming Data with DTS Graphical Tools | Working with DTS Packages | Using the Bulk Copy Program (Bcp) & the BULK INSERT Transact-SQL Statement

Developing a Data Restoration
Understanding Data Restoration Issues | Understanding the Types of Database | Understanding the Restoration Process

Backing Up and Restoring SQL Server
Understanding Backup Terms, Media, & Devices | Backing Up Databases, Files, Filegroups, & Transaction Logs | Restoring a User

Managing Access to SQL Server 2000
Understanding the Authentication Process | Understanding the Authorization Process | Creating & Managing Logins

Managing SQL Server Permissions
Granting Database-Specific Permissions | Using Application Roles | Designing an Access and Permissions Strategy

Performing Administrative Tasks
Performing Configuration Tasks | Setting Up Additional Features | Performing Maintenance

Automating Administrative Tasks
Defining Operators | Creating Jobs | Configuring Alerts | Creating a Database Maintenance Plan | Creating Multiserver Jobs

Monitoring SQL Server Performance & Activity
Developing a Performance Monitoring Methodology | Choosing Among Monitoring Tools | Performing Monitoring Tasks

Using SQL Server Replication
Introducing Replication | Planning for Replication | Implementing Replication | Monitoring & Administering Replication

Maintaining High Availability
Using Standby Servers | Using Failover Clustering

Copyright 1990 - 2013 - WebTech Training & Development - C#.net training vb.net training SQL Server training Delphi training ASP.net training Java training UK


home ] contact ] courses ] register ]