Self Study, Tutorial Video on CD - DVD. Tutor Mark Long guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. It works on both PC and Mac, this course is ideal for Beginners and Advanced users
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. . Watch our free SQL Server 2005 Tutorial Videos by clicking the blue lesson links below.
SQL Server 2005 Tutorial CD / DVD
Create the best self-paced learning environmentright on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.
Learn 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.

- Professional Tuition from an Expert
- Free Certificate with Each Tutorial
- Works on PC or Mac

Welcome/Introduction
- Introduction

- SQL Server Overview

- SQL Server History

- Course Objeectives

- Transact SQL

- Course Overview

- SQL Server Mystique

- SQL Server 2005 Editions

- Preparing To Install SQL Server 2005

- Hardware Requirements

- Working With Previous Versions

- SQL Server 2005 Installation

- Installing SQL Server 2005 Lesson1

- Installing SQL Server 2005 Lesson2

- Changing & Deleting SQL Server

- Default & Named Instances

- Getting Assistance

- Management Studio Overview

- Registering Servers

- Object Explorer

- Executing TSQL Queries

- Management Studio Solutions

- Server Configuration Manager

- SQLCMD

- SQLCMD Variables

- Dedicated Administrator Connection

- 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 Database Concerns
- Sample Database
- 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
- How Transaction Logs Work
- Transactions Explained
- Explicit & Implicit Transactions
- Location, Location, Location
- Advantages Of Using Transactions Logs
- Transaction Log Options
- How SQL Server Stores Data
- Fillfactor
- DBCC Showcontig
- Profiler
- Using SQL Profiler Part1
- Using SQL Profiler Part2
- Automation Overview
- SQL Server Agent Service
- Creating Operators
- Creating Jobs Lesson1
- Creating Jobs Lesson2
- Creating Alerts
- Alert Considerations
- Backup Strategy
- Database Recovery Models
- Which Files and When
- Performing A Backup
- SQL Backup Statement
- Transaction Log Backups
- Backup Types
- SQL Server Recovery Process
- Restoring A Database
- The Restore Statement
- SQL Server High Availability
- Clustering
- Standby Servers
- Log Shipping
- Database Mirroring
- Memory Management Basics
- Maintenance Plan Creation
- Course Wrap-Up
- About The Author
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 |
| Delivery time: | Only 3 working days |
| Compatibility: | Vista, 2000, XP, Windows 7, Mac OS, OSX |
| Released | 2006 |
| Work files | Yes |
| Price Australia / New Zealand & Asia | AUD $149.95 (+ $10.00 Shipping ) |
172 In Stock

- Learn SQL Server 2005 from an accredited expert in days.
- Ideal for beginners, these easy to follow videos offer visual clarity.
- Master a full application from basics to advanced for a fraction of the cost of classroom based training, and faster than with a manual.
- Unique teaching method that offers accelerated learning and high retention.
- Used by many large companies, schools, universities,
click to see some of our customers. - Learn from your own desk at a speed that suits you.
- It's cost effective tuition from leading expert tutors.
- Learn at your own pace; training can be stopped, rewound or fast forwarded as required.
- These High Quality Tutorial Videos are on CD / DVD or Online and PC / Mac Compatible. It's Simply the best tuition at an affordable price
Want to hear what our customers say about our products?
Microsoft Transact SQL | CompTIA A+ Certification | Transact SQL | Microsoft Project Training | Microsoft SQL Reporting Services | Microsoft SQL Server 2008 Dev | Microsoft Server 2008 Admin 70-646
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.
You can have access to every title we list on this site for just $30 per month. When you sign up, you get instant access with absolutely no restrictions or limits. Log on from any location and learn as much as you like.



