Improve job skills - Become more efficient - Produce better results !

Learn Microsoft SQL Server 2000 Admin (in only 9 hours)

Watch these professional training videos at your convenience. All you need is a computer or mobile device with an Internet connection. Login to learn anytime and view the videos as many times as you want.

Course Description: Virtual Training Company's Microsoft SQL Server 2000 Admin tutorial is just what you need to learn how to administer SQL Server in the real world and to help you prepare for the Microsoft Certification Exam 70-228. Mark Long, a Microsoft certified instructor, will teach you installation and building and backing up databases. He begins with general information about databases and general administrative responsibilities. He will then instruct you on the specifics of the administration of SQL Server 2000, such as installation, data storage, and file groups. You will learn the two main administrative tools, enterprise manager and query analyzer, through real-life examples. In this tutorial, you will also learn how to automate the administration and how to monitor the SQL server. To start learning right away, click on one of the video tutorials below.


Click a play button below to view a free training video. Place your order online for full access.

 

Video Tutorials Included: 152 Free Video Video Time
(minutes)

A Few Words About SQL Server

Overview

General Database Information

General Administrative Responsibilities

Hardware Requirements

Installing SQL Server 2000

SQL Server Security

System Services

System Databases

Data Storage

Administrative Tools

Enterprise Manager

Query Analyzer

Transact-SQL Select Statement

Transact-SQL Insert Statement

Transact-SQL Update Statement

Transact-SQL Delete Statement

Creating a Database

Transaction Logs

Filegroups

RAID & SQL

SQL Profiler

Operators

Jobs

Alerts

Linked Servers

Database Backups

Restoring Data

Maintaining High Availability

Data Transformation Services

Monitoring SQL Server 2000

Replication Basics

Course Wrap-Up