Mcitp Database Administrator Microsoft Certified It Professional SQL Server 2005

La credencial Microsoft Certified IT Professional: Database Administrator es la certificación para profesionales que implementan y administran bases de datos de Microsoft SQL Server™.

El perfil del candidato debe contar con experiencia usando SQL Server 2005 o una versión anterior de SQL Server. Asimismo serán estudiantes ó profesionales de TI que tienen empleos en qué la administración de servidores de base de datos es una de sus principales áreas de responsabilidad, e incluso trabajan en entornos en los que las bases de datos son fundamentales para sus áreas de trabajo. Estas funciones de trabajo incluyen:

• Profesionales en entornos en los que SQL Server es parte de una solución global en la empresa. Servidores de Base de Datos, CRM, ERP.

• Profesionales de Administración de Sistemas que deseen implementar ó ya ejecutan SQL Server.

• Profesionales que trabajan con aplicaciones de terceros que están integradas en SQL Server 2008.

• Desarrolladores que crean aplicaciones que utilizan SQL Server 2008.

Desde hoy puede destacar entre la multitud y acreditar el excelente nivel de ésta certificación de la mano de la propia multinacional.

Exam 70-431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance

Installing and Configuring SQL Server 2005

· Install SQL Server 2005.

· Configure SQL Server 2005 instances and databases.

· Configure SQL Server security.

· Configure linked servers by using SQL Server Management Studio (SSMS).

Implementing High Availability and Disaster Recovery

· Implement database mirroring.

· Implement log shipping.

· Manage database snapshots.

Supporting Data Consumers

· Retrieve data to support ad hoc and recurring queries.

· Manipulate relational data.

· Manage XML data.

· Implement an HTTP endpoint.

· Implement Service Broker components.

· Import and export data from a file.

· Manage replication.

Maintaining Databases

· Implement and maintain SQL Server Agent jobs.

· Manage databases by using Transact-SQL.

· Back up a database.

· Back up a database.

· Restore a database.

· Move a database between servers.

Monitoring and Troubleshooting SQL Server Performance

· Gather performance and optimization data by using the SQL Server Profiler.

· Gather performance and optimization data by using the Database Engine Tuning Advisor.

· Monitor and resolve blocks and deadlocks.

· Diagnose and resolve database server errors.

· Monitor SQL Server Agent job history.

· Gather performance and optimization data by using DMVs.

Creating and Implementing Database Objects

· Implement a table.

· Implement a view.

· Implement triggers.

· Implement functions.

· Implement stored procedures.

· Implement constraints.

· Implement indexes.

· Create user-defined types.

· Implement a full-text search.

Designing a Database Server Infrastructure

· Design for capacity requirements.

· Specify software versions and hardware configurations.

· Design physical storage.

· Design instances.

· Design a database consolidation strategy.

Designing Security for a Database Server Solution

· Analyze business requirements.

· Integrate database security with enterprise-level authentication systems.

· Develop Microsoft Windows server-level security policies.

· Modify the security design based on the impact of network security policies.

· Analyze the risk of attacks to the server environment and specify mitigations.

· Design SQL Server service-level security.

· Design database-level security.

· Design object-level security.

Designing a Physical Database

· Modify an existing database design based on performance and business requirements.

· Design tables.

· Design file groups.

· Design index usage.

· Design views.

· Create database conventions and standards.

· Create database change-control procedures.

Designing a Database Solution for High Availability

· Select high-availability technologies based on business requirements.

· Develop a strategy for migration to a highly available environment.

· Design a highly available database storage solution.

· Design a database-clustering solution.

· Design database mirroring.

· Design a high-availability solution that is based on replication.

· Design log shipping.

Designing a Data Recovery Solution for a Database

· Specify data recovery technologies based on business requirements.

· Design backup strategies.

· Create a disaster recovery plan.

Designing a Strategy for Data Archiving

· Select archiving techniques based on business requirements.

· Design the format of archival data.

· Specify what data to archive.

· Plan for data archival and access.

· Design the topology of replication for archiving data.

· Design the type of replication for archiving data.

Optimizing the Performance of Database Servers and Databases

· Troubleshoot physical server performance.

· Troubleshoot instance performance.

· Troubleshoot database performance.

· Troubleshoot and maintain query performance.

· Troubleshoot concurrency issues.

Optimizing and Implementing a Data Recovery Plan for a Database

· Diagnose causes of failures. Failure types include database failures, physical server failures, and SQL Server service failures.

· Plan for fault-tolerance.

· Recover from a failure of SQL Server 2005.

· Recover from a database disaster.

· Salvage good data from a damaged database by using restoration techniques.

Designing a Strategy to Monitor and Maintain a Database Solution

· Define and implement monitoring standards for a physical server.

· Choose the appropriate information to monitor.

· Create and implement a maintenance strategy for database servers.

· Design a database maintenance plan.

· Design a strategy to manage Reporting Services.

Designing a Database Data Management Strategy

· Design and manage SQL Server Integration Services (SSIS) packages.

· Enforce data quality according to business requirements.

· Design data integrity.

· Design a strategy to manage data across linked servers.

· Design a strategy to manage replication.

· Optimize a database control strategy to meet business requirements.

Designing a Strategy to Manage and Maintain Database Security

· Perform a security audit of the existing security infrastructure based on the security plan.

· Maintain a server-level security strategy.

· Maintain a user-level security strategy.

· Prepare for respond to threats and attacks.