Microsoft SQL Server 2005 Administration Tutorial - Training Videos

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

Microsoft SQL Server 2005 Administration Tutorial CD

Affordable Training you can depend on
This Microsoft SQL Server 2005 Administration 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 7 hours long these Microsoft SQL Server 2005 Administration 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 2005 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 2005 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 2005 Administration training video click one of the links below.

Microsoft SQL Server 2005 Administration 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.

Welcome/Introduction

Installing SQL Server 2005

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 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 2005 Administration
Instructor	:	Mark Long / Certified Instructor
Price	:	US$ 99.95
Duration	:	7 hours - 92 Movies
OS	:	Win Vista XP 98,2000,ME. Mac OS 9, OS X
Delivery Options	:	Ground / 2 day / Next Day
Product Code	:	33682

BENEFITS OF THIS TRAINING COURSE

Master Microsoft SQL Server 2005 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.