Course Description
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.
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 ‘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.
Related Courses
40585-G: Microsoft Cloud Workshop: AI-led business process automation
40585-G: Microsoft Cloud Workshop: AI-led business process automation Job role: Developer Course Description In this workshop, you will learn to automate a business process end-to-end using a variety of Azure Cognitive Services. At the end of this workshop, you will…
40578-G: Microsoft Cloud Workshop: Implementing Windows Virtual Desktop in the enterprise
40578-G: Microsoft Cloud Workshop: Implementing Windows Virtual Desktop in the enterprise Job role: Data Engineer Course Description In this workshop, you will gain experience designing solutions for Windows Virtual Desktop utilizing Microsoft 365 and Azure technologies. The following components will…
40577-G: Microsoft Cloud Workshop: Innovate and modernize apps with Data and AI
40577-G: Microsoft Cloud Workshop: Innovate and modernize apps with Data and AI Job role: Data Engineer Course Description In this workshop, you will look at the process of implementing a modern application with Azure services. The workshop will cover event…
40576-G: Microsoft Cloud Workshop: Azure Synapse Analytics and AI
40576-G: Microsoft Cloud Workshop: Azure Synapse Analytics and AI Job role: Data Engineer Course Description In this whiteboard design session, you will work in a group to look at the process of designing an end-to-end solution using Azure Synapse Analytics.…
40573-G: Microsoft Cloud Workshop: Hybrid identity
40573-G: Microsoft Cloud Workshop: Hybrid identity Job role: Data Engineer Course Description In this workshop, you will learn to setup and configure a hybrid identity solution that integrates an existing on-premises identity solution with Azure. You will learn how to…
40564-G: Microsoft Cloud Workshop: Securing the IoT end to end
40564-G: Microsoft Cloud Workshop: Securing the IoT end to end Job role: Developer Course Description In this workshop, you will look at the process for designing and implementing an oil and gas manufacturing IoT solution that is secured end-to-end following…
40562-G: Migrating SQL databases to Azure
40562-G: Migrating SQL databases to Azure Job role: Developer Course Description In this workshop, you will work as a group to setup and configure a serverless architecture within Azure using a combination of Azure Functions, Logic Apps, Event Grid, Cosmos…
40560-G: Microsoft Cloud Workshop: Predictive Maintenance for remote field devices
40560-G: Microsoft Cloud Workshop: Predictive Maintenance for remote field devices Job role: Developer Course Description In this workshop, you will learn how to evaluate Microsoft’s catalog of PaaS and SaaS-based IoT products to determine the optimal combination of tools to…
40559-G: Microsoft Cloud Workshop: MLOps
40559-G: Microsoft Cloud Workshop: MLOps Job role: Data Engineer Course Description In this workshop, you will learn how Trey Research can leverage Deep Learning technologies to scan through their vehicle specification documents to find compliance issues with new regulations, and…
40558-G: Microsoft Cloud Workshop: Line-of-business application migration
40558-G: Microsoft Cloud Workshop: Line-of-business application migration Job role: Developer Course Description In this course, you will look at how to design an Azure migration for a heterogenous customer environment. The existing infrastructure comprises both Windows and Linux servers running…
40557-G: Microsoft Cloud Workshop: Cosmos DB Real Time Advanced Analytics
40557-G: Microsoft Cloud Workshop: Cosmos DB Real Time Advanced Analytics Job role: Developer Course Description In this workshop, you will learn to design a data pipeline solution that leverages Cosmos DB for both the scalable ingest of streaming data, and…
40535-G: Microsoft Cloud Workshop: Serverless Architecture
40535-G: Microsoft Cloud Workshop: Serverless Architecture Job role: Developer Course Description In this workshop, you will work as a group to setup and configure a serverless architecture within Azure using a combination of Azure Functions, Logic Apps, Event Grid, Cosmos…
40530-G: Microsoft Cloud Workshop: Analyzing text with Azure Machine Learning and Cognitive Services
40530-G: Microsoft Cloud Workshop: Analyzing text with Azure Machine Learning and Cognitive Services Job role: Developer Course Description In this workshop, you will learn to combine both pre-built artificial intelligence (AI) (in the form of various Cognitive Services) with custom…
40522-G: Microsoft Cloud Workshop: Azure Stack
40522-G: Microsoft Cloud Workshop: Azure Stack Job role: Developer Course Description In this workshop, you will learn how to design a hybrid cloud architecture using a combination of the Azure public cloud and Azure Stack. This functional architecture will enable…
40515-G: Microsoft Cloud Workshop: Enterprise-Class Networking in Azure
40515-G: Microsoft Cloud Workshop: Enterprise-Class Networking in Azure Job role: Developer Course Description In this workshop, you will learn to setup and configure a virtual network with subnets in Azure. You will learn how to secure the virtual network by…
40514-G: Microsoft Cloud Workshop: Migrating Oracle to Azure SQL or Postgre SQL
40514-G: Microsoft Cloud Workshop: Migrating Oracle to Azure SQL or Postgre SQL Job role: Developer Course Description In this workshop, you gain a better understanding of how to conduct a site analysis for a customer to compare cost, performance, and…
40513-G: Microsoft Cloud Workshop: Building a Resilient IaaS Architecture
40513-G: Microsoft Cloud Workshop: Building a Resilient IaaS Architecture Job role: Developer Course Description In this workshop, you will look at how an existing IaaS deployment can be redesigned and updated to account for resiliency and in general high availability.…
40512-G: Microsoft Cloud Workshop: App Modernization
40512-G: Microsoft Cloud Workshop: App Modernization Job role: Developer Course Description In this workshop, you will gain a better understanding on the steps involved in modernizing legacy on-premises applications and infrastructure by leveraging cloud services, while adding a mix of…
40511-G: Microsoft Cloud Workshop: Continuous delivery in Azure DevOps
40511-G: Microsoft Cloud Workshop: Continuous delivery in Azure DevOps Job role: Developer Course Description In this whiteboard design session, you will learn how to design a solution with a combination of Azure Resource Manager templates and Azure DevOps to enable…
40508-G: Microsoft Cloud Workshop: Modern Cloud Apps
40508-G: Microsoft Cloud Workshop: Modern Cloud Apps Job role: Developer Course Description In this workshop, you will work as a group to implement an end-to-end solution for e-commerce that is based on Azure App Services, Azure Active Directory, and Visual…
40505-G: Microsoft Cloud Workshop: Internet of Things
40505-G: Microsoft Cloud Workshop: Internet of Things Job role: Developer Course Description This workshop will guide you through an implementation of an end-to-end IoT solution simulating high velocity data emitted from smart meters and analyzed in Azure. You will design…
40502-G: Microsoft Cloud Workshop: Big data analytics and visualization
40502-G: Microsoft Cloud Workshop: Big data analytics and visualization Job role: Data Engineer Course Description In this workshop, you will deploy a web app using Machine Learning (ML) to predict travel delays given flight delay data and weather conditions. Plan…
40501-G: Microsoft Cloud Workshop: Cloud-native applications
40501-G: Microsoft Cloud Workshop: Cloud-native applications Job role: Developer Course Description In this workshop, you will build a proof of concept (POC) that will transform an existing PaaS application to a container-based application. This POC will deliver a multi-tenant web…
Build An In-house Team Of Cloud Experts With Dedicated Courses!
Learn fundamental to advanced skills using Azure, Microsoft 365, and related business applications. Meet with a Microsoft Certified Training Specialist to design a custom learning plan for your organization!
