20465 – Designing a Data Solution with Microsoft® SQL Server

 

Ver calendario

 

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.

 

 

13 julio, 2017

Empower

La misión de Ulearn es brindar soluciones de capacitación para profesionales de TI, que se traduzca en optimización de sus habilidades para una mayor eficiencia.

mail [email protected]
tel
+598 98 410 014

Redes Sociales

linkedin