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

Main Links

Product Info



What Would you Like to Learn Today?

Attention! This Week's Special Offer

Info on Sample Demos

      Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality.

      Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials. Please do not hesitate to contact us for download help.


- See right for full details on this beginners Microsoft SQL Server 2005 Tutorial

- See far right to purchase this Microsoft SQL Server 2005 Training CD

Microsoft SQL Server 2005 Tutorial Administration
 Professionally created, self-study video training.

About this Tutorialshow details
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...
Learn this Software - See below for FREE TUTORIALS
LATER VERSIONS AVAILABLE
View the more recent
Microsoft SQL Server 2012 Tutorial

Or, see our complete range of
Microsoft SQL Server Tutorials


Each Course on 1 or 2 CDs
For Mac and PC

FREE Shipping on ALL Orders
Microsoft SQL Server 2005 Tutorial Administration Info

CLICK HERE TO BUY THIS CD
Tutor: Mark Long
Duration: 7 hrs / 92 video lessons
Cost for UK: £79.95 + VAT
Cost for EU: €84.95 + VAT
Cost for US & Canada: $124.95
Product Code: 33682
Delivery: Please allow 2-3 days for UK & Europe, 3-5 days US & rest of world

IN STOCK

- All CDs Shipped Carriage FREE -
Compatibility: MS Windows 8, 7, Vista, XP, 2000, 98, NT, Mac OS X, OS 9
 

Share |


DON'T TAKE OUR WORD FOR IT, SEE OUR CUSTOMER TESTIMONIALS


Benefits of this Software Training
  Tuition by expert tutors.
  Narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter.
  Learning is fast as the trainers provide a beginners guide using simplistic terms and minimal jargon.
  Personal Tutoring - Step-by-step video training from your own desktop. Delivered via best selling DVD/CD training or online tuition.
  The tutor transfers knowledge to you quickly and effectively.
  All the concepts of each application are explained clearly and precisely.
  Every course works on PC and Mac.
  Alternative to a boring book or manual and expensive training courses, seminars, workshops & classes.
  Jump to and from lessons - learn at your own pace.
  The visual and practical nature shortens the learning curve compared to standard training manuals and for dummies books.
Customer Testimonials
Associated Training CDs:
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 | Complete Range of Microsoft SQL Server Tutorials
 
CD CONTENTS & FREE VIDEO TUTORIALS
Click on any linked lesson below for a FREE demo
Purchased CD tutorials have a higher sound & video quality.

Welcome/Introduction
Introduction
SQL Server Overview
SQL Server History
Course Objectives
Transact SQL
Course Overview
SQL Server Mystique

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

Administrative Tools
Management Studio Overview
Registering Servers
Object Explorer
Executing TSQL Queries
Management Studio Solutions
Server Configuration Manager
SQLCMD
SQLCMD Variables
Dedicated Administrator Connection

We hope you enjoyed the FREE lessons above. To view the complete contents, including ALL the lessons below and above, please purchase the CD.

 CLICK HERE TO BUY THIS CD

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


CLICK HERE TO BUY THIS CD