Certificación MCTS: SQL Server 2005

Descripción

La certificación MCTS: SQL Server 2005 (Microsoft Certified Technology Specialists en Microsoft SQL Server 2005) es la nueva credencial orientada a los profesionales TI que implementan y mantienen bases de datos usando instrucciones explícitas y especificaciones Microsoft SQL Server 2005. Asimismo, tienen un conocimiento profundo del producto, entienden como usar las herramientas y el lenguaje Transact-SQL y conocen como explorar la interfaz de usuario.

Temario

o Install SQL Server 2005.

o Configure SQL Server 2005 instances and databases.

o Configure SQL Server security.

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

o Implement database mirroring.

o Implement log shipping.

o Manage database snapshots.

o Retrieve data to support ad hoc and recurring queries.

o Manipulate relational data.

o Manage XML data.

o Implement an HTTP endpoint.

o Implement Service Broker components.

o Import and export data from a file.

o Manage replication.

o Implement and maintain SQL Server Agent jobs.

o Manage databases by using Transact-SQL.

o Back up a database.

o Restore a database.

o Move a database between servers.

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

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

o Monitor and resolve blocks and deadlocks.

o Diagnose and resolve database server errors.

o Monitor SQL Server Agent job history.

o Implement a table.

o Implement a view.

o Implement triggers.

o Implement functions.

o Implement stored procedures.

o Implement constraints.

o Implement indexes.

o Create user-defined types.

o Implement a full-text search.

o Implement partitions.