sql server 2005 mcts 70 431 online training course

Receive your login ID to take the training courses online, as many times as you wish, for 1 year. Click here for group orders.

Buy this entire online training course with one easy payment of $67

Benefits

Unlimited access for 1 year
Learn anytime, anywhere
You control the pace
Start & stop wherever you want
No books to read
No software needed
Value Packs include Free online tech support
Double guarantee

100% Money back guarantee
One time payment No monthly fee
Use the course index for review anytime
Answer course questions with at least 70% accuracy and print your own certificates of completion to prove that you have mastered each training course.
Free status reports for company managers

Requirements

All you need is a PC with Windows, the Microsoft Internet Explorer (browser) and an Internet connection.
Note: The online computer training is designed to work only with Internet Explorer. Prices shown are per user.

What You will Learn

This online training course explains how to install, configure, and use SQL Server 2005.

Installing and Configuring SQL Server 2005

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

Creating Databases

Create and alter databases
Employ views for data query operations

Use indexed views
Use partitioned views

Working with Tables and Programmability Objects

Implementing a table
Implementing triggers
Implementing functions

Implementing stored procedures
Implementing constraints
Implementing indexes

Implementing Database Objects

Perform queries that extract data
Produce reports
Insert, update, and remove data

Use full text queries
Use system tables and views

Supporting the XML Framework

Recognize the importance of XML within a SQL Server database
Describe how to output data in XML format
Explain methods associated with the xml data type

Identify the new features and functionality for XML in SQL Server 2005
Use the xml data type
Create XML indexes

Enhancing Data Consumption and Throughput

Explain importing and exporting data with SQL Server 2005
Import and export data using the Bulk Copy Program (BCP)
Assemble components into a service

Use SSIS to handle the import and export of data
Implement Service Broker
Use OPENROWSET to access any OLE DB data source

Maintaining and Backing Up Databases

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

Monitoring Performance

Describe monitoring tools used by SQL Server 2005
Identify the features of Log File Viewer
Define a SQL Profiler trace

Describe the types of server maintained information found in SQL Server 2005
List types of System Monitor counters

Troubleshooting and Optimizing

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

Implementing High Availability

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

Practice Exams

Complete the first set of practice exam questions

Complete the second set of practice exam questions

SQL Server 2005 MCTS 70 431 Join over 1 million people who learn online, with these complete interactive computer training courses.

SQL Server 2005 MCTS 70 431
Join over 1 million people who learn online, with these complete interactive computer training courses.