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

Start Learning Right Now with Instant Access to your Advanced SQL Server 2008 Database Administration Training Course (via Train Signal’s My Online Training)

This great feature allows you to get access to the training just seconds after you’ve purchased it! Plus, you’ll still receive the DVDs in the mail!

You have access to all the Advanced SQL Server 2008 Database Administration Training you’ve purchased in one simple location. There is no need to bring your DVDs from home to work or school anymore. Just login to Trainsignal.com and in your account you’ll see a section containing your courses in My Online Training

Instant Access via My Online Training is the perfect addition to Train Signal’s industry leading Windows 7 Administration Training course! Best of All, it’s completely FREE!

No more waiting for the mail to get started with learning. Get access to your training instantly!
Receive both the physical DVDs and online access!
Full quality playback compatible with Windows, Mac, and Linux!
All your training is just a click away!

Click here for My Online Training FAQ

SQL Server 2008 Database Development Training
Course FAQs

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

Advanced SQL Server 2008 Database Administration Training
Course Outline

Video 1

Getting Started with Advanced SQL Server 2008 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

Video 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

Video 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

Video 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

Video 5

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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 16

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

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

Video 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

Video 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

Video 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

Video 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

Video 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

Advanced SQL 2008 Database Administration

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

22 videos (11 hrs: 34mins: 38secs) 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.
Instant Access to all 22 Videos in Train Signal’s My Online Training section. These high resolution videos allow you to access any and all of this award winning training in just moments. No need to wait for the DVDs to arrive to get started learning. You can be watching video in just moments and it’s all included for free.
22 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."
22 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 $139!)

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!

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!

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 ~~$599~~!
Limited-Time Offer Only $397!

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!
Instant Access Online to the entire training course
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

Valuable Exam Preparation Resource 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 $139. But you get it FREE as the perfect training companion to our Advanced SQL Server 2008 Database Administration Training course!

Total Package Value ~~$599~~!

Limited-Time Offer Only $397

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

Watch a demo now!
watch demo

Advanced SQL Server 2008 Database Administration Training Demo

Meet Your Certified SQL Instructor, Mel Haynes

(MCITP: Database Administrator 2008, MSCS, MCTS, MCP)

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.

Similar Products

MCITP: SQL Server 2008 Database Administration Training Package
SKU: 01-904-C
Price: $594.00
SQL Server 2008 Administration
SKU: 01-061-C
Price: $397.00
SQL Server 2008 Database Development
SKU: 01-068-C
Price: $397.00

"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
"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 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
"Train Signal Rocks!": Keep kicking butt! I have purchased CBT nuggets before. They are good on theory and very little application. Yours is both. Please keep up the great work Scott. You are very gifted.

What I love about your stuff is you have the theory and then you apply it and then you test it! You go full circle. CBT nuggets leaves too many things open ended. People don’t realize from the home CBT user. You need to go full circle theory, application how to use it, and then prove it. Mistakes and proving things help us see why and help us handle the unexpected better. I also am a teacher at my work, and this is what I do with effectiveness.

I also bought all of your courses all 21... I am studying for MCSE 2003 and your course rocks better than classroom. Way better.

Keep up the great work. Train Signal rocks!

Robert W. Van Dyke
IS Assistant
Bulls Eye Credit Union
"I’m sure I will be buying a lot more videos from you. :)": I bought the entire Windows training package and I am probably about half way through it. I am definitely happy with the product. So far I’ve watched videos from both Scott Skinger and Obaid Chhatriwala…both do a very good job.

Again, I am really happy with the product and I think the instruction quality of both Scott and Obaid is great! I’m only commenting on this because I’m sure I will be buying a lot more videos from you. :)

David Copenhaver
IT Manager / Network Administrator
HESSTECH, LLC
"Just wanted to take this opportunity to say how effective your training DVDs are.": Few weeks back, I had no idea what Active Directory, DNS, WINS, DHCP etc. are all about, but after watching your training videos all are as clear as crystal.

Thank You,
Abid Malik
Raleigh, North Carolina
"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
"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, Train Signal.

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.

Sincerely,
John Archer
"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+)

Our hamsters are hard at work with your request

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!