Easy to follow Microsoft SQL Server 2000 Admin Tutorial Videos and online training courses. These professionally created videos offer the user an accelerated way to master this application from the comfort of their own desktop. In addition to the Microsoft SQL Server 2000 Admin tutorials we also list over 600 additional titles amounting to over 4000 hours, get unlimited access to all these courses for just $30 per month.

Microsoft SQL Server 2000 Admin Tutorial Video - Try for FREE

We Have A Later Version Available
Microsoft SQL Server 2008 Tutorial Videos

Unlimited Professional Video Training on over 600+ applications and programming languages for only $30.

The fastest and most cost effective way to learn!
Forget boring books! No need for expensive classroom training.

Easy to follow tutorial videos that play right from your own computer. Login from home or office -- the choice is yours. All tutorials are taught by world-leading experts, giving you unlimited access to over 600 different subjects for an amazing low price!

Benefits of Online Learning

Unlimited viewing. No Hidden Costs
Downloadable working files.
Instant Access
Expert instructors.
Use at home / work or both.
Works on PC or Mac.
Telephone Tech support.
Cancel at any time.
600+ courses for 1 low fee.
New titles added monthly.
100% Guaranteed

Your are currently in Demo Mode
You are in Demo mode which only allows access to the first 3 chapters of this Microsoft SQL Server 2000 Admin training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining.

If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 600 professionally created video tutorials, you will be able to access the content from any location, no restrictions are placed on the amount of content you can watch, and you can also cancel at any time you wish.
Over 4000 hours of training for just $30.00.

Get Instant Access to this Training Title and over 600 other video tutorials for just $30
Once a member you will have instant unrestricted access to this and every other title listed on this site. That’s an Amazing 6000+ hours worth of high quality video training for just $30.00 a month.

Try a Free demo, Click on any of the links below

Topics covered on this tutorial video include:

A Few Words About SQL Server

Overview

Overview of Course

General Database Information

General Administrative Responsibilities

Real World Administration
Designing/Building Databases
Data Maintenance/Transfer
Backup/Restore of Data
Security

Hardware Requirements

Minimum Hardware Requirements
Hardware Compatibility
Optimizing Hardware for SQL Server

Installing SQL Server 2000

SQL Server 2000 Editions
Licensing
Multiple Instances
Choosing a Security Mode
Collation and Sort Selection
Network Libraries
Installation Methods
Upgrading to SQL Server 2000
Default Databases
Installation
Troubleshooting an Installation

SQL Server Security

Security Overview
Authentication Modes
Roles
Assigning Permissions
Application Roles

System Services

SQL Services
SQL Services Issues

System Databases

System Databases
Sample Databases

Data Storage

How SQL Stores Data
Fillfactor
File and Log Location/Management

Administrative Tools

Overview of Admin Tools
Exam Considerations

Enterprise Manager

Microsoft Management Console
Opening & Customizing the Enterprise Mgr
Using the Enterprise Manager

Query Analyzer

Opening and Exploring the QA
Issuing Queries Using the QA
Query Analyzer Features
Graphical Query Plan

Transact-SQL Select Statement

Using a Select Statement
Basic Syntax
Select Options
Important Select Considerations

Transact-SQL Insert Statement

Using an Insert Statement
Basic Syntax
Insert Options/Considerations

Transact-SQL Update Statement

Using the Update Statement
Basic Syntax/Options
Important Update Considerations

Transact-SQL Delete Statement

Using the Delete Statement
Basic Syntax/Important Considerations

Creating a Database

Using the Create Database Statement
Database Properties and Options
Database Creation Considerations
Managing File Growth
Shrinking Database Files
Sizing the Database
Importance of Good Design

Transaction Logs

How Transaction Logs Work
What Transactions Look Like
Location / Location / Location
Advantages of Using Transaction Logs
Transaction Log Options

Filegroups

What Are Filegroups?
Advantages of Filegroups
Disadvantages of Filegroups
Microsoft's Recommendation on Filegroups

RAID & SQL

RAID Basics
SQL and RAID

SQL Profiler

What SQL Profiler Does
Opening SQL Profiler
Using SQL Profiler

Operators

What are Operators?
Creating an Operator
Considerations When Using Operators

Jobs

Automating SQL Server
Mail Enabling SQL Server 2000
Creating a New Job
Scheduling a Job
Job Notifications
Starting/Stopping a Job
Multi Server Jobs
Viewing Job History

Alerts

What are Alerts
Performance Alerts
User Defined Alerts
Disabling Alerts
Considerations When Using Alerts

Linked Servers

Using SQL In a Distributed Environment
Referring to SQL Server Objects
Setting Up a Linked Server Relationship

Database Backups

Backup Strategy
Database Recovery Models
SQL Server Backup
Who When and Where
System Databases
User Databases
Performing a Backup
Using Multiple Devices
SQL Backup Statement
Tape Backup
Backup Types
Transaction Log Backups
File and Filegroup Backups
Full Backup Strategy
Differential Backup Strategy
Backup Review

Restoring Data

SQL Server Recovery Process
Preparing to Restore a Database
The SQL Restore Statement
Restore Options
Restoring Transaction Logs
Restoring System Databases
Bottom Line on Restoring Data

Maintaining High Availability

Determining Requirements
Clustering
Standby Servers
Log Shipping

Data Transformation Services

Importing and Exporting Data
SQL Data Transport Tools
DTS Overview
Creating a DTS Package
More DTS Package Functionality
Defining Transformation Tasks Creating
Using DTS in Various Ways

Monitoring SQL Server 2000

Performance Issues
Monitoring and Tuning Basics
Improving Performance
Common Monitoring Tasks and Tools
What To Monitor
Locks

Replication Basics

Dealing With Distributed Data
SQL Server Replication
SQL Server Replication Types
SQL Server Replication Models
Replication Agents
Web Based Data Applications
SQL Server Replication Notes

Course Wrap-Up

Value of SQL Server knowledge
Microsoft's MCDBA Certification

Microsoft SQL Server 2000 Admin Video Tutorial

Title Microsoft SQL Server 2000 Admin Training Tutorial

Author Mark Long
Other Training Videos by this author

Duration 10 hours

Number of Videos 154

Only $30 a month
Unlimited Access to over 600 Titles (6000+ hours )
No Minimum Term - No Contract
Instant Access - No Restrictions

Own this Training Course on CD

Microsoft SQL Server 2000 Admin Training CD

Would you like to own this Microsoft SQL Server Training title on CD?

You may purchase it from our online store. Because we don't have to use the same level of compression on the CDs as we do with the online, the audio and video playback is of a higher quality. For a single low payment you can buy this
Microsoft SQL Server tutorial on CD.

Free Certification - Prove Your Skills

After you have completed a tutorial, a Certificate of Completion can be obtained to verify that you have taken a particular course. All certificates are FREE, but the training course must be completed before a certificate can be issued.

Customer Comments

'I got the Director CD from you. It's very good. It even covers and mentions the new features of Director . This is a good CD for people that want to learn Director and get into some of the new features. Brilliant!'
Bill Hernandez;