Scheda corso
NovaNext Training / Microsoft / Cloud / Designing and Implementing Cloud Data Platform Solutions

Designing and Implementing Cloud Data Platform Solutions

Codice
MOC55247
Durata
3 Giorni
Prezzo
1.050,00 € (iva escl.)
Lingua
Italiano
Modalità
Virtual Classroom
e-Learning
Corso in aula
       

 

Schedulazione
Luogo Data Iscrizione
A Richiesta

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.

 

Prerequisiti

Per partecipare con profitto a questo corso è indispensabile avere un'ottima conoscenza di SQL Server o essere in possesso della certificazione MCSE Data Platform o avere conoscenze equivalenti

 

Obiettivi

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

 

Destinatari

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

 

Contenuti

Module 1: Designing and Implementing Database Solutions for SQL Server and Microsoft Azure

This 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 1: 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

Module 2: Designing and Implementing Database Solutions for SQL Server and Microsoft Azure

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 3: Manage, Design and Implement Database Security

This 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 1: Manage, Design and Implement Database Security

Implement SQL Server database security

Implement Azure SQL Database security

Module 4: Manage, Design and Implement Database Security

After completing this module, students will be able to:

Configure SQL Server database security

Configure Azure SQL Database security

Module 5: Design for High-Availability, Disaster Recovery and Scalability

This 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 1: 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 6: Monitor and Troubleshoot Database Implementations in Azure

This 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 1: Create Microsoft Azure Data Processes using Python

Monitor and Troubleshoot SQL Server

Monitor and Troubleshoot Azure SQL Databases

Module 7: Create Microsoft Azure Data Processes using Python

After completing this module, students will be able to:

Monitor and Troubleshoot SQL Servers

Monitor and Troubleshoot Azure SQL Databases