Microsoft SQL Server 2008 Administration Training Course

Our SQL Server 2008 Training Teaches You:
Installation, Configuration, Troubleshooting, and Much More. Plus, Complete 70-432 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!

• Over 10 Hours of SQL Server 2008 Training Videos on 2 Jam Packed DVDs!
• All Instructor-Led!
• Get certified! Exam Coverage for MCTS 70-432
• 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-432 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

 

Microsoft SQL Server 2008 Administration
Training Demo

SQL Server 2008 Administration Training Course FAQs

"Am I qualified to take the training courses in this package?"

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.

Microsoft SQL Server 2008
Administration Training Course Outline

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

Key Topics:

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

Video 2
Welcome to Microsoft 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

Video 3
Installing SQL Server 2008
There is more to 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

Video 4
An 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

Video 5
Creating SQL Server 2008 Databases
In this video I will walk you through the planning process needed to create your database. 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 Veronica’s Veronicas Database General Page
• Creating Veronica’s Veronicas Database Options Page
• Creating Veronica's Veronicas Database Filegroups Page
• Creating a New Table
• Database Diagrams
• Creating Database Diagrams
• Database Views
• Creating a New View
• Creating a Synonym
• Recommendations

Video 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

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

Video 8
SQL Server 2008 Performance
In this video I will show you the many tools you can use to monitor your SQL Server performance to make sure you are always running at a high level.

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

Video 9
SQL Server 2008 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

Video 10
SQL Server 2008 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

Video 11
SQL Server 2008 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, firwall 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

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

• 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

Video 13
Performing Data Management Task
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

Video 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

Video 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

Video 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

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

Here is what you get....

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

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

11 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 Aministration Training Course

Only £240 (ex vat & del)
per user

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.