Designing and Implementing Cloud Data Platform Solutions

Prerequisites:

• Experience working with databases
• Experience using SQL

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

Additional ReadingCourses 552241A and 552242A