Microsoft SQL Server 2008 Advanced Administration Training Course

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

If you want to develop hands-on experience as a 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 install and configure your own enterprise data integration platform!

• Nearly 12 Hours of SQL Server 2008 Training Videos on 3 Jam Packed DVDs!
• All Instructor-Led!
• Get certified! Exam Coverage for MCTS 70-450
• Scenario-based training - learn to do the tasks you do in your job
• Multiple File Formats Make It Convenient for You To Learn Anywhere You Go! iPod Video, Mp3 Audio, .WMV & high quality .AVI video
• FREE FULL VERSION of Transcender's MCTS 70-450 Practice Exam! We've partnered with Transcender®, the leading exam simulation provider in the world! Purchased separately, you would pay $159. But you get it FREE as the perfect training companion to our SQL 2008 course!
• Learn at your own pace and at a fraction of the price compared to classroom training!

Free with this course Windows Server 2008 R2

 

Watch a demo now!

Microsoft SQL Server 2008 Administration
Training Demo

Microsoft SQL Server 2008
Advanced 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 ServerHardware, 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 Solutions

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

Here is what you get....

22 videos will be provided in High-Quality AVI & WMV format. In other words, you get perfect quality and replication of your instructor's screens. An easy-to-use table of contents allows you to navigate to key areas you wish to focus on.

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). 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 Files to listen to Train Signal on the go. Some of our students have requested this option. People would like to be able to listen in their car or while working out. Can be burnt to a CD or copied to portable device. Great supplemental training to the videos.

Instructor Notes – These PDF documents can be printed out and contain the slides used by the instructor throughout the videos. These allow the user a quick easy reference to notes on the slides and make any additional notes for their own learning process.

Free full version of Transcender's SQL Server 2008 Practice Exam! (SAVE $159!) 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 SQL Server 2008 Course!

The Complete Train Signal FastTrack Video
CBT Training Library
Buy "Microsoft SQL Server 2008 Administration" as Part of our Complete FastTrack Video CBT Training Library...
Every Course we Have on a USB Hard Drive
Check it Out Now!

Microsoft SQL Server 2008 Advanced AdministrationTraining Course

Only £240 (ex 15% vat & del) 

Multi user pricing available - call sales now

Official Purchase orders accepted from Government, Education, Health & Charity, Times 1000 plc's,  Professional Partnerships and other pre-approved accounts. Want to order more than one course ? Contact sales for a custom quote.