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.
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.
Implementing Database Objects
This course explains how to work with the data in database tables.
Implementing High Availability
This course explains how to implement high-availability solutions such as log shipping, database mirroring, failover clusters, and replication.
Installing and Configuring SQL Server 2005
This course explains how to prepare for the installation and configuration of SQL Server 2005.
Maintaining and Backing Up Databases
This course explains how to use SQL Server 2005 to maintain and backup databases.
Monitoring Performance
This course explains how to monitor the performance of a SQL Server 2005 system.
Practice Exams
This course provides practice questions for the SQL Server 2005 MCTS 70-431 exam.
Supporting the XML Framework
This course explains how to manage the XML data and features that are integrated into SQL Server 2005.
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.
Working with Tables and Programmability Objects
This course provides you with information concerning job skills tested by Microsoft Exam MCTS70-431.
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:
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