Easy to follow Microsoft SQL Server 2005 Admin Tutorials and online training courses. These professionally created videos offer the user an accelerated way to master this application from the comfort of their own desktop. In addition to the Microsoft SQL Server 2005 Admin tutorials we also list over 400 additional titles amounting to over 4000 hours, get unlimited access to all these courses for just $30 per month.

Microsoft SQL Server 2005 Admin Tutorial Try for FREE

Select a tutorial category

Discounted Training Courses

Members of the VTC Online University have unlimited access to this tutorial. At the moment, you are in demo mode and only the first 3 chapters will play. But members have access to EVERY SINGLE TITLE IN OUR RANGE, i.e., over 40,000 tutorials on 400+ titles all with expert tutors. Where else can you get high quality one to one training for just $30.00 per month!

Benefits

01. Unlimited viewing.
02. Downloadable working files.
03. Expert instructors.
04. Use at home / work or both.
05. Works on PC or Mac.
06. Telephone Tech support.
07. Cancel at any time.
08. 300+ courses for 1 low fee.
09. New titles added regularly.
10. 100% Guaranteed

Should you need any help, just call - contact details at the bottom of the page.

Click here to Join

Unlimited Professional Training on over 400+ applications and programming languages for only $30.

The fastest and most cost effective way to learn! Forget boring books! No need for expensive classroom training - just easy to follow training videos that play right from your own computer. Login from home or office - the choice is yours. All courses are taught by world leading experts, unlimited access, on over 400 different subjects.

Please Note:
You are in Demo mode which only allows access to the first 3 chapters of this Microsoft SQL Server 2005 Admin training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining. If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 400 professionally created video tutorials, you will be able to access the content from any location and no restrictions are placed on the amount of content you can watch, you can also cancel at any time you wish. Over 4000 hours of training for just $30.00.

Can also be Viewed using Flash

Topics covered on this course include:

Welcome/Introduction

Installing SQL Server 2005

SQL Server 2005 Editions Demo
Preparing To Install SQL Server 2005 Demo
Hardware Requirements Demo
Working With Previous Versions Demo
SQL Server 2005 Installation Demo
Installing SQL Server 2005 Pt.1 Demo
Installing SQL Server 2005 Pt.2 Demo
Changing & Deleting SQL Server Demo
Default & Named Instances Demo
Getting Assistance Demo

Administrative Tools

SQL Server Security

Securing SQL Server 2005
Authentication Modes Pt.1
Authentication Modes Pt.2
Principles
Permissions
Securables
Managing Logins
Managing Users
Schemas
Managing Schemas
Managing Permissions
Managing Server Permissions
Managing Database Permissions
TSQL Permissions

System Databases

System Databases
System Database Concerns
Sample Database

Databases

Creating A Database Pt.1
Creating A Database Pt.2
Database Properties & Options
Generating Scripts
Shrinking Database Files
Creating Tables Pt.1
Creating Tables Pt.2
Datatypes Pt.1
Datatypes Pt.2
Primary & Foreign Keys
Diagrams

Transaction Logs

How Transaction Logs Work
Transactions Explained
Explicit & Implicit Transactions
Location, Location, Location
Advantages Of Using Transactions Logs
Transaction Log Options

Data Storage

How SQL Server Stores Data
Fillfactor
DBCC Showcontig

SQL Profiler

Profiler
Using SQL Profiler Part1
Using SQL Profiler Part2

Automating SQL Server

Automation Overview
SQL Server Agent Service
Creating Operators
Creating Jobs Pt.1
Creating Jobs Pt.2
Creating Alerts
Alert Considerations

Database Backups

Backup Strategy
Database Recovery Models
Which Files and When
Performing A Backup
SQL Backup Statement
Transaction Log Backups
Backup Types

Restoring Data

SQL Server Recovery Process
Restoring A Database
The Restore Statement

High Availability

SQL Server High Availability
Clustering
Standby Servers
Log Shipping
Database Mirroring

Database Maintenance

Memory Management Basics
Maintenance Plan Creation

Course Wrap-Up

Course Wrap-Up

Credits

About The Author

Microsoft SQL Server 2005 Admin Course Details

Microsoft SQL Server 2005 Admin Training Course
Author:	Mark Long Other Training by author
Duration:	7 Hours
No. of movies	92

Benefits:
Join the VTC Online University and you will have UNLIMITED access to this tutorial and all the others in the entire library for just US $30 a month. That's over 4000 hours worth of high quality training for one low price of less than $1 a day. Click here to Join

Own this Training Course on CD

If you would like to own this SQL Server 2005 training title on CD, you may purchase it from our online store, because we don't have to use the same level of compression on the CDs as we do with the online, the audio and video playback is of a higher quality. For a single low payment you can buy this
SQL Server 2005 tutorial on CD.

Free Certification - Prove your Skills

After you have completed a tutorial, a Certificate of Completion can be obtained to verify that you have taken a particular course. All certificates are FREE, but the training course must be completed before a certificate can be issued.

Customers Comments

I take my hat off to the Apex Web Media crew!!!! KEEP UP THE GOOD WORK, YOU HAVE GOTTEN A CUSTOMER FOR LIFE, JUST CAUSE OF YOUR FRIENDLY PROMPT RELIABLE SERVICE and a GREAT PRODUCT TOO!!"
Steven Wadley
CA, USA

Easy to Use QuickTime Format

QuickTime 348 In order to view the training, you must have the latest version of QuickTime installed. Please note that the online movies have been compressed for quicker downloads, CDs and DVDs have far higher audio and video quality.