Microsoft SQL Server 2005 Admin Tutorials

Details

Highly Effective SQL Server 2005 tutorials on video CD, learn from your own desk at a pace that suits you. Low cost high quality training at an affordable price. Works on PC and Mac.

 

These Microsoft SQL Server 2005 tutorials are an excellent way for users to learn how to unleash the full power of this application. Taught by Microsoft Certified trainer Mark Long users will find learning even the more complex issues of SQL Server simple, the lessons are presented via narrated QuickTime tutorials that bring a degree of clarity that no other form of training can match. For comprehensive details of all topics covered on this training CD and a free demo see the list below.
Close
SQL Server 2005 Training CD / DVD Contents
Professionally created, comprehensive training that's easy to follow at an unbelivable price.

See the quality for yourself. Try a FREE Demo.

The blue links below are Free SQL Server 2005 Tutorial Videos.

Try for FREE - NOW
To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.

Read before watching the free videos
The sound quality and frame rate of free online tutorials has been reduced to allow for faster streaming. The quality on CD / DVD is far higher.
Quicktime
*QuickTime is needed to view the videos. Some titles have been converted to play via Flash.
This tutorial can also be viewed using Flash:
Click To View in Flash
Welcome/Introduction Introduction Demo
SQL Server Overview Demo
SQL Server History Demo
Course Objeectives Demo
Transact SQL Demo
Course Overview Demo
SQL Server Mystique Demo 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 Management Studio Overview Demo
Registering Servers Demo
Object Explorer Demo
Executing TSQL Queries Demo
Management Studio Solutions Demo
Server Configuration Manager Demo
SQLCMD Demo
SQLCMD Variables Demo
Dedicated Administrator Connection Demo
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$99.95
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

SQL Server 2005 Training CD Information

Title : SQL Server 2005
Tutor : Mark Long
Other tutorials and training by this author
Movies : 92 Lessons- Video run time: 7 Hours
Availability : Immediate Dispatch
Compatibility: Vista, 98, 2000, NT, XP, Mac OS, OSX
Released 2006-03-16
Work files Yes
Price US / Canadian Sales $99.95

188 In Stock

Add to Cart

Why use this method of video training ?
  • Learn SQL Server 2005 from an accredited expert in days.
  • Ideal for beginners, easy to follow videos that offer visual clarity.
  • Master a full application for a fraction of the cost of classroom based training.
  • Unique teaching method that offers accelerated learning and high retention.
  • Used by many large companies, schools, universities,
  • Learn from your own desk at a speed that suits you
  • Cost effective tuition from leading experts
  • You control the pace, training can be stopped, rewound or fast forwarded as required.

Associated Titles:

Free Certificate. Prove your credentials
online people


We now offer all customers a free certificate to verify they have undertaken a SQL Server 2005 course, the unique certification number allows third parties to check the authenticity of your certificate online. After your purchase you can download your SQL Server 2005 certificate without delay.

Online University Access all our Training for only $30.00

Not sure which training CD titles to purchase ? Why not join our Online University and have unlimited access to all our titles for one low price ?

online people

over 4000 hours of high quality online training for only $30.00. Unlimited access

learn from your own desk -expert tutorials - affordable tuition.
No minimum sign up period.
Want to see how good our online university is? - Why not try a free Demo

For low monthly fee you have unlimited access to all the 300+ training titles in our range, that's over 35,000 tutorials covering 4000 hours+! Watch when ever you like, from any computer - NO LIMITS.

Join Today and learn quicker and cheaper than you ever thought possible.

Become a expert without having to read a book or attend expensive training courses.

Where else can you find step-by-step training for over 300 software applications delivered to your own desk, from a leading expert, for less then a Dollar a day ?

Want to see how good our online university is? - Why not try a free Demo, and if all that's not enough, we add new video tutorials each month for no extra charge!

Free Newsletter

If you would like to be notified as we release new video tutorials, run special offers, or promotions.
Sign up now. Your details are kept secure and never sold rented or used by any other 3rd parties.

SQL Server 2005 Related Product Groups:

FileMaker Pro | Excel Tutorials | MySQL Access Tutorials | Oracle PL/SQL | Microsoft SQL Server 2000 Admin Microsoft SQL Server 2000 Programming | Online SQL Server 2005 Training Courses