Course outline

Designing and Implementing Cloud Data Platform Solutions (M55247)

Categories: Guaranteed To Run™, Microsoft

msp-logo

Duration: 3 Days

This 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.

  • 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
  • Experience working with databases
  • Experience using SQL 

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

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

  • 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

Module 2: Manage, Design and Implement Database Security

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

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

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

Module 4: Monitor and Troubleshoot Database Implementations in Azure

  • Monitor and Troubleshoot SQL Server VMs on Azure
  • Monitor and Troubleshoot Azure SQL Databases
  • 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

Lab 2: Manage, Design and Implement Database Security

  • Implement SQL Server database security
  • Implement Azure SQL Database security

Lab 3: Create Microsoft Azure Data Objects using Python

  • Implement a High-Availability Solution
  • Implement a Disaster Recovery Solution
  • Implement a Scalability Solution

Lab 4: Create Microsoft Azure Data Processes using Python

  • Monitor and Troubleshoot SQL Server
  • Monitor and Troubleshoot Azure SQL Databases

Feel free to contact us, if you want to know the price and location of this course. A Digital Revolver representative will contact you shortly to help you with your inquiry.
Please fill out the form below

  • Guaranteed to Run™. This ensures you will attend the instructor led class or live online class you want as scheduled without any disruptive cancellations*. You book the training you need, get back to focusing on your job and are sure your training requirements will be met saving time, money and ensuring peace of mind.
  • This schedule icon the schedule indicates that this date/time will be conducted as Instructor Led Training (ILT) or a Virtual Instructor Led Training (VILT) depending on the indicated class availablity.
Privacy and Cookies

This website stores cookies on your computer which help us make the website work better for you.

Learn moreAccept and Close
Social media & sharing icons powered by UltimatelySocial