clear-dot.gif
Search for a Title:
AddThis Social Bookmark Button
clear-dot.gif
   Master Microsoft SQL Server 2000 Admin - Free Tutorials!
clear-dot.gif
clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif
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 movie topics below.
Microsoft SQL Server 2000 Admin Training
Access the complete Microsoft SQL Server 2000 Admin Training title online with just your Web browser. Join our Online University and have unlimited access to these tutorials for Microsoft SQL Server 2000 Admin plus all our 400+ other titles for one low price! LEARN MORE or SIGN UP NOW FOR INSTANT ACCESS
OR
Learn Microsoft SQL Server 2000 Admin from our PC and Mac compatible CDRom. The affordable price of $99.95 gives you high quality software training that is easy for anyone to understand and follow. Start training straight away with our Free lesson links on the right or BUY THIS CD NOW!

Are you ready to start your learning RIGHT NOW? You can have immediate access to more than 2500 hours of VTC Training just minutes from now, and for the incredibly low price of $30/month OR LESS!

The VTC Online University provides unlimited 24/7 access to ALL of VTC's incredible training content.

-- More Info / Subscribe Now! --

FREE Updates
VTC adds training for new software every week, and with the VTC Online University, you get immediate access to these new titles, for no additional cost! There are currently over 450 different software titles, and more are added EVERY MONTH!

-- More Info / Subscribe Now! --

No Long Term Committment
With the VTC Online University, you can signup for as little as ONE MONTH only! There is no minimum time committment, and you can cancel your membership at any time.

-- More Info / Subscribe Now! --

Training a Group?
Our Multi-User Online Account makes training groups of people efficient and cost effective. Businesses, Schools (from Elementary through Post Secondary), and Government Departments alike all over the world enjoy the freedom and benefits of our online training and tutorials from office, school, home, and on the go.

-- Multi-User Licensing Info --

Microsoft SQL Server 2000 Admin
- Information About This Title -
Click Here To Purchase
Proper Title: Microsoft SQL Server 2000 Admin
Description: Click here to open / close full 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 movie topics below.

-Close-
Instructor: Mark Long/Certified Instructor (more by this author)
Instruction: 154 Tutorials - Duration: 10 hrs
First Release: 2002-07-31
Compatitibility: Vista, XP, NT, 2000, 98, Mac OS9, Mac OS X 10.1+
In Stock? Yes - 2-5 days shipping
Price: $99.95
Click Here To Purchase
Why Learn With VTC?!
  1. Let an expert teach you Microsoft SQL Server 2000 Admin
  2. No classrooms or schedules - you learn on YOUR terms
  3. No books to read - watch instructional video right on your computer
  4. VTC training methods ensure the highest possible retention and fastest learning
  5. Use VTC materials for future reference / refresher
  6. Share CDRom training with others, friends, colleagues
  7. Used by many schools, universities, and big business world wide
  8. The most cost effective training available for Microsoft SQL Server 2000 Admin
 
Below is content list for all of the lessons included with the Microsoft SQL Server 2000 Admin Training. Click on the linked lessons to watch Free. You must have Quicktime installed on your computer - if you are using a recent computer, then chances are you already do.
Free Demo Lessons

A Few Words About SQL Server
movie image What Is SQL Server?
movie image SQL Server Mystique
movie image Transact SQL
movie image SQL Server History

Overview
movie image Overview of Course

General Database Information
movie image Main Purpose of a Database
movie image What Makes Up a Database
movie image Two Main Types of Databases
movie image Normalization
movie image Denormalization
movie image Database Relationships
movie image Indexes
movie image Proper Design


... More lessons below ...

Would you like to continue? You can have instant access to the rest of this training for just $30.00 through our Online University, or you can purchase the CDRom version!

. Subscribe Now!
. Online University Info
. Purchase CDRom Now

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
clear-dot
blue dot
clear-dot

Want to be notified of new releases and other product information?
Enter your email address below to signup for our newsletter.

clear-dot
blue dot
clear-dot
Online Learning | Contact Us | Tech Support | XML RSS Feed
clear-dot
blue dot

Global Sales
1623 Military Road #703
Niagara Falls, NY, USA
14304-1745
1-877-882-2262 or sales@vtcGlobalSales.com
VTC Canada
200 N. Service Rd W., Suite 1-377
Oakville, ON, Canada
L6M 2Y1
905-465-1263 or sales@vtcCanada.com


©2008 VTC Global Sales / VTC Canada All Rights Reserved.