SQL Server 2005 MCTS

Topics: 11

Length: 26 hours

Location: Online

This course will show you how to use, install and configure SQL Server 2005 and should be used by anyone preparing to take the SQL Server MCTS exam or anyone wishing to learn more about SQL Server 2005

Topic 1: Installing and Configuring SQL Server 2005

This tutorial will show you the correct way to prepare and install SQL Server 2005.

Topic 2: Creating Databases

You will see how to create databases in SQL Server 2005 and establish views you can use to work with the data.

Topic 3: Working with Tables and Programmability Objects

This topic shows you how to work with SQL Server Objects such as tables, triggers, functions, stored procedures and indexes.

Topic 4: Implementing Database Objects

This part shows you how to work with the data in the database tables. How to insert records, query tables and use views and data types.

Topic 5: Supporting the XML Framework

This tutorial will give you an understanding of how to manage XML within SQL Server 2005.

Topic 6: Enhancing Data Consumption and Throughput

This course shows you how to copy large amounts of data within a single server or between servers. Bulk Copy Program (BCP) and SQL Server Integration Services (SSIS) are also introduced.

Topic 7: Maintaining and Backing Up Databases

You will receive information on how to maintain and back up the database, including working with database snapshots and restoring from a backup.

Topic 8: Monitoring Performance

In SQL Server 2005 there are several tools that you will be shown how to use such as the SQL Server Management Studio, the Activity Monitor and various others.

Topic 9: Troubleshooting and Optimizing

This tutorial explains how to correct issues that may happen when using SQL Server 2005. It also gives you an understanding on how to optimize SQL Server for the best performance

Topic 10: Implementing High Availability

How to implement high-availability solutions such as database mirroring, log shipping, replication, and failover clusters.

Topic 11: Practice Exams

This part provides practice questions and answers for the SQL Server 2005 MCTS 70-431 exam.