Curso DP-300: Administering Relational Databases on Microsoft Azure

Você sabe a diferença entre os cursos online e os cursos a distância?

No Curso online você tem aulas digitais e interage com mentores reais ao vivo. Já no Curso a distância, tanto o conteúdo, quanto a interação são digitais.

• Conteúdo Programático:

  Módulo I - Plan and Implement Data Platform Resources  

  ·        Deploy resources by using manual methods;
  ·        Recommend an appropriate database offering based on specific requirements;
  ·        Configure resources for scale and performance;
  ·        Evaluate a strategy for moving to Azure;
  ·        Implement a migration or upgrade strategy for moving to Azure.

  Módulo II - Implement a Secure Environment

  ·        Configure database authentication by using platform and database tools;
  ·        Configure database authorization by using platform and database tools;
  ·        Implement security for data at rest;
  ·        Implement security for data in transit;
  ·        Implement compliance controls for sensitive data.

  Módulo III - Monitor and Optimize Operational Resources 

  ·        Monitor activity and performance;
  ·        Identify performance-related issues;
  ·        Configure resources for optimal performance;
  ·        Configure a user database for optimal performance.

  Módulo IV - Optimize Query Performance

  ·        Review query plans;
  ·        Evaluate performance improvements;
  ·        Review database table and index design.

  Módulo V - Perform Automation of Tasks

  ·        Create scheduled tasks;
  ·        Evaluate and implement an alert and notification strategy;
  ·        Manage and automate tasks in Azure.

  Módulo VI - Plan and Implement a High Availability and Disaster Recovery (HADR) Environment

  ·        Recommend an HADR strategy for a data platform solution;
  ·        Test an HADR strategy by using platform, OS, and database tools;
  ·        Configure HA/DR by using OS, platform, and database tools.

  Módulo VII - Perform Administration by Using T-SQL

  ·        Perform Administration by Using T-SQL;
  ·        Perform backup and restore a database by using T-SQL;
  ·        Manage authentication by using T-SQL;
  ·        Manage authorization by using T-SQL.

   

• Pré-Requisito:

  
  

• Informações Adicionais:

  
  

• Material Didático: