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
GET UP TO 30% OFF WITH ENHANCED PROMOTION CODES! CLICK HERE TO GET YOURS (UNTIL SUNDAY 27th JULY)




- 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 Tutorialshow 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...
Learn this Software - See below for FREE TUTORIALS
2012 BUNDLE COURSE:
We also have the
MCSA: SQL Server 2012 Bundle Tutorial
This includes the SQL Server 70-461, 70-462 and 70-463 courses


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
UK Price: £79.95 + VAT

EU Price: €84.95 + VAT

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 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.
  You can jump to and from lessons allowing you to learn at your own pace.
  The visual and practical nature shortens the learning curve compared to standard training manuals, basic handbooks, and for dummies books.
Customer Testimonials
Associated Training CDs:
Microsoft SQL Server 2012 Certification Exam 70-463 | Microsoft SQL Server 2012 Certification Exam 70-462 | Microsoft SQL Server 2012 Certification Exam 70-461 | Real Application Clusters in Oracle 11g | Beginners Java Programming | PHP & MYSQL | Beginners C++ | Microsoft Word Tutorials | Microsoft Excel Tutorials | Complete Range of Microsoft Video Tutorials | 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.

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

CLICK HERE TO BUY THIS CD