Microsoft Learning Logo is a registered trademark of Microsoft. All rights reserved.

Designing and Implementing Cloud Data

Schedule

Start End Duration Location Details

Course Details

Designing and Implementing Cloud Data

Course Code: 55247

Duration: 3 days

Prerequisite: 

Before attending this course, students must have the following technical knowledge:

  • Experience working with databases
  • Experience using SQL

Course Description:

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

Course 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

Intended Audience:

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

Course Outlines:

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