Untitled 1
Call us toll free at (866) 509-7511 or from outside the US at (208) 765-8290
 
HOME
DEMOS
CERTIFICATION PATHS
JOBS
INSTRUCTOR EVALS
ABOUT US






" He was the best technical instructor that I have ever had and I've been in IT for 15 years and have taken a lot of classes. "

- Jeff Christopher


" The Insider Training format allowed for the flexibility that my company and I required for upgrading skills. The instructors were knowledgable, and it truly had the feel of a classroom environment while still being available at the office. "

- IT Manager
Westbank First Nation BC, Canada
Live, Online Instructor-led MCTS: SQL 2008 Database Administrator Training

Microsoft Certified Technology Specialist (MCTS): SQL 2008 Database Administrator Certification Training Packages
Course Overview
Our complete MCTS: SQL 2008 Database Administrator packages give you the expert knowledge and hands-on experience you need to master SQL Server 2008 core technologies and pass the Microsoft exam for this important certification.  Passing the MCTS: SQL 2008 Database Administration exam is a prerequisite for attaining the advanced level MCITP: SQL 2008 Database Administrator certification. 

For one low price, you‘ll tap into the most powerful learning system available anywhere. The Insider Training Multi-Path Learning System will maximize what you learn, and more importantly, how much you retain.

MCITP: Database Administrator SQL 2008 Course Details




Important Notes:  For information on the combination MCTS/MCITP SQL 2008 Database Administrator course click here or on the certification path chart.

Students who register for SQL 2008 training courses will also receive free access to SQL 2005 training.




 

 

This courses provides a comprehensive learning track for both new and experienced database administrators to understand implementation, maintenance, database infrastructure, design and optimization of SQL 2008. The courses include a detailed focus on SQL 2008 core topics required by database administrators such as database security, snapshots, database mirroring and log shipping, high availability strategies, and backup and restore. 

 

PREPARATION FOR EXAMS: MCTS: SQL 2008 Database Administrator
  • 70-432: TS: Microsoft SQL Server 2008: Implementation and Maintenance
+LIVE Online Instructor Led Sessions
We know you‘re busy. That‘s why we‘ve designed a flexible training schedule that works around you! The +LIVE course meets twice a week for two hours at a time for live, online, instructor-led sessions.

Our unique 7-step program starts with hand-picked, certified trainers with extensive consulting and training backgrounds. Each week you‘ll attend live, information-packed sessions that cover three to four major topics in depth. Because it‘s live, you‘ll be able to get your toughest questions answered right away. In-class quizzes and surveys will ensure that you‘re absorbing the key points along the way.
24/7 Access to Class Recordings
Need to miss a class? No problem! All class sessions are digitally recorded and automatically indexed so that you can review the material at any time. You‘ll be able to tap into your class recordings immediately after the live sessions and have extended access for a full twelve months starting from when your course begins. 
Hands-On Lab Time
Insider Training‘s remote lab gives you the ability to put your knowledge to work on real systems on your own schedule. Your private lab time is scheduled in advance at any time convenient for you. When you connect in, you‘ll be in total control of multiple real systems.
Ongoing Instructor Mentoring
Your instructor is available to answer your questions inside and outside of class. You‘ll have email access for twelve months starting from when your course begins.
Highest-Rated Transcender Practice Exam Simulations
Before tackling the real exam, you‘ll know you‘re prepared by taking these hard-hitting practice exams. Each simulation provides three complete practice exams with questions that closely match the style and wording of the real thing. Each question explains both the right and wrong answers with references to supporting documentation.

 Exam IDPriceTranscender Product
1 70-432$149.00Microsoft SQL Server 2008 Implementation and Maintenance
 TOTAL VALUE$149.00This is included in your +Live Premium and On Demand Premium registration fees.

1 Microsoft Press Self-Paced Training Kit
Each kit includes hands-on practice labs, and sample test questions. They‘re clearly written and highly regarded by our instructors and students alike.

 PublisherPriceName
1Microsoft Press$59.99MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 Implementation and Maintenance
 TOTAL VALUE$59.99This is included in your +Live Premium and On Demand Premium registration fees.

Certification Guarantee
If you purchase the +LIVE Premium and you meet the course prerequisites, we guarantee that you will pass your certification exams. If you do not pass an exam, we will assign an instructor to work with you until you succeed.

PREREQUISITES:
  • Broadband Internet connectivity (DSL, Cable or other high-speed connection)
    AND
  • 1 year of hands-on experience as a database administrator or developer
    OR
  • 1 year of hands-on experience as a systems administrator or support specialist


Course Overview

SQL 2008 Implementation and Maintenance
  • Installing SQL Server 2008
  • Configuring SQL Server 2008
  • Configuring Additional SQL Server Components
  • Implementing Database Mail
  • Managing SQL Server Agent
  • Implementing the Declarative Management Framework (DMF)
  • Backup a SQL Server Environment (Operating System Level)
  • Managing Logins and Server Roles
  • Managing Users and Database Roles
  • Managing Permissions
  • Auditing SQL Server
  • Managing Transparent Data Encryption
  • Configuring Surface Area
  • Backup and Restore Databases
  • Managing Database Snapshots
  • Maintaining Database Integrity
  • Implementing Database Maintenance Plans
  • Manage Data Partitions
  • Implement Data Compression
  • Maintaining Indexes
  • Troubleshooting and Tuning SQL Server
  • Implementing Mirroring
  • Implementing Log Shipping
  • Implementing Replication

 




 © 2003 - 2010 INSIDER TRAINING, INC. All rights reserved.