3 arrows

Get a Free AWS Exam retake using promo code DOUBLESHOT

closeClose

Microsoft Cloud Workshop: Migrating Oracle to Azure SQL or Postgre SQL

  • Tuition USD $266 List Price $295
  • Reviews star_rate star_rate star_rate star_rate star_half 4749 Ratings
  • Course Code 40514
  • Duration 1 day
  • Available Formats Classroom

In this workshop, you 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 or PostgreSQL. There are two migration paths included in this workshop and the training files are named appropriately for each path. Both workshops share a common customer Oracle migration scenario. Each workshop path has tailored database platform migration steps to assist you in this learning journey. You will evaluate the dependent applications and reports that need to be updated and come up with a migration plan. Also, you will design and build a proof of concept (POC) to help the customer take advantage of new SQL Server or PostgreSQL features to improve performance and resiliency.
For those students focusing on the SQL Server migration, you will 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.

Skills Gained

At the end of this workshop, you will be better able to conduct a site analysis for compare cost, performance, and level of effort required to migrate from Oracle to SQL Server or PostgreSQL. Given the time required to complete the workshop, it is recommended the student and trainer pick a single migration path.

Who Can Benefit

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 Details

Outline


Module 1: Whiteboard Design Session - Migrating Oracle to Azure SQL or Postgre SQL
Lesson

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

Module 2: Hands-on Lab - Migrating Oracle to Azure SQL or Postgre SQL
Lab : Migrating Oracle to Azure SQL
  • Configure 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

Lab : Migrating Oracle to Postgre SQL
  • Setup Oracle 11g Express Edition
  • Assess the Oracle 11g Database before Migrating to PostgreSQL
  • Prepare to Migrate the Oracle database to PostgreSQL
  • Migrate the Database and Application

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase or can be ordered separately by clicking here.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

The tool provided to practice the course teachings is very functional and easy to use.

Excellent facilities, excellent staff.. and the coffee is good too! Thanks for helping to advance my career and the career of my colleagues!

I thought the course was informative and the tools to go over the material were very nice.

Some Labs are very good but some steps it ask to update but its already updated, but overall its very good training.

Very interactive and in-depth course that really got me ready for the industry

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward