Curso 2779/80 Implementing and Maintaining a Microsoft SQL Server 2005 Database

El Curso 2779/80 Implementing and Maintaining a Microsoft SQL Server 2005 Database es presencial, se imparte en Madrid y tiene una duración de 30 horas.

DURACIÓN DEL CURSO 2779/80 IMPLEMENTING AND MAINTAINING A MICROSOFT SQL SERVER 2005 DATABASE

30 Horas


INTRODUCCIÓN DEL CURSO 2779/80 IMPLEMENTING AND MAINTAINING A MICROSOFT SQL SERVER 2005 DATABASE

MOC-2779 Implementing a Microsoft SQL Server 2005 Database
MOC-2780 Maintaining a Microsoft SQL Server 2005 Database

This course provides students with product knowledge and skills needed to implement and maintain Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.


OBJETIVOS DEL CURSO 2779/80 IMPLEMENTING AND MAINTAINING A MICROSOFT SQL SERVER 2005 DATABASE

After completing this course, students will be able to:

-Install and configure SQL Server 2005.
-Manage database files.
-Manage security.
-Perform administrative tasks.
-Back up databases.
-Restore 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 by using constraints, triggers, and XML schemas.
-Implement views.
-Implement stored procedures and functions.
-Implement managed code in the database.
-Use Service Broker to build a messaging-based solution.

Fabricante: Microsoft
Idioma: Español (Manual de consulta en Inglés)
Examenes: Examen: 70-431


CONTENIDO DEL CURSO 2779/80 IMPLEMENTING AND MAINTAINING A MICROSOFT SQL SERVER 2005 DATABASE

El temario del curso es el siguiente:

1. Installing and Configuring SQL Server 2005
2. Managing Databases and Files
3. Disaster Recovery
4. Managing Security
5. Monitoring SQL Server
6. Transferring Data
7. Automating Administrative Tasks
8. Maintaining High Availability
9. Creating Databases and Database Files
10. Creating Data Types and Tables
11. Using XML
12. Creating and Tuning Indexes
13. Implementing Data Integrity
14. Implementing Views, this module explains how to create views.
15. Implementing Stored Procedures and Functions
16. Implementing Managed Code in the Database
17. Using Service Broker