25,000+ Courses Nationwide
0345 4506120

Data Platform Upgrade and Migration - Microsoft Cloud Workshop

LEVEL: ADVANCED

In this workshop, you will gain a better understanding of how to conduct a site analysis for a customer to compare cost, performance, and level of effort required to migrate from Oracle to SQL Server. You will evaluate the dependent applications and reports that will need to be updated and come up with a migration plan. In addition, you will design and build a proof of concept (POC) and help the customer take advantage of new SQL Server features to improve performance and resiliency, as well as explore ways to migrate from an old version of SQL Server to the latest version, and consider the impact of migrating from on-premises to the cloud.

Key Features of this Data Platform Upgrade and Migration Workshop:

  • Microsoft Official Course (MOC) content

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 course outline. 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.

What is a Microsoft Cloud Workshop?

This workshop is used to supplement Microsoft Official (MOC) Azure training. These workshops are useful guides for deploying advanced Azure workloads in the Microsoft Cloud Platform.

When should I take this workshop?

The content of this workshop presumes 300-level of architectural expertise of infrastructure and solutions design. We suggest students take the following course prior to attending this workshop — Course 8529, Microsoft Azure Fundamentals Training (AZ-900T01)

Select specific date to see price, venue and full details.

Learning Objectives

You Will Learn How To:

  • Conduct a site analysis to compare cost, performance, and level of effort required to migrate from Oracle to SQL Server

Pre-Requisites

Workshop content presumes 300-level of architectural expertise of infrastructure and solutions design. We suggest students take an Azure Fundamentals course prior to attending this workshop.

 

Course Content

Module 1: Whiteboard Design Session - Data Platform Upgrade and Migration

Lessons

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

Module 2: Hands-On Lab - Data Platform Upgrade and Migration

Lessons

  • Deploy SQL Server instances
  • Migrate SQL Server to Azure SQL Database using DMS
  • Post upgrade enhancement
  • Setup Oracle 11g Express Edition
  • Migrate the Oracle database to SQL Server 2017
  • Migrate the Application

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best