Learn Online with StaffKit Training Courses
Online Employee Business and Computer Training

SQL Server 2005 MCTS 70-431 Training


This series explains how to install, configure, and use SQL Server 2005.

This SQL Server 2005 MCTS 70-431 online training series provides over 26 hours of self-paced courseware. This web-based training provides 6 months of unlimited access to all of the following lessons:

1 . Creating Databases
2 . Enhancing Data Consumption and Throughput
3 . Implementing Database Objects
4 . Implementing High Availability
5 . Installing and Configuring SQL Server 2005
6 . Maintaining and Backing Up Databases
7 . Monitoring Performance
8 . Practice Exams
9 . Supporting the XML Framework
10 . Troubleshooting and Optimizing
11 . Working with Tables and Programmability Objects

Lesson Detail:

Creating Databases
This course explains how to use SQL Server 2005 to create databases and establish views you can employ to work with data.

  • Defining Databases
  • Views
  • Using Indexed Views
  • Using Partitioned Views

Enhancing Data Consumption and Throughput
This course explains how to move large amounts of data either within a single server or between servers. Bulk Copy Program (BCP) and SQL Server Integration Services (SSIS) are also discussed.

  • Importing and Exporting Data
  • Using the Bulk Copy Program
  • Implementing Service Broker
  • Assembling Components into a Service

Implementing Database Objects
This course explains how to work with the data in database tables.

  • Listing Table Contents
  • Enhancing Reports
  • Querying Data
  • Conditional Data Filtering
  • Data Querying via Full-Text Indexes
  • Using System Tables and Stored Procedures
  • Using Views and Data Types
  • Inserting Records
  • Changing Stored Data
  • Removing Unwanted Data

Implementing High Availability
This course explains how to implement high-availability solutions such as log shipping, database mirroring, failover clusters, and replication.

  • High-availability solutions
  • Implementing log shipping
  • Database mirroring and failover clustering
  • Replication strategies
  • Types of replication
  • Elements of replication
  • Microsoft analysis services

Installing and Configuring SQL Server 2005
This course explains how to prepare for the installation and configuration of SQL Server 2005.

  • Preparing for Installation
  • Installing SQL Server 2005
  • Postinstallation Procedures
  • SQL Server Login Security

Maintaining and Backing Up Databases
This course explains how to use SQL Server 2005 to maintain and backup databases.

  • SQL Server Database Maintenance
  • Performing Database Backups
  • Backup Types
  • Using the T-SQL BACKUP Statement
  • Restoring Data from a Backup
  • Working with Database Snapshots
  • Automating Maintenance with Job Scheduling

Monitoring Performance
This course explains how to monitor the performance of a SQL Server 2005 system.

  • SQL Server Management Studio
  • Using Activity Monitor
  • Working with Log File Viewer
  • Server-Maintained Information
  • Using Windows System Monitor
  • Working with SQL Server Profiler
  • Defining a Profiler Trace

Practice Exams
This course provides practice questions for the SQL Server 2005 MCTS 70-431 exam.

  • Practice Exam 1
  • Practice Exam 2

Supporting the XML Framework
This course explains how to manage the XML data and features that are integrated into SQL Server 2005.

  • Managing XML data
  • Supported XML features
  • XML basics
  • The XML data type
  • XML method interactions
  • Other SQL Server XML support

Troubleshooting and Optimizing
This course explains how to troubleshoot issues that may arise when using SQL Server 2005. It also provides information on optimizing SQL Server for the best performance.

  • Tuning the Operating System and Hardware
  • Locks, Blocks, and Deadbolts
  • Indexing Strategies
  • Data Partitioning Across Servers
  • Working with the DTA
  • Using the Database Console Command

Working with Tables and Programmability Objects
This course provides you with information concerning job skills tested by Microsoft Exam MCTS70-431.

  • Table Basics
  • Column Attributes
  • Indexes
  • Primary and Foreign Keys
  • Cascading Actions and Triggers
  • Partitioned Tables
  • Implementing Partitioned Tables
  • Programmability Objects
  • Full-Text Searches
  • Security

SQL Server 2005 MCTS 70-431

This series for anyone who's preparing to take the SQL Server 2005 MCTS 70-431 exam, or for anyone who wants to learn more about SQL Server 2005.


  • Flash and audio provide animated, interactive Lesson Introductions, Activities, and Simulations.
  • Activities allow learners to apply course concepts in an interactive questioning environment.
  • Exercises allow learners to practice in the actual application being studied.
  • A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
  • Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
  • Search text enables learners to rapidly search all text within a course to easily retrieve information required.
  • Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
  • A skill assessment generates a customized learning path based on the results of a pre-test.
  • A glossary provides a reference for definitions of unfamiliar terms.
  • Bookmarking tracks the learner's progress in a course.

Technical Requirements:

What You Get:

You will receive Unlimited Access to all of the SQL Server 2005 MCTS 70-431 training tutorials listed above. Your online training courses will be available from anywhere you have internet access.This e-learning series includes all of the online training tutorials listed and is provided in an interactive, self-paced format. Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 6 months of unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.

Web-Based Training Products:

You might also be interested in our Microsoft Certifications Package which includes all of the SQL Server 2005 MCTS 70-431 training courses listed above plus hundreds of hours of related online training courses


Microsoft Certifications Package

Only $249.95   staffkit

SQL Server 2005 MCTS 70-431
Training Series
Total Courses: 11
Total Time: 26+ hours
Only $99.95
Available in Package only
Total Courses: 829
Total Time: 1776+ hours
Only $249.95
Satisfaction Guaranteed    BBB Online Accredited Business          Fruad Protection Guaranteed By American Express            Paypal World Seller


'offers employers an excellent way to train their staff economically and without having to send them out of the office.'

'this is a must have resource'
California Technology Magazine

'this is theUltimate
Career Development
MidWest Technology Journal

Read more customer
reviews about our
e-learning training tutorials

StaffKit offers a centralized e-learning solution for business, computer, technical, compliance and employee training.
Copyright © 2001-2016 StaffKit All Rights Reserved