Find a Course...Try for FREE
   
Product Information
 
Shipping Information
Product Guarantee
Testimonials
 
Main Links
 
Training Categories
New Titles
In Development
Free Online Demos
Multi User Training CDs
Contact Us
 

Quicktime is required for the movies,
click here to download if needed.

Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality.

Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials please do not hesitate to contact us for help.

Microsoft SQL Server 2000 Admin Tutorial

About this Tutorial show details
Expert author Mark Long prepares you for the Microsoft Certification Exam 70-228 by describing all the basic to advanced aspects at a very easy pace. This SQL Server tutorial has the aim of helping you learn how to administer, monitor and automate the MS SQL Server in the real world.
Try this training now - See below for FREE tutorials


All Courses on 1 or 2 CDs
For Mac and PC

Microsoft SQL Server 2000 Admin Tutorial Information
CLICK HERE TO BUY THIS CD
Author: Mark Long / Certified Instructor
Duration: 10 hrs / 133369 video lessons
Cost for UK: £79.95 + VAT
Cost for EU: €107.95 + VAT
Cost for US & Canada: $125.00
Product Code: 33369
Delivery: Please allow 2-3 days for UK & Europe, 3-5 days US & rest of world
IN STOCK
- All CDs Shipped Carriage FREE -
Compatibility: Win Vista, XP, 2000, 98, NT, Mac OS X, OS 9
 
Benefits of this Software Training
 
• Transfers knowledge to you quickly and effectively.
• Step by step video training from your own desktop via CD ROM or online tuition.
• All the concepts of each application are explained clearly and precisely.
• Every course works on PC and Mac.
• Alternative to a boring book or manual and expensive training courses & classes.
• Jump to and from lessons - learn at your own pace.
• Tuition by expert authors.
Customer Testimonials
 
Associated Training CDs:
Microsoft SQL Server 2000 Database Programming | Microsoft SQL Server 2005 Administration | Microsoft SQL Server 2005 Administration | Microsoft Small Business Server 2003 | Other Microsoft Titles | Microsoft SQL Server 2008 | Complete Range of Microsoft SQL Server 2008 Tutorials
 
Complete CD Contents and FREE Video Tutorials
Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left

SQL Server Intro
SQL Server Explained
SQL Server Mystique
Transact SQL Overview
SQL Server - A Brief History

Overview
Overview of SQL Server Tutorial

General Database Information
The Purpose of a Database
The Components of a Database
2 Types of Databases Described
Normalization Overview
Denormalization Overview
Database Relationships Explained
Indexes Overview
Correct Design

We hope you enjoyed the FREE lessons above. To view the complete contents, including the chapters below, please purchase the CD.
CLICK HERE TO BUY THIS CD

General Administrative Responsibilities
Administration in the Real World
Creating Databases
Data Maintenance Explained
Backing up/Restoring Data
Security of Databases

Hardware Requirements
Chapter Overview
HW Compatibility
How to Optimise HW for SQL Server

How to Install SQL Server 2000
SQL Server 2000 Editions
Licensing
Multiple Instances Explained
Selecting a Security Mode
Collation and Sort Selection
Network Libraries Explored
Install Methods
Upgrade to SQL Server 2000
The Default Databases
Installation
Installation Troubleshoot

SQL Server Security
Chapter Overview
Authentication Modes
Roles in Security
Assigning Permissions
Application Roles Explained

System Services
SQL Services Overview
Issues for SQL Services

System Databases
Chapter Overview
Sample Databases

Data Storage
Chapter Overview and how SQL Stores Data
Fillfactor Overview
File and Log Location

Administrative Tools
Chapter Overview
Considerations for the Exam

Enterprise Manager
MS Management Console
Open and Customise the Enterprise Manager
Working with the Enterprise Manager

Query Analyzer
Query Analyzer Explored
How to Issue Queries with the Query Analyzer
Features of the Query Analyzer
Graphical Query Plan Explained

Transact-SQL Select Statement
Utilising a Select Statement
Simple Syntax
Select Options
Select Considerations to Take Note of

Transact-SQL Insert Statement
Utilising an Insert Statement
Simple Syntax
Inserting Options and Further Considerations

Transact-SQL Update Statement
Utilising the Update Statement
Simple Syntax/Options
Important Update Considerations

Transact-SQL Delete Statement
Utilising the Delete Statement
Simple Syntax/Important Considerations

Creating a Database
Utilising the Create Database Statement
Database Properties and Options Described
Considerations for Database Creation
Handling File Growth
How to Shrink Database Files
Sizing the Database - Step by Step
Practicing Good Design

Transaction Logs
Chapter Overview and how they work
What Transactions Look Like
The Importance of Location
Utilising Transaction Logs
Transaction Log Options Explained

Filegroups
Filegroups Explained
Filegroups - the Advantages
Filegroups - the Disadvantages
Microsoft's Recommendation on Filegroups

RAID & SQL
Chapter Overview
SQL and RAID

SQL Profiler
The Function of the SQL Profiler
Open the SQL Profiler
Utilising the SQL Profiler

Operators
Operators Explained
The Creation of an Operator
Using Operators - Considerations

Jobs
How to Automate an SQL Server
Mail Enabling SQL Server 2000
Create a New Job
Schedule a Job
Job Notifications Explained
How to Start and Stop a Job
Multi Server Jobs Explained
View Job History

Alerts
Alerts Explained
Performance and User Defined Alerts
Disabling Alerts
Using Alerts - Important Considerations

Linked Servers
SQL In a Distributed Environment
Refer to SQL Server Objects
How to Set Up a Linked Server Relationship

Database Backups
Backup Strategy Explained
Database Recovery Models Explored
SQL Server Backup Explored
Who, When and Where
System and User Databases - Lesson 1
System and User Databases - Lesson 2
Taking a Backup
Working with Multiple Devices
SQL Backup Statement Explained
Tape Backup - Step by step
Backup Types Explained
Transaction Log Backups
File Backups
Filegroup Backups
Full Backup Strategy
Differential Backup Strategy
Backup Summary

Restoring Data
The Process SQL Server Recovery
Restoring a Database - the Preparation
The SQL Restore Statement
Restore Options
Restoring Transaction Logs and System Databases
Bottom Line on Restoring Data

Maintaining High Availability
How to Determine Requirements
Clustering Explained
Standby Servers
Log Shipping

Data Transformation Services
Importing and Exporting Data
SQL Data Transport Tools Described
DTS Introduction
The Creation of a DTS Package
Further DTS Package Functionality
How to Define Transformation Tasks
Utilising DTS

Monitoring SQL Server 2000
Performance Surrounding Issues
Monitor and Tune - Fundamentals
How to Improve Performance
Common Monitoring Tasks and Tools
What To Monitor
Locks

Replication Basics
Dealing With Distributed Data
SQL Server Replication:
• Overview
• Types
• Models
Replication Agents
Web Based Data App.
SQL Server Replication Notes

Course Summary
Value of SQL Server knowledge
MS MCDBA Certification


CLICK HERE TO BUY THIS CD