0345 4506120

M55247 Designing and Implementing Cloud Data Platform Solutions (M55247)

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.

Target Audience

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

Reset

Learning Objectives

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

Pre-Requisites

  • Experience working with databases
  • Experience using SQL

Course Content

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 for module 1

  • 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 module 1, 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 Security

This module explains how to setup security for an on-premises or Azure database.

Lessons for module 2

  • 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 module 2, students will be able to:

  • Configure SQL Server database security
  • Configure Azure SQL Database security

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

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

Lessons for module 3

  • 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 module 3, 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 Azure

This module explains how to monitor and troubleshoot database implementations.

Lessons for module 4

  • 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 module 4, students will be able to:

  • Monitor and Troubleshoot SQL Servers
  • Monitor and Troubleshoot Azure SQL Databases

Additional Reading

  • Courses 552241A and 552242A

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

Online Courses

You may prefer an online course if you are looking for a flexible and cost-effective solution. Online courses allow you to study at your own pace, at a time that suits you.

We have the following eLearning options available:

Our Customers Include