Designing and Implementing Cloud Data Platform Solutions

Session Detail:    Classroom, Virtual 3 Day

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.

Prerequisites

  • Experience working with databases
  • Experience using SQL

Who Can Benefit

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

Session Outline

Class Outline

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

  • Lesson 1: Design and Implement Hybrid SQL Server solutions
  • Lesson 2: Design and Implement Azure SQL Database solutions
  • Lesson 3: Design and Implement MySQL and PostgreSQL database solutions in Azure
  • Lesson 4: Review

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

  • Lesson 1: Install and configure Azure databases
  • Lesson 2: Install and configure MySQL and PostgreSQL databases

Module 3: Manage, Design and Implement Database Security

  • Lesson 1: Design and Implement SQL Server database security
  • Lesson 2: Design and Implement Azure SQL Database security
  • Lesson 3: Review

Module 4: Manage, Design and Implement Database Security

  • Lesson 1: Configure Azure SQL Database security

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

  • Lesson 1: Design and Implement High-Availability Solutions
  • Lesson 2: Design and Implement Disaster Recovery Solutions
  • Lesson 3: Design and Implement Scalability Solutions
  • Lesson 4: Review

Module 6: Monitor and Troubleshoot Database Implementations in Azure

  • Lesson 1: Monitor and Troubleshoot SQL Server VMs on Azure
  • Lesson 2: Monitor and Troubleshoot Azure SQL Databases
  • Lesson 3: Review

Module 7: Create Microsoft Azure Data Processes using Python

  • Lesson 1: Monitor and Troubleshoot Azure SQL Databases

Need to train your team?

All of our sessions can be customized to meet your team’s specific needs. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart

Designing and Implementing Cloud Data Platform Solutions

3 Day
Classroom, Virtual

$2,095.00

Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now