 |
|
Informática: Certificaciones:
|
|
|
Curso de Implementing and Maintaining
a Microsoft SQL Server 2005 Database
Aprende a
implementar y mantener bases de datos Microsoft SQL Server
|
-Tipo
de curso: Presencial (Madrid)
|
Idioma:
Español
|
|
|
-Precio:
650 €
|
Válido en:
España
|
 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:
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.
Contenido:
El temario del curso es el siguiente:
- Installing and Configuring SQL Server 2005
- Managing Databases and Files
- Disaster Recovery
- Managing Security
- Monitoring SQL Server
- Transferring Data
- Automating Administrative Tasks
- Maintaining High Availability
- Creating Databases and Database Files
- Creating Data Types and Tables
- Using XML
- Creating and Tuning Indexes
- Implementing Data Integrity
- Implementing Views, this module explains how to create views.
- Implementing Stored Procedures and Functions
- Implementing Managed Code in the Database
- Using Service Broker
Lugar
Certiseg S.L.
Fecha inicial
12/06/2006
Fecha Final
16/06/2006
HV_MENSAJE
|
|
|
|
| |
|
|
Otros cursos relacionados con: Implementing and Maintaining a Microsoft SQL Server 2005 Database
|
|
|
|
|
