PRODUCT INFO

Product Guarantee

Testimonials

MAIN LINKS

Multi User Training CDs

	This Week's Special Offer NEW TITLE DISCOUNT!
Adobe Photoshop Elements 10 Tutorial

Quicktime is required for the movies, click here to download if needed.
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 Microsoft SQL Server 2008 Tutorial

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

- Learn this relational database management system with its primary query language, Transact-SQL, in a very short space of time with the help of this professional video training method.

Microsoft SQL Server 2008 Tutorial

Professionally created, self-study video training.

About this Tutorial

show details

Learn the installation and administrative functions of this powerful relational model database server with the help of this easy-to-follow Microsoft SQL Server 2008 tutorial. Presented by experienced trainer Mark Long, he uses step-by-step video based training movies to help explain and demonstrate to important concepts and features, helping you to analyze, query, report, search, synchronize and do a whole lot more with your valuable data. This course commences from the absolute basics and provides tuition in a progressive manner as each tutorial builds upon the lessons taught in the previous, ensuring a steady learning curve. You can start learning right away, see below for the full training contents and click any of the blue linked lessons for FREE SQL Server 2008 video tutorials...

hide details

Learn this Software - See below for FREE TUTORIALS

CLOSELY RELATED TITLES

We also have the
Microsoft C# 2008 Tutorial,
Microsoft Visual Basic 2008 Tutorial

And the
Microsoft Visual Studio 2008 Tutorial

Each Course on 1 or 2 CDs
For Mac and PC

FREE Shipping on ALL Orders

Microsoft SQL Server 2008 Tutorial Info
	CLICK HERE TO BUY THIS CD
Tutor: Mark Long
Duration: 6 hrs / 70 video lessons
Cost for UK: £79.95 + VAT
Cost for EU: €84.95 + VAT
Cost for US & Canada: $124.95
Product Code: 34097
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 7, Vista, XP, 2000, 98, NT, Mac OS X, OS 9

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 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

CD CONTENTS & FREE VIDEO TUTORIALS

Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left

Introduction

Welcome

Course Overview

SQL Server Basics

Getting Hands On

Microsoft SQL Certifications

SQL Server Editions

Installing SQL Server 2008

Hardware Requirements

SQL Server Instances

SQL Server Components

Collation Choices

Service Accounts

Creating Service Accounts

Installing SQL Server 2008 - Lesson 1

Installing SQL Server 2008 - Lesson 2

Installing SQL Server 2008 - Lesson 3

Upgrading SQL Server 2008

SQL Server Configuration Manager

SQL Server Authentication Modes

Changing Authentication Modes

SQL Server Management Studio

SQL Server 2008 Databases

File Types

Transaction Log

System Databases

File Placement

Creating a Database

Autogrowth

Database Options

Sizing the Transaction Log

Schemas

Default Schema

Creating a Schema

Moving Data Files

Installing Sample Databases - Lesson 1

Installing Sample Databases - Lesson 2

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

Maintaining SQL Server
Hiding System Objects
SQL Server Agent
Creating a Maintenance Plan
Understanding Operators
Understanding Jobs
Understanding Alerts

Server Management
SQL Server Options
Registering Servers
Server Configuration
Activity Monitor
Database Mail - Lesson 1
Database Mail - Lesson 2
Database Mail - Lesson 3

Maintaining The Database
Maintaining the Database
Database Backup - Lesson 1
Database Backup - Lesson 2
Backup Compression
Backup Devices
Managing the Transaction Log
Restoring the Database

Monitoring & Troubleshooting
Dedicated Administrator Connection
SQL Profiler - Lesson 1
SQL Profiler - Lesson 2
Log File Viewer
Event Forwarding

Optimizing Performance
Using Filegroups
Partitions
Partition Planning
Database Tuning Advisor - Lesson 1
Database Tuning Advisor - Lesson 2

High Availability
High Availability Options
Failover Clustering
Database Mirroring
Log Shipping

Conclusion
Course Wrap Up

Credits
About the Trainer


[ Home \| Video Training CDs/DVD \| Site Map \| Resources \| Specialist Categories \| Specialist Categories 2 \| Specialist Categories 3 ]
UK & Europe Marrutt Software Training Bellbrook Industrial Estate Uckfield, East Sussex, TN22 1QL United Kingdom UK Tel: +44 (0) 1825 764057 UK Fax: +44 (0) 1825 768841	US & Canada Marrutt Software Training 244 5th Ave # 1877 New York, NY 10001 United States US Tel: 646-736-7932 US Fax: 646-895-7649