We are happy to advise you!
+43 1 6000 880-0     Contact

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

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
Online Training

Duration 1 day

Price (excl. tax)
  • Country: AT
    1,090.- €
  • SA Voucher: 1
    hardcoded default SA
Digital courseware
Classroom Training

Duration 1 day

Price (excl. tax)
  • Austria:
    Country: AT
    1,090.- €
  • Germany:
    Country: DE
    1,090.- €
  • Switzerland:
    Country: CH
    CHF 1,310.-
  • SA Voucher: 1
    hardcoded default SA
incl. catering
Catering includes:

  • Coffee, Tea, Juice, Water, Soft drinks
  • Pastry and Sweets
  • Bread
  • Fresh fruits
  • Lunch in a nearby restaurant

* Catering information only valid for courses delivered by iTLS.


Digital courseware
 

Schedule

Italian
Time zone Central European Summer Time (CEST)
Online Training Time zone: Central European Summer Time (CEST) Course language: Italian
Online Training Time zone: Central European Summer Time (CEST) Course language: Italian
Online Training Time zone: Central European Time (CET) Course language: Italian
Instructor-led Online Training:   This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.