Nabídka tohoto termínu kurzu již není aktuální. Podobné kurzy naleznete zde.

MOC 55247A Designing and Implementing Cloud Data Platform Solutions

Základní info

Popis kurzu

This three-day instructor-led course is intended for data professionals who want to design and implement database solutions in SQL Server and on Microsoft Azure. Security, Availability, Disaster Recovery, Scalability, Monitoring and Troubleshooting options will also be demonstrated.


This three-day instructor-led course is intended for data professionals who want to design and implement database solutions in SQL Server and on Microsoft Azure. Security, Availability, Disaster Recovery, Scalability, Monitoring and Troubleshooting options will also be demonstrated.

Určeno pro

This course is intended for experienced data professionals who design and implement on-premises and Microsoft Azure data solutions.

Obsah kurzu

After completing this course, students will be able to:



  • Create SQL Server and Microsoft Azure data solutions

  • Create Security solutions for on-premises and cloud databases

  • Configure High-Availability, Disaster Recovery and Scalability options for databases

  • Monitor, Manage and Automate database solutions


Course Outline


Module 1: Designing and Implementing Database Solutions for SQL Server and Microsoft AzureThis module explains how to design a database solution for SQL Server and Microsoft Azure databases.Lessons



  • Design and Implement Hybrid SQL Server solutions

  • Design and Implement Azure SQL Database solutions

  • Design and Implement MySQL and PostgreSQL database solutions in Azure

  • Review


Lab : Designing and Implementing Database Solutions for SQL Server and Microsoft Azure



  • Implement a Hybrid SQL Server solution

  • Implement an Azure SQL Database solution

  • Implement a MySQL database solution

  • Implement a PostgreSQL database solution


After completing this module, students will be able to:



  • Install and configure SQL Server on an Azure VM

  • Install and configure Azure databases

  • Install and configure MySQL and PostgreSQL databases


Module 2: Manage, Design and Implement Database SecurityThis module explains how to setup security for an on-premises or Azure database.Lessons



  • Design and Implement SQL Server database security

  • Design and Implement Azure SQL Database security

  • Review


Lab : Manage, Design and Implement Database Security



  • Implement SQL Server database security

  • Implement Azure SQL Database security


After completing this module, students will be able to:



  • Configure SQL Server database security

  • Configure Azure SQL Database security


Module 3: Design for High-Availability, Disaster Recovery and ScalabilityThis module explains how to configure database solutions for High-Availability, Disaster Recovery and Scalability.Lessons



  • Design and Implement High-Availability Solutions

  • Design and Implement Disaster Recovery Solutions

  • Design and Implement Scalability Solutions

  • Review


Lab : Create Microsoft Azure Data Objects using Python



  • Implement a High-Availability Solution

  • Implement a Disaster Recovery Solution

  • Implement a Scalability Solution


After completing this module, students will be able to:



  • Configure a High-Availability solution

  • Configure a Disaster Recovery Solution

  • Configure a Scalability Solution


Module 4: Monitor and Troubleshoot Database Implementations in AzureThis module explains how to monitor and troubleshoot database implementations.Lessons



  • Monitor and Troubleshoot SQL Server VMs on Azure

  • Monitor and Troubleshoot Azure SQL Databases

  • Review


Lab : Create Microsoft Azure Data Processes using Python



  • Monitor and Troubleshoot SQL Server

  • Monitor and Troubleshoot Azure SQL Databases


After completing this module, students will be able to:



  • Monitor and Troubleshoot SQL Servers

  • Monitor and Troubleshoot Azure SQL Databases

Předpoklady


  • Experience working with databases

  • Experience using SQL

Studijní materiály

V angličtině

MOC 55247A Designing and Implementing Cloud Data Platform Solutions

Vybraný termín:

22.11.2021  ONLINE

Cena

Kontaktovat dodavatele


Kontrola proti spamu. Kolik je deset a čtyři ? Součet zapište číslicemi.