Designing and Implementing Cloud Data Platform Solutions

Course Details
Code: 55247
Tuition (USD): $2,095.00 $1,885.50 • Classroom (3 days)
$2,095.00 $1,885.50 • Virtual (3 days)

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 features.Note: The Microsoft Azure environment is being improved and upgraded regularly. This course has been designed to be updated when Azure changes are implemented, so ALL lab exercises will continue to work. Course updates will be available to current and former students through the SkillPipe platform.
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.

Skills Gained

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

  • 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

Who Can Benefit

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

  • Experience working with databases
  • Experience using SQL

Course Details

Outline

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