Advanced SQL Server 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, 70-450 Exam Coverage!

This Course Includes All of the Following:

Instant Online Access Begin Streaming Your Training Immediately
Physical Media Shipped Directly to Your Doorstep For Free, Worldwide

Transcender Practice Exam Practice For Your Exam With This Award-Winning Exam Preparation

$397
Paying with Purchase Order?
View Outline
Our Total Experience Guarantee is Very Simple

If you are not satisfied with our training, our service, or our support FOR ANY REASON, return your course within 90 days for a FULL REFUND (up to $397). You have my word.

Scott Skinger Founder & President of TrainSignal, Inc.

Overview

Mobile On-Demand Training Train Where You Want, When You Want
Additional Training Formats High Resolution Video, MP3 Audio and PDF of Instructor Notes
Watch a Demo

Professional Training

Nearly 12 Hours (11 Hours, 34 Minutes, 38 Seconds) of Advanced SQL Server 2008 Database Administration Training Videos Jam Packed on 3 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
Instant Access Online to the entire training course

Exam Preparation

Exam Coverage This course covers exam objectives required for you to pass:
- 70-450 - PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 Exam
FREE, FULL VERSION of Transcender's Practice Exam for:
- 70-450 - PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 Exam
We've partnered with Transcender®, the leading exam simulation provider in the world! Purchased separately, you would pay $139! But you get it FREE as the perfect training companion to our Advanced SQL Server 2008 Database Administration Training!

Course Outline

Advanced SQL Server 2008 Database Administration Training - Course Outline

Lesson 1 - Getting Started with Advanced SQL Server 2008 Database Administration Training

In this video you will learn a little bit about your instructor and you will discover the topics that will be covered in this course.

About This Course
About Your Instructor
Overview of Course Topics
How to Use This Course

Lesson 2 - Lab Setup

In this video you will learn about the hardware and software that Mel uses in the course, so you can set up your own environment that will allow you to work hands-on and follow along with the course labs.

The Instructor?s Environment
Copying and Setting Up the Course Files

Lesson 3 - The Course Scenario

In this video you will be introduced to the course scenario that you will work with throughout the course.

The Company: Veronica?s Veronicas
Database Schema for Veronica?s Veronicas
Veronica?s Veronicas Locations

Lesson 4 - Setup and Installation of SQL Server 2008

In this video you will learn how to prepare for a SQL Server 2008 installation. Plus, you will work hands-on to install 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

Lesson 5 - Optimizing SQL Searches with Indexes

In any database you definitely want to be able to access information as quickly as possible; that’s why knowing how to utilize indexes is an invaluable resource. In this video you will learn how to use indexes, when to use indexes and the best ways to use the various types of indexes to access your databaase information in the most efficient manner.

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
Index Performance
Disabling Query Statistic Collection
Fragmentation and Fill Factor
Reorganizing vs. Rebuilding an Index
The Database Tuning Advisor

Lesson 6 - Full-Text Search

In this video you will learn how to search through text in your database by using an index to jump directly to the records of interest. Plus, you will work hands-on performing full-text searches using the Full-Index Wizard.

Overview of Topics
Pros and Cons
Full-Text Search Terminology
Installing Full-Text Search
Introduction to Full-Text Catalogs and Full-Text Indexes
Creating a Full-Text Catalog and Index Using the Full-Text Indexing Wizard
The Like Expression vs. the Contains Statement
Configuring Full-Text Searches
Using the Inflectional Statement
Troubleshooting Full-Text Search
Troubleshooting Full-Text Search Using Dynamic Management Views
Full-Text Search Error Logs

Lesson 7 - SQL Server 2008 Security

SQL Server is designed to allow quick reliable access to your corporate data. In this video you will learn how to use the various SQL Server security configuration choices and you will work hands-on with these different configuration options to control access to the data in your database.

Authentication Modes
Creating Users and Logins
Database-Level Roles
Server-Level Roles
The SA Account
SQL Server Service Accounts
Built-in SQL Server Accounts
Securable Scopes and Schemas
Schemas

Lesson 8 - SQL Server 2008 Policy-Based Management

Policy Based Management is new to SQL Server 2008 and it replaces the Surface Area Configuration tool from previous SQL Server versions. In this video you will learn to utilize Policy Based Management to provide a more manageable centralized configuration management interface for all your server instances. Plus, you will work hands-on to enforce naming restrictions and control your feature states.

Policy Based Management Benefits
Policy Based Management Terms and Concepts
Setting Up Naming Restrictions
Controlling Feature State
Security
Adding a User to the Policy Administrator Role
Recap and Other Things to Remember

Lesson 9 - SQL Server 2008 Data Encryption

Most of us will agree that our data can never be too secure! That is why in SQL Server 2008 you are able to encrypt your data, so that even if your data is compromised it is not readable without the decryption keys and passwords. In this video you will learn how to properly utilize the various SQL Server encryption options and you will work hands-on to encrypt the data in your SQL Server 2008 database.

Encryption Background Information
SQL Server 2008 Encryption Hierarchy
Encryption Hiearachy Components
Data Encryption vs. Transparent Data Encryption
SQL Server 2008 Column Encryption
Column Decryption
Transparent Data Encryption
Encryption Alogorithms

Lesson 10 - SQL Server 2008 Backup and Recovery

Being able to recover your data in the event of data loss or corruption is part of the foundation of any administered SQL installation. In this video you will work step-by-step through the backup and recovery process. Plus, you will work hands-on with Snapshots as you develop your own data recovery plan.

SQL Server 2008 Files
SQL Server 2008 System Databases
Creating a Basic Backup
Performing a Basic Restore
Database Recovery Models
Backup Types
Backup and Restore with TDE Enabled
Using Snapshots in SQL Server 2008

Lesson 11 - SQL Server 2008 High Availability

In this video you will learn how to utilize the various SQL Server High Availability options. Plus, you will discover the pros and cons of each option that will enable you to create and tailor the best high availability solution for your organization.

High Availability Options
Failover Clustering
Pros and Cons of Failover Clustering
Database Mirroring
Pros and Cons of Database Mirroring
Log Shipping
Pros and Cons of Log Shipping
Replication
Replication and Database Mirroring
Selecting a High Availability Solution

Lesson 12 - SQL Server 2008 Failover Clustering

SQL Server 2008 operates based on the Microsoft Windows clustering capabilities. In this video you will learn the requirements to enable SQL Server clustering so that you will be prepared in the event of a failure.

Key Terms to Know
Prerequisites
Introduction to SQL Server 2008 Clustering Installation Process
SQL Server 2008 Clustering Options

Lesson 13 - SQL Server 2008 Database Mirroring

Database Mirroring is an excellent way to maintain database availability in the event of a server outage or during server maintenance. In this video you will work hands-on to configure your own mirrored instance so that you can avoid database downtime.

Mirroring Overview
Operating Modes
Mirroring Roles
Mirroring Service Account
Setting Up Server Engine Service Accounts
Database Mirroring Sessions
Creating Database Mirroring Endpoints
Role Switching
Configuring Endpoints and Starting Mirroring
Recommendations and Restrictions

Lesson 14 - SQL Server 2008 Log Shipping

Log Shipping is another option you can utilize to make sure your data remains available to users in the event of crashes or failures. In this video you will work step-by-step to setup, configure and monitor log shipping in your own SQL Server 2008 database environment.

Log Shipping Overview
SQL Server 2008 Supported Editions
Log Shipping Servers
Log Shipping Jobs
Setting Up Log Shipping
Log Shipping Failover
Primary Server Tables
Secondary Server Tables
Monitor Server Tables

Lesson 15 - SQL Server 2008 Replication

Replication allows you to make segments of your data available to users and applications on separate SQL Server instances by automatically copying data to various servers within your network. In this video you will learn how to take advantage of the different Replication options. Plus, you will work hands-on to setup and configure Replication in your own SQL Server 2008 database.

The Need for Replication
What is SQL Server Replication?
Two Categories of Replication: Server to Server
Two Categories of Replication: Server to Client
Replication Roles: Publisher, Distributor, and Subscriber
Replication Agents
Replication Configuration
Adding Computers to the Domain
Creating Domain Accounts
Replication User Accounts
Configuring the Firewall
Installing SQL Server and Replication
Configuring Distribution
Creating the Publication
Configuring the Subscriber
Creating the Subscription and Verifying Data Was Replicated
Best Practices

Lesson 16 - SQL Server 2008 Resource Governor

Resource Governor is a new feature in SQL Server 2008 that allows you to regulate access to SQL Server resources. In this video you will learn how to utilize Resource Governor to properly manage resource utilization. Plus, you will work hands-on to create your own resource pools, classifier functions, and workload groups.

Managing Resource Utilization
Grouping Server Resources
Classification
Classifier Functions
Creating a Classifier Function
Security for Resource Governor
Resource Pools
Creating a Resource Pool
Workload Groups
Creating the Resource Pool and Workload Group

Lesson 17 - Monitoring SQL Server 2008

SQL Server 2008 comes equipped with numerous tools designed to monitor the "health" of your SQL Server instance. In this video you will learn how to utilize some of the monitoring tools that will help you prevent problems before they occur and will help you troubleshoot issues as they occur.

Activity Monitor
Trace Flags
SQL Server 2008 Reports
Job Activity Monitor
SQL Server 2008 Logs
Dynamic Management Views and Functions
Using Dynamic Management Views
SQL Server Audits
Dedicated Administrator Connection (DAC)

Lesson 18 - SQL Server 2008 Performance Tuning

In this video you will learn how to utilize performance tuning tools to make sure you get the top performance out of your SQL Server instance.

SQL Server Profiler
Database Engine Tuning Advisor
Using the SQL Server Profiler and Database Engine Tuning Advisor
Query Analysis and Execution Plans
Using Execution Plans for Query Analysis
Other Performance Tuning Tools

Lesson 19 - SQL Server 2008 PowerShell

Power Shell is an object-oriented scripting language designed to automate system tasks. In this video you will learn the basics of SQL Server PowerShell and how to begin to utilize foundational commands and Cmdlets.

Introduction to PowerShell
Running PowerShell 1.0 with SQL Server 2008
Launching PowerShell
Execution Policy Setting
Using Execution Policy Cmdlets
The SQL Server PowerShell Virtual Drive SQLSERVER
Foundational PowerShell Commands
SQL Server Specific Cmdlets

Lesson 20 - SQL Server 2008 Integration Services

SQL Server Integration Services is your enterprise level tool for transforming data and migrating data between the SQL Server and other data storage. In this video you will work hands-on to install SSIS, configure SSIS, and create & run a full package.

Introduction to Integration Services (SSIS)
Installation and Configuration
SSIS Service Account and Firewall
Modifying MsDtsSrvr.ini.xml and the Windows Registry
SSIS Configuration File
Running an Integration Services Package
Using the “Integration Services” (Import/Export) Wizard
Rerunning a Package Via SSMS
Other Methods of Running a Package

Lesson 21 - Preparing for Your MCITP: 70-450 Certification Exam

In this video you will learn Mel’s inside tips and pointers on the exam certification process and other things you should consider before taking the exam.

Three SQL Server 2008 Certication Levels
Three SQL Server 2008 Certification Tracks
Microsoft Certified Technology Specialist
Microsoft Certified IT Professional (MCITP)
MCITP 2005 Upgrade Exams
Microsoft Certified Master (MCM)
SQL Server 2008 Certifications
Preparing for Your 70-450 Certification Exam
Registering for Your 70-450 Certification Exam

Lesson 22 - Next Steps

Reaching the end of the course does not mean the learning has to end! In this video you will discover the "next steps" for continuing your growth with Microsoft SQL Server 2008.

Lesson Recap
Steps for Follow Up
We Like Your Opinion

Certified Instruction

Mel Haynes (MCITP: Database Administrator 2008, MSCS, MCTS, MCP, MS)

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

Courses Instructed by Mel Haynes

FAQ

Advanced SQL Server 2008 Database Administration Training - FAQ

Am I qualified to take this course?: YES! If you have taken our SQL Server 2008 Administration Training course, have obtained your 70-432 MCTS: SQL Server 2008, Implementation and Maintenance certification, or have experience as a SQL Server 2008 administrator, you’ll benefit from this in-depth course!

Note: This is an Advanced course and is not recommended for SQL Server 2008 beginners.

Do I need any special equipment to complete this training course?: NO! All you need is a computer with Internet Explorer and a media player; however, working hands-on with SQL Server 2008 may enhance your training experience.
Is this course part of any Microsoft certification track?: YES! This course will help you prepare for the 70-450 Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008 exam.

Order Advanced SQL Server 2008 Database Administration Training Now!

$397

"Within 2 months time...I passed the 70-432 exam with flying colours!": Mel, I must say, I have never had such a good teacher

I first started purchasing your products last year when I decided to do the SQL Server 2008 Admistration Training.

I was a bit sceptical of the training but just decided to give a try, I was shocked to find out that it was the most amazing, clear, training I have ever had!

Within 2 months time after receiving the product from you, I went and sat my first Microsoft SQL Server 2008 Administration Exam and passed with flying colours!
Dennis BuGumba MCTS
"TrainSignal 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.

TrainSignal 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
"Its like having a Veteran walk you through training camp, building your confidence so you know what it takes to get it done.": Just want to say great job by you and the team on the training videos. The videos and the lab books trail each other so you align the image of it being done with the instructional reading. Its like having a Veteran walk you through training camp building your confidence so you know what it takes to get it done.

If your goal is certification then partner the video with test questions and you will solidify the knowledge from the video in your mind for the test and while really getting to know your craft!
Andrew (MCSE, A+, N+)
"I shall continue to buy your products without a question of a doubt.": I have purchased almost all of your videos so far and I must say that they have been value for money; in as much as that I have gained lots of new skills.

Moreover, I find your service absolutely excellent and I feel totally appreciated as a customer. I shall continue to buy your products without a question of a doubt.

Kind regards,
Keith Greaves Fruitree director
"...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 Practiceswww.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
"I will be happy to recommend your products to anyone I know...": Just to let you guys know I received my order this morning. Extremely happy with the fast delivery service, since I ordered the product on Tuesday afternoon and I received them Thursday morning (48hrs delivery from the US to the UK, that puts to shame some mail order companies in the UK) I will be happy to recommend your products to anyone I know.
Daniel Jenkins Surrey, Great Britain
"I highly recommend your products and I buy every new release that comes out.": I would like to say that I have had many “live” classes in everything from MCSE to CCNA and your classes are as good or better. You can play the CDs over and over or go back and review something that you did not really understand the first time.

I highly recommend your products and I buy every new release that comes out. Please keep up the great work!

Thanks,
Joseph McElveen Insync Network Systems, Savannah, Georgia
"Your way of running business is a rare example...": There truly is power in a good name and a way of running business. Good impressions and positive experiences with a company definitely affect how people think when they think of your name - in this case, TrainSignal.

All that is to say thank you and that I will truly enjoy the material. I have studied all the other many hours diligently and will continue on my certification path.

You guys are doing it right; it's great to take part in your program and business.
John Archer

Looking For Volume User Licensing For Advanced SQL Server 2008 Database Administration Training?

24/7 Access to Training

Online access to all training through My Online Training, with an option for physical media.

Volume Discounts

Discounts start at quantities as low as 2 licenses per training course.

Scalable Licensing Model

License your team for specific courses that meet their needs to build a custom package of TrainSignal Training.

Call 1.888.229.5055 or Email sales@trainsignal.com

Contact us for a free volume license quote or tell us how many licenses you need and we'll show you the volume license discount immediately in your cart.

Volume Discount Pricing For Advanced SQL Server 2008 Database Administration Training

# of Users	% Discount	Cost Per User
1	0%	$397.00
2	20%	$317.60
3-4	25%	$297.75
5-9	30%	$277.90
10-19	35%	$258.05
20-49	40%	$238.20
50+	Call 1.888.229.5055