Home  >  Microsoft Training  >  SQL Server 2008 Training  > Advanced SQL Server 2008 Database Administration Training

Advanced SQL Server 2008
Database Administration Training

Advanced SQL 2008 Database Administration Training

Our Advanced SQL Server 2008 Database Administration Training
Teaches You: Designing, Optimizing and Maintaining
a Database Server Infrastructure and Much More.
Plus, Complete 70-450 Exam Coverage!

Advanced SQL Server 2008 Database Administration Training
Course Outline

Video 1

Course Overview

Video 2

SQL Server Setup and Installation

Video 3

Setup and Installation of SQL Server 2008

  • SQL Server 2008 Editions
  • Performing a New Installation
  • SQL Server Installation Center
  • Server Configuration
  • Database Engine Configuration & Authentication
  • Microsoft SQL Management Studio
  • Features of SQL Server
  • Hardware, Disk Space, and Software
Video 4

Upgrading to SQL Server 2008

Video 5

Indexes

  • Introduction and Overview
  • Indexes in SQL Server 2008
  • Clustered and Non Clustered Indexes
  • XML Indexes
  • Spatial Indexes
  • User Account Setup
  • Creating a Clustered or Non Clustered Index
  • Creating a Spatial Index
  • Creating an XML Index
  • Using T-SQL for Indexes
  • Rebuilding and Dropping Indexes
  • Filtered Indexes
  • Indexes Views
Video 6

SQL Server Security

Video 7

Policy Based Management

Video 8

Encryption

Video 9

Backup and Restore

Video 10

High Availability

Video 11

Failover Clustering

Video 12

Database Mirroring

Video 13

Log Shipping

Video 14

Replication

Video 15

Monitoring SQL Server

Video 16

Performance Tuning

Video 17

Resource Governor

Video 18

Using PowerShell with SQL Server 2008

Video 19

Integration Services

Video 20

SQL Server Certification



More to Come!

Advanced SQL 2008 Database Administration

Here’s What You Get When You Order Our
Advanced SQL Server 2008 Database Administration Training Today!

  • 20 videos will be provided in high-quality .AVI and .WMV format. In other words, you get perfect quality and replication of your instructors' screens. An easy-to-use table of contents allows you to navigate to key areas you wish to focus on.
  • 20 iPod video files to watch Train Signal on the go! A popular request amongst our students who wish to study while they commute (i.e. train, plane, bus). These 320x240 M4V files are compressed versions of the original course, and play on any iPod that supports video. Also great for reviewing and refreshing your mind "on the job."
  • 20 MP3 audio files to listen to Train Signal anytime, anywhere. Some of our students have requested this option. Now, you can listen in the car or while working out. Our MP3 files can be burnt to a CD or copied to a portable device.
  • Instructor Notes – These PDF documents, which can be printed out, contain the slides used by the instructors throughout the videos. These documents allow the user a quick easy reference to the instructors’ notes on the slides, and provides a place to make additional notes.

FREE FULL VERSION of Transcender’s Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008
Practice Exam! (SAVE $119!)

We’ve partnered with Transcender®, the world’s leading exam simulation provider! Their award-winning simulations look and feel so much like the actual exam, you’ll feel confident on exam day!

Transcender

These Practice Questions are the Perfect Training Companion to Our Advanced SQL Server 2008 Database Administration Course! Best of All, They’re FREE!

  • Save time by focusing your studying efforts on topics that will actually be on the exam!
  • Comprehensive references explain the reasoning behind the correct answers!
  • Detailed reports and custom exam features help identify and strengthen your weak areas!
  • Transcender Live Update ensures your study materials are always up-to-date!
Even if you’re not studying for an exam, this comprehensive exam simulator is a great tool for testing and reinforcing your SQL Server 2008 skills & knowledge!

A Tremendous Value for Your Modest Investment... Fully Backed by Our 90-Day "Total Experience" Guarantee!

Our 90-Day

A classroom course can cost as much as $1595.00 USD and does not offer the flexibility to train anytime, anywhere. Plus, our Computer Based Training allows you to replay any topic or video as many times as necessary until you are comfortable with the concepts.

Receive this high-level professional training via Train Signal for Only $799!
Limited-Time Offer Only $397!

Coming Soon!

Order Our Advanced SQL Server 2008 Database Administration Training Today, and Receive:

PROFESSIONAL TRAINING

  • Nearly 12 Hours of Advanced SQL Server 2008 Database Administration Training Videos on 3 Jam Packed DVDs!
  • Multiple File Formats Make It Convenient for You To Learn Anywhere You Go! iPod Video, Mp3 Audio, .WMV & high quality .AVI video
  • PDF of Instructor Notes allow you to follow along with the videos and take more organized notes.

70-450 EXAM PREPARATION

  • Complete Exam Coverage for the
    70-450 Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008 Exam. This course covers all of the bases required for you to pass the exam!
  • FREE FULL VERSION of Transcender’s 70-450 Practice Exam! We’ve partnered with Transcender®, the leading exam simulation provider in the world! Purchased separately, you would pay $119. But you get it FREE as the perfect training companion to our Advanced SQL Server 2008 Database Administration Training course!

Total Package Value $799!

Limited-Time Offer Only $397

Coming Soon!

(Risk-Free 90-Day Total Experience ™ Guarantee!)

Sign Up For Official Release Updates and Exclusive New Release Discounts

The most up–to–date information on Coming Soon products, exclusive New Release discounts, free training videos, Newsletter with free training tips, and much more!

Name:

Email:

 
Privacy Policy

Meet Your Certified SQL Instructor, Mel Haynes

(MSCS, MCTS, MCP)

Mel Haynes Mel Haynes (MS) has been delivering technical training since 1994. He has trained students across the USA, in Canada, Germany and the UK.

As a Member of Technical Staff (MTS) at Bell Labs in Naperville he worked as a C/UNIX software developer and in Quality Assurance (QA) for 5ESS international switching.

Mel first taught computer science while completing his Masters in Computer Science at Bradley University in Peoria, IL. He started working with Visual Basic in 1992 and began teaching VB as an MCT in 1995. He later moved on to include ASP, C#.net, VB.Net, Java, various web related developer topics, as well as SQL Server and Windows administration.

Mel has developed and delivered Master Data Management (MDM) training and is currently focused on SQL Server 2008. Mel is a gifted IT professional and communicator able to make complex concepts clear and easy to understand.

"Train Signal products not only teach me how to maintain my network, I actually gain understanding that is invaluable for the tests as well..."
I just wanted to send in my thanks. It’s really nice to have a product out there for net admins that really delivers.

Everyone else seems to brag about how you can use their products to pass a test. I've taken and passed several tests, and few contained the content I need on a day-to-day basis.

Train Signal products not only teach me how to maintain my network, I actually gain understanding that is invaluable for the tests as well. I bought your product at my previous employer and will buy it for my current employer as funds become available.

Though your product is amazing, I would like to make one request that I feel would complete the package. Most admins are clueless when it comes to scripting.

Everyone seems to have tons of advanced scripting, but just like everything else, there are little to no explanations for the beginner. Could you please consider adding something in that area to your training? Keep up the good work.

Thanks
David Morehead
www.wcsmiami.org
"...the best paying job of my IT career. Your videos had a big part in that..."
I wanted to let you know I was asked today (3/16/2007) to provide references for a Network Engineer position at a large world-wide law firm. Providing references is typically the last step before an offer. This potentially could be the best paying job of my IT career. Your videos had a big part in that.

I have two and half years experience with Active Directory and Exchange 2003, but your videos showed me just what I needed to pass their skills assessment test. The price was well worth it.

-Bill Boyd
"You guys have a unique ability to explain and visually demonstrate these esoteric topics in a way that is easy to understand..."
I just wanted to let you know I have been very impressed with the orders we have placed with you.

Last year we bought the Microsoft Server Complete Library. It is one of the best I have seen.

You guys have a unique ability to explain and visually demonstrate these esoteric topics in a way that is easy to understand.

I have attended many training classes where I was getting good information but because of the way it was taught I had to force myself to pay attention and in some cases just try not to fall asleep.

These videos are just the opposite. If I am not careful I will sit up too late watching them. Well, we just received our most recent order. This time we decided to order all of your VMWare Videos. If they are as good as your other work then I know I'm going to be happy.

Thanks for the help and keep up the good work.

Del Bullion
VDI Communications, Inc.
"I will recommend TrainSignal to all of my tech buddies..."
I wanted to write and express my great satisfaction with the Exchange Server 2003 for SophiesToyBox.com. I am very impressed with the course. I felt as though I was actually performing the tasks during the course.

Scott was great at explaining things and even going through the quirks that would surely happen during an install. I am very pleased with the material and plan to be back to purchase more. Great job. I will recommend TrainSignal to all of my tech buddies.

William R. Cunningham (Reggie)
Systems Administrator
Institute for Safe Medication Practices www.ismp.org
"I am on my way to becoming an MCSE and have found your videos very informative. However, your service deserves even more praise."
I inadvertently ordered two of the same course on Routing and Remote Access and when I discovered my mistake, I was very upset.

Internet based companies are often hard to deal with. If you try to return something, they put you off -sometimes indefinitely. I was almost sure that I would encounter problems when I attempted to exchange the video.

I called Ashley on the phone and informed her of my intent to exchange the duplicate video for another. She told me that she would send the other video when I returned mine.

I sent the video back by UPS and within a few days I received a package with the new Active Directory tutorial movie. I was so impressed that your company did not try to hold the movie hostage or to delay sending it. Even though I am an avid supporter of technology, I have to agree with those who say that the age of impersonal commerce has opened doorways to poor service.

I hope your company is successful and that others realize the benefit of doing business with someone they can trust!

Sincerely,
Nancy Ashley Ware

Copyright © 2002-2009 Train Signal, Inc. All Rights Reserved.
All logos and trademarks are property of their respective owners.