Microsoft SQL Server 2000 Admin Tutorial - Training Videos

Training CDs > Databases Tutorial Videos > MICROSOFT SQL SERVER 2000 ADMIN

Microsoft SQL Server 2000 Admin Tutorial CD

Affordable Training you can depend on
This Microsoft SQL Server 2000 Admin video tutorial utilizes an easy to follow training format that is both engaging and informative. Created to assist the beginners to intermediate users, the author uses a unique training method that brings a high degree of visual clarity to even the most complex applications. Being over 10 hours long these Microsoft SQL Server 2000 Admin tutorials are extremely comprehensive and easy to follow. Video Training by Experts - Low Cost.

Not sure which Training CDs to buy?
The Online University allows unlimited access to the entire range of training titles for one low fee of only $30 per month. There is no fixed term, no limits, and you can cancel at any time. For corporate users and schools we also offer multi user accounts.
Find out more about the online video tutorials »

About the Free Video Online Training Course Demos
To allow you to evaluate the quality of the Microsoft SQL Server 2000 Admin training course we have made the first 3 chapters of this tutorial available for free viewing online, the purchased version of this training course contains all the topics listed below. The free demos below have been compressed for faster playback over the internet, the audio and video quality of the purchased CD / DVD is far greater. To play the free demo videos you will need QuickTime,

THIS TUTORIAL COVERS THE FOLLOWING SUBJECTS

Description

The visual nature of this Microsoft SQL Server 2000 Admin tutorial videos ensures that users of all levels can learn faster than with any other method of training, users will also benefit from a much higher retention rate then with conventional forms of training. All courses are created using expert authors and recorded with studio quality audio and video, users can expect to receive the same high standard of training that would be taught on a dedicated classroom based course, but for a fraction of the cost.

Users have total control over the speed at which they learn, lessons can be stopped, rewound or fast forwarded at any time, this video tutorial is structured to accommodate both beginner and intermediate users, ideal for people that need to fit comprehensive training into a busy schedule. To sample a free demo of this Microsoft SQL Server 2000 Admin training video click one of the links below.

Microsoft SQL Server 2000 Admin Related Groups

Hide Description

The Blue Links below are free demos, when you purchase the video training CD / DVD the enitre content listings below are included , not just the free demo videos.

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
Microsofts 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
Microsofts MCDBA Certification

Microsoft SQL Server 2000 Admin Tutorials - VIDEO INFO

» Studio quality audio and video
» Works on Pc or Mac
» Ideal for people that learn quicker by being shown
» Master complex application in days

Title	:	Microsoft SQL Server 2000 Admin
Instructor	:	Mark Long / Certified Instructor
Price	:	US$ 99.95
Duration	:	10 hours - 154 Movies
OS	:	Win Vista XP 98,2000,ME. Mac OS 9, OS X
Delivery Options	:	Ground / 2 day / Next Day
Product Code	:	33369

BENEFITS OF THIS TRAINING COURSE

Master Microsoft SQL Server 2000 Admin in the shortest time possible
Self paced tutorial, training on video, at your own pace
Just sit back and watch, no books to read, just easy to follow lessons
Training can be viewed from any location, on PC or Mac
All training is self-contained; you don’t even need the application you are learning loaded on your machine
The most affordable way to learn, benefit from a world-leading expert
High quality content for a fraction of the cost of a classroom training course
The Tutorials can be rewound, fast forwarded or stopped at any time
Learn from the comfort of your own desk.