55247AC: Designing and Implementing Cloud Data Platform Solutions

Course Overview

This three-day instructor-led course is intended for data professionals who want to design and implement Microsoft Azure solutions for SQL Server, Azure SQL Database, MySQL and PostgreSQL. Microsoft Azure subscriptions will be issued to each student so they can practice migration, security, availability, disaster Recovery, scalability, monitoring and troubleshooting solutions.

Key Learning Areas

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

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.

Design and Implement Hybrid SQL Server solutions
Design and Implement Azure SQL Database solutions
Design and Implement MySQL and PostgreSQL database solutions in Azure

Labs:

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

Designing and Implementing Database Solutions for SQL Server and Microsoft Azure

Install and configure SQL Server on an Azure VM
Install and configure Azure databases
Install and configure MySQL and PostgreSQL databases

Manage, Design and Implement Database Security

Design and Implement SQL Server database security
Design and Implement Azure SQL Database security

Labs:

Manage, Design and Implement Database Security
Implement SQL Server database security
Implement Azure SQL Database security

Manage, Design and Implement Database Security

Configure SQL Server database security
Configure Azure SQL Database security

Design for High-Availability, Disaster Recovery, and Scalability

This module explains how to configure database solutions for High-Availability, Disaster Recovery and Scalability.

Design and Implement High-Availability Solutions
Design and Implement Disaster Recovery Solutions
Design and Implement Scalability Solutions

Labs:

Create Microsoft Azure Data Objects using Python
Implement a High-Availability Solution
Implement a Disaster Recovery Solution

Implement a Scalability Solution

Configure a High-Availability solution
Configure a Disaster Recovery Solution
Configure a Scalability Solution

Monitor and Troubleshoot Database Implementations in Azure

This module explains how to monitor and troubleshoot database implementations.

Monitor and Troubleshoot SQL Server VMs on Azure
Monitor and Troubleshoot Azure SQL Databases

Labs:

Create Microsoft Azure Data Processes using Python
Monitor and Troubleshoot SQL Server
Monitor and Troubleshoot Azure SQL Databases

Create Microsoft Azure Data Processes using Python

Monitor and Troubleshoot SQL Servers
Monitor and Troubleshoot Azure SQL Databases

Who Benefits

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 course is intended for experienced data professionals who design and implement on-premises and Microsoft Azure data solutions.

Prerequisites

Experience working with databases
Experience using SQL

Want this course for your team?

Atmosera can provide this course virtually or on-site. Please reach out to discuss your requirements.

Atmosera is thrilled to announce that we have been named GitHub AI Partner of the Year.