SQL Server 2008 Administration Training

Our SQL Server 2008 Training Teaches You: SQL Profiler, SQL Server Agent, Replication, Optimized Use of SQL Server FileGroups and Much More. Plus, 70-432 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

A Letter from Mel Haynes
(MCITP: Database Administrator 2008, MSCS, MCTS, MCP)

If you want to develop hands-on experience as an SQL Server 2008 Administrator, or prepare for the 70-432 exam then this course is for you! We are excited to announce our long awaited SQL Server 2008 Administration Training course. Whether you're a beginner or experienced in SQL Server administration, this course covers SQL Server 2008 in depth as you configure and maintain your own enterprise data management system!

Database Administration is one of the few jobs that seems to always be in demand. Follow along with the many real world examples in this course to work with your own database and lay the foundation towards becoming a DBA.

Professional Training

Over 10 Hours (10 Hours, 12 Minutes, 43 Seconds) of SQL Server 2008 Administration Training Videos Jam Packed on 2 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-432 - TS: Microsoft SQL Server 2008, Implementation and Maintenance Exam
FREE, FULL VERSION of Transcender's Practice Exam for:
- 70-432 - TS: Microsoft SQL Server 2008, Implementation and Maintenance 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 SQL Server 2008 Administration Training!

Course Outline

SQL Server 2008 Administration Training - Course Outline

Lesson 1 - Introduction to SQL Server 2008 Administration

Learn what’s in the course and who your instructor is.

About Your Instructor and Train Signal
What’s Covered in this Course
Hardware

Lesson 2 - Welcome to SQL Server 2008

I will show you exactly what SQL Server 2008 is and we will walk through the scenario we will be using throughout the course.

What is SQL Server 2008?
SQL Server 2008 Solutions
A Brief History of SQL Server
Scenario Veronica’s Veronicas Overview

Lesson 3 - Installing SQL Server 2008

There is more to configuring an SQL Server installation than you might think. I will show you exactly what you need to do to prepare for installation and the requirements you will need to meet before installing SQL Server, so that your installation goes smoothly.

SQL Server 2008 Editions
SQL Server 2008 Requirements
Downloading SQL Software
SQL Server Security 101
Installing SQL Server 2008
SQL Server Installation Center Overview
New SQL Server Stand-Alone Installation
Launching SQL Server 2008

Lesson 4 - Introduction to SQL Server 2008 Tools

To fully make use of all of the features of SQL Server you need to know how to use the many tools it has to offer. In this video I will show you an in depth overview of the several tools available in SQL Server 2008.

SQL Server Business Intelligence Development Studio Overview
Analysis Services and Configuration Tools Overview
Documentation and Tutorial Overview
Integration Services and Performance Tools Overview
Windows PowerShell 1.0 Overview
System Databases
SQL Server Management Studio Overview
Query Interface Overview

Lesson 5 - Creating SQL Server 2008 Databases

In this video I will walk you through the planning process needed to create your database to meet your specific business and database management needs. Plus, using our scenario, I will show you exactly how to set up your very own SQL Server Database.

Database Planning
Creating Databases Overview
Creating General Page
Creating Options Page
Creating Filegroups Page
Creating a New Table
Database Diagrams
Creating Database Diagrams
Database Views
Creating a New View
Creating a Synonym
Recommendations

Lesson 6 - Configuring SQL Server 2008 Security

As a DBA, one of your most important responsibilities will be securing company data resources against unauthorized access and modification. In this video we will tackle SQL Server Security from physical security to permissions and schemas; and everything in between.

SQL Server Security Landscape
Physical Security
Managing User Access
Logins and Users
Creating a User Account in AD
Creating SQL Login and SQL User Account
Testing SQL User Account
Setting SQL User Permissions
Server-Level Role vs. Database-Level Role
Schemas Overview
Creating Schemas
Testing Schemas
Protecting Your Data Auditing SQL Server
Remote Access
File Security and SQL Server Data Encryption
SQL Server SA Login and Certificat-Based SQL Server Login
Public Database Role
Information_Schema and Sys
Best Practices

Lesson 7 - Implementing Disaster Recovery

Having a disaster recovery plan is a necessity in today’s computing landscape. I will show you the different disaster recovery models you can implement to make sure you are protected against data corruption, hardware failures, and anything else that would destroy data.

SQL Server Recovery Models
Full Recovery Model
Bulk Logged Recovery Model
Simple Recovery Model
Backup Types
Full Database Backups
Restoring a Database
Full File Backups
Partial Backups
Recovery Requirements
Best Practices

Lesson 8 - Performance

In this video I will show you the many tools you can use to monitor your SQL Server performance to anticipate problems before they occur.

SQL Profiler/SQL Trace (T-SQL)
Windows System Monitor
Activity Monitor
Transact-SQL
Windows Logs
Default Trace
Dynamic Management Views
Monitoring Tools Comparison

Lesson 9 - Automating Administrative Tasks

In this video I will show you how to use the SQL Server Agent to automate administrative tasks, saving you time and allowing you to move on to more important work.

SQL Server Agent
Configuring SQL Server Agent
Key Fixed Database Roles
Creating and Running Jobs
Subsystem
Proxy
Security Guidelines

Lesson 10 - High Availability

Learn the benefits of the various high availability options and why you would use each one. Plus, I'll show you how to keep your database always available by having multiple servers ready to go, so you're not depending on just one server.

SQL Server Failover Clustering
SQL Server Database Mirroring
SQL Server Log Shipping
SQL Server Replication
Comparisons

Lesson 11 - Replication

Learn to implement SQL Server replication, making the necessary data available to various locations as it’s needed; in real time. Plus, see how to configure the necessary security including: user accounts, firewall settings, and administrative access.

What’s the Problem to Solve?
What is SQL Replication?
SQL Server Replication Concepts
Types of Replication
SQL Server Roles
Pieces of SQL Replication Model
Players of SQL Replication Model
Creating Replication Admin Account
Creating Agent Accounts
Changing Firewall Settings
Giving Replication Admin Access to the SQL Server
Installing SQL Server Replication Feature
Adding Replication Accounts to Database
Creating Publication
Creating Push Subscription
Best Practices

Lesson 12 - Resource Governor

In this video I will show you how to manage server resources and control application access to system resources.

Troubleshooting SQL Server
Managing Resource Utilization
Resource Govenor
Resource Pools
Creating a Resource Pool
Workload Groups
Creating a Workload Group
Classification
Creating a Classifier Function

Lesson 13 - Performing Data Management Tasks

In this video you will learn several data management skills focused on "rounding out" your SQL Server 2008 administration knowledge. A primary focus will be understanding and managing indexes.

Importing and Exporting
Permissions for Importing and Exporting
Maintaining Indexes
Clustered vs. Nonclustered Indexes
Creating Indexes
Full-Text Indexing

Lesson 14 - Data Compression

Learn how you can slow the effect of the data storage explosion by compressing SQL Server data while still maintaining performance requirements.

Row Compression
Page Compression
Data Partitions
Table Compression via T-SQL
Compressing Backups

Lesson 15 - SQL Server 2008 Common Commands

As a database administrator you will find the DBCC ‘family’ of commands and the myriad of applications for the sp_configure system stored procedure to be invaluable. These two commands touch every aspect of the DBA role and provide you with access to every configuration option available within SQL Server 2008.

Database Console Commands (DBCC)
Running DBCC CHECKTABLE and DBCC CHECKDB Commands
Setting Server Configuration Options
sp_configure clr enable Command
sp_configure c2 audit mode Command
sp_configure fill factor Command
Final Thoughts on sp_configure

Lesson 16 - Database Mail

In this video I will show you how to use SQL Server Database Mail and Microsoft’s “built-in” SMTP server to send email notifications to operators, from SQL Server 2008.

The Players...
Simple Mail Transfer Protocol (SMTP) Server
Database Mail Profiles and Accounts
Configuring Database Mail
Database Mail SMTP Authentication

Lesson 17 - SQL Server 2008 Certification 101

The path to certification will be clear once you watch this SQL Server 2008 certification road map. I cover all the certification levels, tracks and exams to get you certified in SQL Server 2008.

The Certification Hierarchy
Microsoft Certified Technology Specialist (MCTS)
Microsoft Certified IT Professional (MCITP)
Microsoft Certified Master (MCM)

SQL Server 2008 Administration Training - Bonus Lessons

Lesson 1 - Running SQL Server 2008 in Hyper-V

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

SQL Server 2008 Administration Training - FAQ

Am I qualified to take this course?: YES! If you are a complete beginner to SQL Server, have used previous versions of the software, or have some experience with SQL Server 2008, you'll benefit from this in-depth course!
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 a 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-432 Microsoft SQL Server 2008 Implementation and Maintenance exam.

Order SQL Server 2008 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 SQL Server 2008 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 SQL Server 2008 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