A Distancia
Error: Formulario de contacto no encontrado.
Error: Formulario de contacto no encontrado.
Objetivo:
Este curso provee a los estudiantes con los conocimientos y técnicas necesarias para planificar e implementar una solución de infraestructura de base de datos empresarial utilizando SQL Server 2014.
Requisitos:
Tener experiencia trabajando con bases de datos relacionales incluyendo: planificación e implementación de bases de datos, manejo de base de datos y consultas con Transact-SQL.
Duración:
40 horas
Temario:
- Introduction to Enterprise Data Architecture
- Considerations for Enterprise Data
- Assessing an Existing Infrastructure
- Multi-Server Configuration Management
- Policy-Based Management
- Microsoft System Center
- Introduction to Health Monitoring
- Monitoring SQL Server 2014 Health
- Data Collector
- SQL Server Utility
- Consolidating Database Workloads with SQL Server 2014
- Considerations for Database Server Consolidation
- Managing Resources in a Consolidated Database Infrastructure
- Overview of Cloud Computing
- SQL Server in a Private Cloud
- Introduction to Microsoft Azure
- Azure PowerShell
- Azure Storage and SQL Server
- Introduction to Azure SQL Database
- Azure SQL Database Security
- Implementing and Managing Databases
- Introduction to Azure Virtual Machines
- SQL Server in Microsoft Azure Virtual Machines
- Azure Virtual Machine Connectivity and Security
- Creating Databases in an Azure Virtual Machine
- Introduction to High Availability in SQL Server 2014
- High Availability Concepts and Options in SQL Server 2014
- Log Shipping
- Clustering with Windows Server and SQL Server 2014
- Introduction to Windows Server Failover Clustering
- SQL Server AlwaysOn Failover Cluster Instances
- Introduction to AlwaysOn Availability Groups
- Working with AlwaysOn Availability Groups
- Considerations for Using AlwaysOn Availability Groups
- Planning High Availability and Disaster Recovery
- High Availability and Disaster Recovery with SQL Server 2014
- High Availability and Disaster Recovery for Databases in Azure
- Replicating Data
- SQL Server Replication
- Planning Replication
Técnicas: Al finalizar el curso los estudiantes serán capaces de
- Assess an existing enterprise environment.
- Plan and implement Policy-Based Management.
- Describe the considerations for consolidating workloads with SQL Server 2014.
- Describe considerations for including SQL Server 2014 in a private cloud.
