Course Overview

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.

Key Learning Areas

  • 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

Course Outline

  • Designing and Implementing Database Solutions for SQL Server and Microsoft Azure
  • Designing and Implementing Database Solutions for SQL Server and Microsoft Azure
  • Manage, Design and Implement Database Security
  • Manage, Design and Implement Database Security
  • Design for High-Availability, Disaster Recovery and Scalability
  • Monitor and Troubleshoot Database Implementations in Azure
  • Create Microsoft Azure Data Processes using Python

Who Benefits

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.

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