Acceso Mcts Microsoft SQL Server 2005 Administrador

MAINTAINING A MICROSOFT SQL SERVER 2005 DATABASE

• Module 1: Installing and Configuring SQL Server 2005

• Module 2: Managing Databases and Files

• Module 3: Disaster Recovery

• Module 4: Managing Security

• Module 5: Monitoring SQL Server

• Module 6: Transferring Data

• Module 7: Automating Administrative Tasks

• Module 8: Maintaining High Availability

• Module 9: Introduction to Replication

IMPLEMENTING A MICROSOFT SQL SERVER 2005 DATABASE

• Module 1: Creating Databases and Database Files

• Module 2: Creating Data Types and Tables

• Module 3: Using XML

• Module 4: Creating and Tuning Indexes

• Module 5: Implementing Data Integrity

• Module 6: Implementing Views

• Module 7: Implementing Stored Procedures and functions

• Module 8: Implementing Managed Code in the Database

• Module 9: Using Service Brokerusing ISA Server Enterprise Edition. 

The scenario will demonstrate how to implement a site-to-site
VPN scenario that reflects a minimal but realistic set of business requirements.