> > > 40510

Microsoft Cloud Workshop: SQL Server Hybrid Cloud (40510)

 

Course Overview

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.

Who should attend

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 ‘About this Course’ and ‘At Course Completion’ 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.

Course Objectives

At the end of this workshop, 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.

Course Content

Module 1: Whiteboard Design Session - SQL Server hybrid cloud
Lessons
  • Review the customer case study
  • Design a proof of concept solution
  • Present the solution
Module 2: Hands-on Lab - SQL Server hybrid cloud
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
Classroom Training

Duration 1 day

Online Training

Duration 1 day

 
Click on town name to book Schedule
Middle East
United Arab Emirates
11/11/2019 Dubai Course language: English
24/11/2019 Online Training Time zone: Asia/Dubai Course language: English
19/01/2020 Dubai Course language: English
02/02/2020 Online Training Time zone: Asia/Dubai Course language: English
12/04/2020 Dubai Course language: English
26/04/2020 Online Training Time zone: Asia/Dubai Course language: English
12/07/2020 Dubai Course language: English
26/07/2020 Online Training Time zone: Asia/Dubai Course language: English
11/10/2020 Dubai Course language: English
25/10/2020 Online Training Time zone: Asia/Dubai Course language: English
Africa
Egypt
11/11/2019 Cairo Course language: English
24/11/2019 Online Training Time zone: Africa/Cairo Course language: English
19/01/2020 Cairo Course language: English
02/02/2020 Online Training Time zone: Africa/Cairo Course language: English
12/04/2020 Cairo Course language: English
26/04/2020 Online Training Time zone: Africa/Cairo Course language: English
12/07/2020 Cairo Course language: English
26/07/2020 Online Training Time zone: Africa/Cairo Course language: English
11/10/2020 Cairo Course language: English
25/10/2020 Online Training Time zone: Africa/Cairo Course language: English
Europe
Bulgaria
12/10/2020 FLEX training This is an English language FLEX course.
Time zone: Europe/Sofia
Croatia
23/11/2020 FLEX training This is an English language FLEX course.
Time zone: Europe/Zagreb
Czech Republic
24/08/2020 FLEX training This is an English language FLEX course.
Time zone: Europe/Prague
Hungary
16/03/2020 FLEX training This is an English language FLEX course.
Time zone: Europe/Budapest
Romania
18/05/2020 FLEX training This is an English language FLEX course.
Time zone: Europe/Bucharest
Slovakia
20/01/2020 FLEX training This is an English language FLEX course.
Time zone: Europe/Bratislava
Spain
28/10/2019 Madrid Course language: English
11/11/2019 Online Training Time zone: Europe/Madrid Course language: English
23/03/2020 Madrid Course language: English
06/04/2020 Online Training Time zone: Europe/Madrid Course language: English
15/06/2020 Madrid Course language: English
29/06/2020 Online Training Time zone: Europe/Madrid Course language: English
07/09/2020 Madrid Course language: English
21/09/2020 Online Training Time zone: Europe/Madrid Course language: English
23/11/2020 Madrid Course language: English
07/12/2020 Online Training Time zone: Europe/Madrid Course language: English
Switzerland
18/11/2019 Zurich
18/11/2019 Basel
18/11/2019 Bern
United Kingdom
09/09/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/London
14/10/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/London
11/11/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/London
09/12/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/London
This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
This is a FLEX course, which is delivered both virtually and in the classroom.