20465 – Designing a Data Solution With Microsoft® SQLServer® 2014

20465 – Designing a Data Solution With Microsoft® SQLServer® 2014

SOBRE ESTE CURSO
The focus of this five-day instructor-led course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies. It describes how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014.  It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

 PERFIL DO PÚBLICO
This course is intended for database professionals who need who plan, implement, and manage database solutions. Primary responsibilities include:

  • Planning and implementing database infrastructure.
  • Planning and implementing consolidation strategies.
  • Implementing SQL Server in on-premises, cloud, and hybrid IT scenarios.
  • Planning and implementing high availability solutions.
  • Planning and implementing disaster recovery solutions.

 NO FINAL DO CURSO

After completing this course, students will be able to:

  • 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.
  • Use Microsoft Azure storage with SQL Server 2014.
  • Implement and configure databases in Microsoft Azure SQL Database.
  • Implement and configure databases in Microsoft Azure virtual machines.
  • Describe high availability technologies in SQL Server 2014 and implement log shipping.
  • Describe Windows Server Failover Clustering and Implement an AlwaysOn Failover Cluster

Instance.

  • Implement an Always On Availability Group.
  • Plan high availability and disaster recovery solutions.
  • Plan and implement database replication.

 CONTEÚDO PROGRAMÁTICO 

Module 1: Introduction to Enterprise Data Architecture
Module 2: Multi-Server Configuration Management
Module 3: Monitoring SQL Server 2014 Health
Module 4: Consolidating Database Workloads with SQL Server 2014
Module 5: Introduction to Cloud Data Solutions
Module 6: Introduction to Microsoft Azure™
Module 7: Microsoft Azure SQL Database
Module 8: SQL Server in Microsoft Azure Virtual Machines
Module 9: Introduction to High Availability in SQL Server 2014
Module 10: Clustering with Windows Server and SQL Server 2014
Module 11: AlwaysOn Availability Groups
Module 12: Planning High Availability and Disaster Recovery
Module 13: Replicating Data

 

INFORMAÇÕES ADICIONAIS:
Carga Horária: 40H
Idioma: Apenas em Inglês
Material didático: Oficial Microsoft Digital.

OBSERVAÇÃO:
Os treinamentos serão ministrados com 01 aluno por computador, tendo no mínimo 06 (seis) alunos por turma ou no máximo 08 (oito).
A ZLN Cursos se reserva no direito de não oferecer o curso, caso não seja preenchido o número mínimo de vagas.



SOLICITAR PROPOSTA

PREENCHA OS CAMPOS ABAIXO PARA SOLICITAR UMA PROPOSTA, TODOS OS CAMPOS SÃO OBRIGATÓRIOS.