An excellent class. Provides current information and practical techniques. More Testimonials »

SQL Server 2005 MCTS 70-431 eLearning Course

  1. Overview
  2.  | 
  3. Catalog
  4.  | 
  5. Packages
  6.  | 
  7. Benefits
  8.  | 
  9. Savings
  10.  | 
  11. FAQs
  12.  | 
  13. Try Free
  14.  | 
  15. Cancellation
  16.  | 
  17. Login
  18.  | 
  19. Support
Save money by buying eLearning courses in packages.

Packages include multiple eLearning courses that are bundled together for a great value.

Of course, you can buy this SQL Server 2005 MCTS 70-431 eLearning course individually as well. Just click on the "Register Now" button below.

SQL Server 2005 MCTS 70-431 eLearning Course Series (26 hours)

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

Self-Paced SQL Server 2005 MCTS 70-431 eLearning Course Benefits

Only $99.95

12-month subscription!

Register Now

  • Learn SQL Server 2005 MCTS 70-431 online with these interactive online SQL Server 2005 MCTS 70-431 courses.
  • Affordable Pricing (Only $99.95 for the complete series)
  • A full year to complete the SQL Server 2005 MCTS 70-431 courses
  • Retake the SQL Server 2005 MCTS 70-431 courses as many times as you like
  • Measure your progress with assessment tests after each course
  • Earn completion certificates after passing each assessment test

1. SQL Server 2005 MCTS 70-431:1 Installing and Configuring SQL Server 2005 (Time: 2 hours)

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

Course Objectives

  • Evaluate your hardware and software requirements prior to installation
  • Install SQL Server 2005
  • Configure linked servers for use with SQL Server 2005
  • Establish login security

Course Topics

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

2. SQL Server 2005 MCTS 70-431:2 Creating Databases (Time: 2 hours)

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

Course Objectives

  • Create and alter databases
  • Employ views for data query operations
  • Use indexed views
  • Use partitioned views

Course Topics

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

3. SQL Server 2005 MCTS 70-431:3 Working with Tables and Programmability Objects (Time: 3 hours)

This eLearning course provides you with information concerning job skills tested by Microsoft Exam MCTS70-431.

Course Objectives

  • Implementing a table
  • Implementing triggers
  • Implementing functions
  • Implementing stored procedures
  • Implementing constraints
  • Implementing indexes

Course Topics

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

4. SQL Server 2005 MCTS 70-431:4 Implementing Database Objects (Time: 4 hours)

This eLearning course explains how to work with the data in database tables.

Course Objectives

  • Perform queries that extract data
  • Produce reports
  • Insert, update, and remove data
  • Use full-text queries
  • Use system tables and views

Course Topics

  • 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

5. SQL Server 2005 MCTS 70-431:5 Supporting the XML Framework (Time: 2 hours)

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

Course Objectives

  • Recognize the importance of XML within a SQL Server database
  • Identify the new features and functionality for XML in SQL Server 2005
  • Describe how to output data in XML format
  • Use the xml data type
  • Explain methods associated with the xml data type
  • Create XML indexes

Course Topics

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

6. SQL Server 2005 MCTS 70-431:6 Enhancing Data Consumption and Throughput (Time: 2 hours)

This eLearning 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.

Course Objectives

  • Explain importing and exporting data with SQL Server 2005
  • Import and export data using the Bulk Copy Program (BCP)
  • Use OPENROWSET to access any OLE DB data source
  • Use SSIS to handle the import and export of data
  • Implement Service Broker
  • Assemble components into a service

Course Topics

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

7. SQL Server 2005 MCTS 70-431:7 Maintaining and Backing Up Databases (Time: 3 hours)

This eLearning course explains how to use SQL Server 2005 to maintain and backup databases.

Course Objectives

  • Identify the new features in SQL Server database maintenance
  • Perform a database backup
  • Identify the various backup types
  • Use the T-SQL BACKUP statement
  • Restore data from a backup
  • Create a database snapshot
  • Automate maintenance with job scheduling

Course Topics

  • 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

8. SQL Server 2005 MCTS 70-431:8 Monitoring Performance (Time: 2 hours)

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

Course Objectives

  • Describe monitoring tools used by SQL Server 2005
  • Identify the features of Log File Viewer
  • Describe the types of server-maintained information found in SQL Server 2005
  • List types of System Monitor counters
  • Define a SQL Profiler trace

Course Topics

  • 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

9. SQL Server 2005 MCTS 70-431:9 Troubleshooting and Optimizing (Time: 2 hours)

This eLearning 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.

Course Objectives

  • List the settings that affect statistics
  • Describe how SQL Server deals with multiple users
  • Discuss indexing strategies
  • Describe how partitioning can improve performance
  • List tools that assist with maintenance tasks

Course Topics

  • 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

10. SQL Server 2005 MCTS 70-431:10 Implementing High Availability (Time: 3 hours)

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

Course Objectives

  • Describe the costs and risks involved in certain high-availability solutions
  • Implement log shipping and explain how it operates
  • Enable database mirroring using trace flags and use failover clustering
  • Discuss the strategies, types, and elements of replication
  • Explain Microsoft Analysis Services in SQL Server 2005

Course Topics

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

11. SQL Server 2005 MCTS 70-431:11 Practice Exams (Time: 1 hours)

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

Course Objectives

  • Complete the first set of practice exam questions.
  • Complete the second set of practice exam questions.

Course Topics

  • Practice Exam 1
  • Practice Exam 2
Quick Links
  1. Watch Presentation
  2. Free Demo
  3. Purchase Vouchers
  4. Partners
  5. Remote Courses
  6. Make Payment
  7. Contact Us
  8. Sitemap
  9. Privacy Policy
Courseware
  1. Purchase Courseware
Client Success
  1. Independent Survey
  2. Client List
  3. Testimonials
Join The Team
  1. Learn how you can become a Webucator Trainer
  2. Career Opportunities
Locations
  1. Where We've Trained
  2. We have trainers all over North America.
Compare Us
Compare Webucator to leading Competitors
Training Options
  1. Live eLearning Public Classes
  2. Private Training
  3. Self-Paced eLearning
Microsoft Partner
  1. Microsoft Certifications
  2. Certified Microsoft Courses
  3. Software Assurance Training Vouchers
Watch 3-minute Demo Video
of Live Online Training: Learn the benefits of online training with Webucator
Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.
© Webucator, Inc. All rights reserved. | Toll Free: 1-877-932-8228 | From outside the USA: 315-849-2724| Fax: 315-849-2723