Microsoft SQL Server 2008 Administración

Certiseg
En Madrid (España)

1.195€ - ($841.312)
+ IVA
¿O prefieres llamar ahora al centro?
+34 9... Ver más
Compara este curso con otros similares
Ver más cursos similares

Información importante

  • Curso
  • Madrid (España)
  • 30 horas de clase
Descripción

Objetivo del curso: Bases de Datos con SQL server 2005, ultima versión Microsoft.
Dirigido a: Todas las personas interesadas en esta certificación que te prepara en la última versión de Microsoft en bases de datos.

Información importante
Instalaciones

¿Dónde se da y en qué fecha?

comienzo Ubicación
Consultar
Madrid
C/Francisco Giralte,2, Madrid, España
Ver mapa

Preguntas Frecuentes

· Requisitos

Conocimientos básicos de desarrollo y programación.

¿Qué aprendes en este curso?

SQL

Temario

Module 1: Installing and Configuring SQL Server

  • Preparing to Install SQL Server
  • Installing SQL Server
  • Configuring a SQL Server Installation

Module 2: Managing Databases and Files

  • Planning Databases
  • Creating Databases
  • Using Policy-Based Management

Module 3: Disaster Recovery

  • Planning a Backup Strategy
  • Backing Up User Databases
  • Restoring User Databases
  • Performing Online Restore Operations
  • Recovering Data from Database Snapshots
  • System Databases and Disaster Recovery

Module 4: Managing Security

  • Overview of SQL Server Security
  • Protecting the Server Scope
  • Protecting the Database Scope
  • Protecting the Server Scope
  • Auditing Security

Module 5: Transferring Data

  • Overview of Data Transfer
  • Introduction to SQL Server Integration Services

Module 6: Automating Administrative Tasks

  • Using SQL Server Agent
  • Creating Maintenance Plans
  • Implementing Alerts
  • Managing Multiple Servers
  • Managing SQL Server Agent security

Module 7: Implementing Replication

  • Overview of Replication
  • Managing Publications and Subscriptions
  • Configuring Replication in Some Common Scenarios

Module 8: Maintaining High Availability

  • Introduction to High Availability
  • Implementing Log Shipping
  • Iplementing Database Mirroring
  • Implementing Server Clustering
  • Using Distributed High Availability Solutions

Module 9: Monitoring SQL Server

  • Viewing Current Activity
  • Using SQL Server Profiler
  • Monitoring with DDL Triggers
  • Using Event Notifications

Module 10: Troubleshooting and Performance Tuning

  • Troubleshooting SQL Server
  • Performance Tuning in SQL Server
  • Using Resource Governor
  • Using Data Collector

Module 11: Creating Databases and Database Files

  • Creating Databases
  • Creating File groups
  • Creating Schemas
  • Creating Database Snapshots

Module 12: Creating Data Types and Tables

  • Creating Data Types
  • Creating Tables
  • Creating Partitioned Tables

Module 13: Creating and Tuning Indexes

  • Planning Indexes
  • Creating Indexes
  • Optimizing Indexes

Module 14: Implementing Data Integrity by Using Constraints and Triggers

  • Data Integrity Overview
  • Implementing Constraints
  • Implementing Triggers

Module 15: Using XML

  • Using the XML Data Type
  • Retrieving XML by Using FOR XML
  • Shredding XML by Using OPENXML
  • Introducing XQuery
  • Creating XML Indexes
  • Implementing XML Schemas

Module 16: Implementing Views

  • Introduction to Views
  • Creating and Managing Views
  • Optimizing Performance by Using Views

Module 17: Implementing Stored Procedures

  • Implementing Stored Procedures
  • Creating Parameterized Stored Procedures
  • Working With Execution Plans
  • Handling Errors

Module 18: Implementing Functions

  • Creating and Using Functions
  • Working with Functions
  • Controlling Execution Context

Module 19: Implementing Managed Code in the Database

  • Introduction to the SQL Server Common Language Runtime
  • Importing and Configuring Assemblies
  • Creating Managed Database Objects

Module 20: Managing Transactions and Locks

  • Overview of Transactions and Locks
  • Managing Transactions
  • Understanding SQL Server Locking Architecture
  • Managing Locks

Module 21: Using Service Broker

  • Service Broker Overview
  • Creating Service Broker Objects
  • Sending and Receiving Messages

Información adicional

Alumnos por clase: 12

Compara este curso con otros similares
Ver más cursos similares