Skip to content
ictcLogo
  • About
  • Training
  • Learning Paths
  • Training Center
  • News
  • Contact
Menu
  • About
  • Training
  • Learning Paths
  • Training Center
  • News
  • Contact
Microsoft

Course 40510-G: Microsoft Cloud Workshop: SQL Server Hybrid Cloud

  • Duration: 1 days
  • Job Role: Developer

Course 40510-G: Microsoft Cloud Workshop: SQL Server Hybrid Cloud

Share This Learning Path

Need more info? Contact us

In this workshop, you will work with a media publishing company to design a hybrid cloud disaster recovery solution. You will design the solution to handle large spikes in load and harden the security to include encryption of Payment Card Industry (PCI) data. Additionally, you will implement an archival strategy to keep databases sizes in check.

Audience Profile

This workshop is intended for Cloud Architects and IT professionals who have architectural expertise of infrastructure and solutions design in cloud technologies and want to learn more about Azure and Azure services as described in the “Summary” and “Skills gained” areas. Those attending this workshop should also be experienced in other non-Microsoft cloud technologies, meet the course prerequisites, and want to cross-train on Azure.

Prerequisites

  • Knowledge of cloud computing.

Course outline

Module 1: Whiteboard Design Session - SQL Server hybrid cloud
Module Overview

In this module, you will look at how to design an application for hybrid deployment between on-premises and Microsoft Azure. You will consider how the web tier must be made available in the event of an outage as well as how to configure SQL Server Always-on Availability Groups to deploy and failover between both locations. At the end of this module, you will be better able to design a hybrid disaster recovery solution between an on-premises VMWare environment and Azure. In addition, you will design a SQL Server scale-out solution, protect database backups from local failures, archive cold data from an on-premises SQL Server, and perform end-to-end encryption on sensitive application data.

Lessons

Review the customer case study
Design a proof of concept solution
Present the solution

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Describe case study.
Design concept solution.
Describe solution.

Module 2: Hands-on Lab - SQL Server hybrid cloud
Module Overview

In this module, you will build a disaster recovery site for an on-premises environment. You will enhance the existing database solution to support a hybrid cloud-based disaster recovery solution, implement an archiving strategy and a backup/restore strategy designed to protect data. At the end of this module, you will be better able to design and use availability sets, Managed Disks, SQL Server Always on Availability Groups, Stretch DB and SQL Server Managed Backup.

Lessons

SQL Backup solution
Implement a Data Archive Strategy with SQL Server Stretch Database
Build SQL Availability Group for Database Disaster Recovery
Configure Azure Site Recovery for Web Tier DR
Failing Over to the Disaster Recovery Site

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Understand how to design a hybrid disaster recovery solution between an on-premises VMWare environment and Azure.
Understand how to design a SQL Server scale-out solution.
Understand how to protect database backups from local failures.
Understand how to archive cold data from an on-premises SQL Server.
Understand how to perform end-to-end encryption on sensitive application data.

Book Your Seat​

Find Learning Paths​

  • Search Paths

  • Vendors

Latest Learning Paths​

Microsoft

Course MS-102T00-A: Microsoft 365 Administrator

  • Microsoft 365
  • Intermediate

Microsoft

Course MD-102T00-A: Microsoft 365 Endpoint Administrator

  • Microsoft 365
  • Intermediate

Microsoft

Course AZ-800T00-A: Administering Windows Server Hybrid Core Infrastructure

  • Windows
  • Intermediate

Join our community of certified professionals

Sign Up to our newsletter, and stay always up to date with latest IT certifications

About Us

ICTC is the leader in technical certification courses and exams. Our labs consist of a latest tech PCs and our instructors are certified from each vendor

Policy for the Prevention and Combating of Violence and Harassment in the Workplace.

Facebook Linkedin

Learn

View all the provided certifications and there relevant courses. Book online for a certification exam.

Explore

Contact Us

  • +30 211 500 29 00
  • info@ictc.gr
  • Lagoumitzi 24, Kallithea
ictcLogo

International Computer Training Center

  • Copyright reserved to ICTC
  • Proudly Crafted by GTP Works

Copyright reserved to ICTC. Proudly Crafted by GTP Works

Choose how to get more info...

Give as a call

211 500 2 900

Let us, call you

Send us an email

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OkPrivacy policy