Curso Oficial de Microsoft en Administracion de SQL Server 2008

La credencial Microsoft Certified Technology Specialists (MCTS) permite certificarse en un área específica de conocimiento. Gracias a ella, es posible distinguirse como experto en administración de bases de datos, desarrollo de bases de datos o en el desarrollo de Dusiness Intelligence.

Sabías que según estudios de consultoras como IDC o Gartner, un 55% de directivos de empresas de TI consideran decisivo que un individuo posea una certificación a la hora de contratar un nuevo recurso? ¿O que un 43% de trabajadores de TI reconocieron haber recibido un aumento de sueldo tras conseguir una certificación Microsoft?

Contenido Resumido Del Program De Estudios
Instalación Y Mantenimiento De Sql Server 2008. Preparación Para El Examen De Certificación Oficial 70-432
Installing and Configuring SQL Server 2008

• Install SQL Server 2008 and related services.
• Configure SQL Server instances.
• Configure SQL Server services.
• Configure additional SQL Server components.
• Implement database mail.
• Configure full-text indexing.

Maintaining SQL Server Instances
• Manage SQL Server Agent jobs.
• Manage SQL Server Agent alerts.
• Manage SQL Server Agent operators.
• Implement the declarative management framework (DMF).
• Back up a SQL Server environment.

Managing SQL Server Security
• Manage logins and server roles.
• Manage users and database roles.
• Manage SQL Server instance permissions.
• Manage database permissions.
• Manage schema permissions and object permissions.
• Audit SQL Server instances.
• Manage transparent data encryption.
• Configure surface area.
• Back up databases.
• Restore databases.
• Manage database snapshots.
• Maintain database integrity.
• Maintain a database by using maintenance plans.

Performing Data Management Tasks
• Import and export data.
• Manage data partitions.
• Implement data compression.
• Maintain indexes.
• Manage collations.

Monitoring and Troubleshooting SQL Server
• Identify SQL Server service problems.
• Identify SQL Agent job execution problems.
• Locate error information.

Optimizing SQL Server Performance
• Implement Resource Governor.
• Use the Database Engine Tuning Advisor.
• Collect trace data by using SQL Server Profiler.
• Collect performance data by using Dynamic Management Views (DMVs).
• Collect performance data by using System Monitor.
• Use Performance Studio.

ADMINISTRACIÓN DE MICROSOFT SQL SERVER 2008. PREPARACIÓN PARA EL EXAMEN DE CERTIFICACIÓN OFICIAL 70-450
Designing a SQL Server Instance and a Database Solution Design for CPU, memory, and storage capacity requirements.
• Design SQL Server instances.
• Design physical database and object placement.
• Design a migration, consolidation, and upgrade strategy.

Designing a Database Server Security Solution
• Design instance authentication
• Design instance-level security configurations
• Design database, schema, and object security paramaters
• Design a security policy and an audit plan
• Design an encryption strategy

Designing a Database Solution for High Availability
• Design a failover clustering solution
• Design database mirroring
• Design a high-availability solution that is based on replication
• Design a high-availability solution that is based on log shipping
• Select high-availability technologies based on business requirements
• Designing a Backup and Recovery Solution
• Design a backup strategy
• Design a recovery strategy
• Design a recovery test plan

Designing a Monitoring Strategy
• Design a monitoring solution at the operating system level
• Design a monitoring solution at the instance level
• Design a solution to monitor performance and concurrency

Designing a Strategy to Maintain and Manage Databases
• Design a maintenance strategy for database servers
• Design a solution to govern resources
• Design policies by using Policy-Based Management
• Design a data compression strategy
• Design a management automation strategy

Designing a Strategy for Data Distribution
• Administer SQL Server Integration Services (SSIS) packages
• Design a strategy to use linked servers
• Design a replication strategy for data distribution