SQL Server 2005 MCTS 70-431

SQL Server 2005 MCTS 70-431 online training courses
Total Courses: 11    Estimated Training Time: 26 Hour(s)

Summary

1 Year Unlimited access to all 11 courses listed below, includes over 26 hours of online courseware.

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

Current Price: $59.95 | List Price: $119.99

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

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

Lesson Detail:

  • SQL Server 2005 MCTS 70-431: 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

  • SQL Server 2005 MCTS 70-431: 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

  • SQL Server 2005 MCTS 70-431: 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: 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

  • SQL Server 2005 MCTS 70-431: 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

  • SQL Server 2005 MCTS 70-431: 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
    • Using OPENROWSET and SSIS
    • Implementing Service Broker
    • Assembling Components into a Service

  • SQL Server 2005 MCTS 70-431: 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

  • SQL Server 2005 MCTS 70-431: 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

  • SQL Server 2005 MCTS 70-431: 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

  • SQL Server 2005 MCTS 70-431: 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

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

    • Practice Exam 1
    • Practice Exam 2

Certification

SQL Server 2005 MCTS 70-431

Audience

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.

Features

  • 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

  • Internet connection
  • Browser: Internet Explorer, FireFox, Chrome, Safari, Opera or any standards compliant browser.
  • Authorware and Macromedia Flash player recommended but not required.
  • JavaScript must be enabled.

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 1 year unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.

StaffKit is an e-learning leader in providing computer training tutorials and online education. We have satisifed online learning customers in over 50 countries. We have been providing web based training for the past 9 years.

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 over 749 hours related training courses

Microsoft Certifications

Learn the latest in technical Microsoft topics and help prepare for the MCTS, MCITP, and MCSE core and elective exams required to earn Microsoft certifications.

81 Series

Price: $149.95