Tutorials and Online Training Videos

Microsoft SQL Server 2000 Admin Tutorial

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.

A Few Words About SQL Server

What Is SQL Server?
SQL Server Mystique
Transact SQL
SQL Server History


Overview of Course

General Database Information

Main Purpose of a Database
What Makes Up a Database
Two Main Types of Databases
Database Relationships
Proper Design

General Administrative Responsibilities

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

Hardware Requirements

Minimum Hardware Requirements
Hardware Compatibility
Optimizing Hardware for SQL Server

Installing SQL Server 2000

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

SQL Server Security

Security Overview
Authentication Modes
Assigning Permissions
Application Roles

System Services

SQL Services
SQL Services Issues

System Databases

System Databases
Sample Databases

Data Storage

How SQL Stores Data
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


What Are Filegroups?
Advantages of Filegroups
Disadvantages of Filegroups
Microsofts Recommendation on Filegroups


RAID Basics

SQL Profiler

What SQL Profiler Does
Opening SQL Profiler
Using SQL Profiler


What are Operators?
Creating an Operator
Considerations When Using Operators


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


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
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

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

Related Books on Microsoft SQL Server 2000 Admin

Save $80 on the
by Motorola with Verizon Wireless service for less than from Verizon Wireless directly.
Save $80 on DROID BIONIC
More Cell Phone Discounts