Designing a Data Solution with Microsoft SQL Server (20465)

Descripcion de Curso Calendario Esquema del Curso Topología de laboratorio
 

Quién debería asistir

This course is intended for IT professionals whose primary responsibilities include planning and implementing:

  • Database infrastructure
  • Consolidation strategies
  • High availability solutions
  • Disaster recovery solutions

Prerrequisitos

This course requires that you have at least 2 years’ experience of working with relational databases, including:

  • Planning and implementing databases
  • Managing databases
  • Querying with Transact-SQL
  • Some basic knowledge of high availability and disaster recovery

Objetivos del curso

  • Understand the considerations for enterprise data infrastructure
  • Use the MAP Toolkit to assess an existing enterprise data environment
  • Implement Policy-Based Management
  • Use System Center to manage database infrastructure
  • Understand the options for multi-server health monitoring in SQL Server 2014
  • Configure Data Collector
  • Understand the considerations for consolidating databases and database servers
  • Explain the options for managing resources in various consolidation scenarios.
  • Explain the fundamental concepts behind cloud computing, and describe the technologies that underpin Microsoft cloud solutions
  • Provide SQL Server based data services in a private cloud infrastructure
  • Understand the core concepts and options for implementing high availability in SQL Server 2014
  • Implement high availability for individual databases by using log shipping
  • Describe the key benefits and features of Windows Server Failover Clustering
  • Describe how to use SQL Server AlwaysOn Failover Cluster Instances to maintain high availability for SQL Server instances
  • Describe the fundamental concepts and terminology for AlwaysOn Availability Groups
  • Explain how work with AlwaysOn Availability Groups
  • Explain the considerations for implementing high availability and disaster recovery by using SQL Server 2014, and describe some common scenarios
  • Explain the considerations for implementing high availability and disaster recovery by using SQL Server 2014 and Microsoft Azure services, and describe some common scenarios.
  • Describe SQL Server replication
  • Identify an appropriate replication solution for a particular scenario

Contenido del curso

The focus of this three-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 and how to plan and implement high availability and disaster recovery solutions.

Note: This course is relevant for both SQL Server 2012 and SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Classroom training
Modality: G

Duración 3 días

Fechas y Registro
 
Presionar el boton sobre el nombre de la ciudad para reservar Calendario
España

Actualmente no hay fechas de entrenamiento disponibles.  Para consultas por favor escribir a info@flane.es

Europa
Italia
29.10. - 31.10.2018 Roma
11.02. - 13.02.2019 Milano
06.05. - 08.05.2019 Roma
15.07. - 17.07.2019 Milano
Polonia
03.12. - 05.12.2018 Varsovia
América Latina
Perú
22.10. - 24.10.2018 Entrenamiento en línea Zona Horaria: America/Lima Lenguaje del curso: Español
Oriente Medio
Arabia Saudita
14.10. - 16.10.2018 Riad Lenguaje del curso: Inglés
Emiratos Árabes Unidos
30.09. - 02.10.2018 Dubai Lenguaje del curso: Inglés This course is being delivered by iTLS.
16.12. - 18.12.2018 Dubai Lenguaje del curso: Inglés This course is being delivered by iTLS.
24.03. - 26.03.2019 Dubai Lenguaje del curso: Inglés This course is being delivered by iTLS.
23.06. - 25.06.2019 Dubai Lenguaje del curso: Inglés This course is being delivered by iTLS.
Katar
23.06. - 25.06.2019 Doha Lenguaje del curso: Inglés
Africa
Egipto
04.11. - 06.11.2018 El Cairo Lenguaje del curso: Inglés
24.03. - 26.03.2019 El Cairo Lenguaje del curso: Inglés
23.06. - 25.06.2019 El Cairo Lenguaje del curso: Inglés
Este es un curso en línea Guiado por un Instructor
 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!