About Us|Contact Us|Learn Now: Find a Course
Like us and Save!  Join our Mailing List and Save!
Connect with us for News & Exclusive Offers:
View Cart
Contact Us
Microsoft SQL Server 2005 Administration Tutorial
A professionally created, self-study video training course
Includes 7 hours of easy to follow Microsoft SQL Server 2005 Administration video tutorials presented by an industry expert.
The training is delivered to your desktop allowing you to learn at a time that suits you and at your own pace.
You can start learning online right away. Sample Microsoft SQL Server 2005 Administration tutorial videos by clicking a blue link below:
  • Tutor: Mark Long
  • Duration: 7 hours
  • Video lessons: 92
  • Product code: 33682
  • In stock: YES
If you really want to get to grips with this powerful database solution then you might like to take a look at this beginners Microsoft SQL Server 2005 tutorial.

Using step by step video training movies, expert author Mark Long demonstrates all the essential concepts and techniques, which will help you master MS SQL Server in the shortest time possible.

You can sample this highly effective training method right now, click any of the blue linked lessons below for FREE MS SQL tutorials...
What Our Customers Are Saying

"I have been recently been using your Photoshop training to demonstrate techniques to my students. I've been trying to persuade them to purchase it themselves, as I believe it to be an excellent training tool, and the best instructional CD on this subject to date by far! Not only is it easy to follow and presented clearly, but it is also a bargain."Joe Doyle Vista Community College, Berkeley, CA
COMPLETE COURSE CONTENTS
We hope you enjoyed the free lessons. To view the complete contents, including all lessons below & above, please purchase the full course via online subscription.
Paid Content
Section

Get all lessons with purchase

SQL Server Security
Securing SQL Server 2005
Authentication Modes - Lesson 1
Authentication Modes - Lesson 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 - Lesson 1
Creating A Database - Lesson 2
Database Properties & Options
Generating Scripts
Shrinking Database Files
Creating Tables - Lesson 1
Creating Tables - Lesson 2
Datatypes - Lesson 1
Datatypes - Lesson 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 - Lesson 1
Creating Jobs - Lesson 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
MS SQL Tutorial Wrap Up

Purchase Info
PRICE
This course is available via a 3 month and a 1 year online subscription and is priced as below:
3 Month Online Subscription (90 days)
  US/Can $89.94

UK £57.55 + VAT

EU €61.15 + VAT
1 Year Online Subscription
30% OFF!
  US/Can $249.99

UK £159.96 + VAT

EU €169.96 + VAT
Once subscribed, you will receive 92 Microsoft SQL Server 2005 Administration training videos (listed left), lasting a total of 7 hours.


*no further discounts can be applied to the online subscription.

Worldwide
Shipping
Delivery Details
Subscription Access codes will be sent when payment processed (within one hour average)
|
Need to Train Multiple Users?
This Microsoft SQL Server 2005 Administration course is available in multi-user format ideal for corporate users, schools and universities.

The course loads directly onto your server and delivered to multiple users over your network.

An unlimited number of users can access the training with a pre-determined number viewing the tuition at any one time.

Training Multiple Users

Load onto your server
Deliver on your network or existing learning management system


USING THE SAME EXCELLENT CONTENT AS SINGLE USER COURSES
For companies and educational establishments wanting multi user access to training resources, we offer this Microsoft SQL Server 2005 Administration course to do just that.
Now you can integrate training or technical support within your own computer network, or allow employees or students to gain access to training and support from home or any other location that they can gain access to your organizations network.

EASILY VIEWED OVER A NETWORK
The courses can be played over a LAN using a standard browser such as Microsoft Internet Explorer, Safari or Firefox.
The movies are viewed using Adobe Flash (same method as YouTube) and are slightly compressed in order to not clog the network.
All advanced and the "for dummies" courses are available via this multi user solution and can be copied directly to a hard disk for faster access and the access page may be customized, if needed, using a html editor.

ADDITIONAL USERS AND TITLES CAN BE ADDED
More than one title can exist on your server and the supplied player will automatically show titles that are available.
Simply purchase more user licences (supplied as files) and drop them into the folder. This will automatically increase the number of users allowed onto the system. All purchases are backed up by excellent after-sales support team and easy to follow instruction manual.
You can order multi user online or speak to our knowledgeable sales team.
Multi users are sold in 10 user licenses. For each 10 user licenses, you can have up to 10 people viewing that training at any one time.
Closely Related Courses
See our complete range of Microsoft Windows Server Tutorials
See our complete range of Microsoft SQL Server Tutorials
Prove Your Capabilities
Once a course is completed you can download a free certificate.

This certifies that you have started from the beginners level, have now viewed all instruction. The certificate advises you now possess essential skills and an in-depth knowledge of Microsoft SQL Server 2005 Administration. Show your boss or potential employer!
Weekly Specials
    Get 10% Off Today! Join our Email Newsletter
     
This Weeks Special Offer
See the new and discounted
Network Technology and Security Tutorial
Recommended courses to watch next
Microsoft SQL Server 2012 Certification Exam 70-463 | Microsoft SQL Server 2012 Certification Exam 70-462 | Microsoft SQL Server 2012 Certification Exam 70-461 | Microsoft SQL Sever 2000 Admin | Beginners Microsoft SQL Reporting | Microsoft SQL Server 2000 Database Programming | FileMaker Server 8 | Microsoft Small Business Server 2003 | Microsoft .NET Framework 2.0
A recent customer speaks out...
"Your Products are the best example of CD and internet computer training I've seen."Christine Maggio Abacus Technology, Inc., NJ