Self Study, Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both PC and Mac.

This Microsoft SQL Server 2005 tutorial video - training CD / DVD is 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.

Associated Tutorials: Microsoft Transact SQL | Transact SQL | Microsoft Project Training | Microsoft SQL Reporting Services | Microsoft SQL Server 2008 Development | Microsoft Server 2008 Admin 70-646 | Microsoft SQL Server Tutorial | Microsoft SharePoint 2010

SQL Server 2005 Tutorial CD / DVD

When you order this SQL Server 2005 Video Tutorial CD You'll Receive...
Over 7 hours of high quality video-based training that walks you through the program in easy to follow stages.

A training video that focuses on real life examples and teaches you
real life skills. These tutorials are structured to increase not only your skills but also your earning potential.

With this Training Video you will...
Learn SQL Server 2005 from a leading expert and quickly master the skills required to work in a commercial environment.

Learn how to simplify your workflow and increase your productivity using tips and techniques of the pros. Ideal training for Beginners and Advanced users alike

Customer Comments
" a++++ after learning how to improve my photos and images my eBay sales have gone way up...thanks! "Matthew Quinn, New York

SQL Server 2005 Tutorial CD / DVD

Create the best self-paced learning environment right on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Topics Covered on this Training Course

This Training is 7 Hours in Duration and Covers 92 Lessons.
Welcome/Introduction Installing SQL Server 2005 Administrative Tools
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 Lesson1
  • Authentication Modes Lesson2
  • 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 Lesson1
  • Creating A Database Lesson2
  • Database Properties & Options
  • Generating Scripts
  • Shrinking Database Files
  • Creating Tables Lesson1
  • Creating Tables Lesson2
  • Datatypes Lesson1
  • Datatypes Lesson2
  • 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 Lesson1
  • Creating Jobs Lesson2
  • 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

Select Playback Format for the Free Demos:

Quicktime
Flash

Did You Know ?

We offer more than 700 video-based courses, and you can watch the first three chapters of every listed course for FREE with no obligation to buy.

Later Title Available
A more recent video tutorial is available
Microsoft SQL Server 2008 Tutorial »

About this SQL Server 2005 Training CD

Title SQL Server 2005
Tutor Mark Long
Other tutorials by Mark Long
Videos 92 Lessons- Video run time: 7 hours
Compatibility Vista, XP, Windows 7, Mac OSX
Released 2006
Work files Yes
Availability Immediate Dispatch
Price US / Canadian Sales Only $99.95
Closed Captions Closed Captions are not Enabled on this title
328 in stock
Purchase Orders from Schools, Colleges, Government and Military Accepted

Mutli User Training Options

This training video is also available in Multi-user format, ideal for Schools, Universities, or Corporate users where training multiple delegates is the most cost effective way of training.

10 Multi User $500

Not Sure Which Titles to Buy? Unlimited Access to all -$30

Need to learn more than one topic? Get Unlimited Access to all the courses listed on this site for just $30!
Unlimited Access to over 70,000+ Training Videos

Not sure which training CD titles to purchase? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
No contract .
No minimum period.
No commitment on your part.

Within minutes you'll have instant, unlimited access to over 700 courses covering over 6000+ hours of training, all from the comfort of your own desk.

Need to learn from more than one location? Not a problem, you're free to access the training from anywhere you wish. It's highly cost effective learning with no limits. We also offer Multi User accounts for companies and schools who need to train multiple users.
Online Learning with No Limits

Why Is This Training Format So Effective?

  • Learn SQL Server 2005 from an accredited expert in days.

Want to hear what our customers say about our products?

Prove your Knowledge - Free Certificate

Prove Your Credentials!
Free Certificate.