Course: MS2779/2780 Implementing and Maintaining a Microsoft SQL 2005 Database FAST TRACK

This Five-day instructor-led course training event provides delegates with the knowledge and skills needed to implement and maintain a Microsoft SQL Server 2005 database.

The course focuses on how to use SQL Server 2005 product features and tools related to implementing and maintaining the database. This event will also give delegates an overview of writing and creating Transact SQL queries.

This is an accelerated training event that will use elements from MS2779 and MS2780 courses, the delegates will also be supplied with an additional book

There are 18 Modules in this course:

Installing and configuring SQL Server 2005
Managing Databases and Files
Creating Data Types and Tables
Writing Queries Using Transact-SQL
Using XML
Creating and Tuning Indexes
Implementing Data Integrity
Implementing Views
Implementing Stored Procedures and Functions
Implementing Managed Code in the Database
Using Service Broker
Managing Security
Disaster Recovery
System Database and Disaster Recovery Monitoring SQL Server
Transferring Data
Automating Administrative Tasks
Maintaining High Availability
Introduction to Replication

By the end of the course, delegates will be able to:

•      Install and configure SQL Server 2005
•      Manage database files
•      Manage security
•      Perform administrative tasks
•      Backup databases
•      Rstore databases
•      Monitor SQL Server
•      Troubleshoot SQL Server
•      Transfer data
•      Maintain high availability
•      Create databases and database files
•      Create data types and tables
•      Use XML-related features in Microsoft SQL Server 2005
•      Plan, create, and optimize indexes
•      Implement data integrity in Microsoft SQL Server 2005 databases
•      Implement views
•      Implement stored procedures and functions
•      Implement managed code in the database
•      Use Service Broker to build a messaging-based solution