- Experience with database management systems
- Familiarity with cloud computing
Audience
- Database administrators
- Cloud architects
On-premise, Oracle database management systems can be costly and difficult to maintain for mid and large-scale organizations. Migrating Oracle databases to Azure SQL (also known as Microsoft Azure SQL Database, Microsoft Azure SQL or AzureSQL) or PostgreSQL (also known as Postgres or Postgre SQL) is a practical solution for growing businesses to address database management, maintenance, and scalability at an optimum cost.
This instructor-led, live training (online or onsite) is aimed at database administrators and cloud architects who wish to migrate Oracle databases to Azure SQL or PostgreSQL.
By the end of this training, participants will be able to:
- Compare Azure SQL with PostgreSQL to choose the database that best meets business objectives and needs.
- Prepare databases to move definitions, data, and procedures from Oracle to AzureSQL or PostgreSQL database system.
- Perform post-migration steps to test, optimize, update, and maintain a migrated database.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Introduction
Overview of Oracle Migration to Azure SQL or PostgreSQL
Designing a Proof of Concept Solution
Comparing Azure SQL Database With PostgreSQL Database
Configuring SQL Server Instances
Setting up Oracle Express Edition
Preparing the Database for Migration
Migrating SQL Server to Azure SQL
Deploying Post Upgrade Enhancements
Migrating Oracle Database to SQL Server 2017
Migrating the Application to Azure SQL
Migrating SQL Server to PostgreSQL
Preparing Oracle Database Migration to PostgreSQL
Migrating the Database and Application to PostgreSQL
Performing Post-Migration Tests and Optimization
Troubleshooting
Summary and Conclusion
United Arab Emirates - Migrating Oracle to Azure SQL or PostgreSQL
Qatar - Migrating Oracle to Azure SQL or PostgreSQL
Egypt - Migrating Oracle to Azure SQL or PostgreSQL
Saudi Arabia - Migrating Oracle to Azure SQL or PostgreSQL
South Africa - Migrating Oracle to Azure SQL or PostgreSQL
Brasil - Migrating Oracle to Azure SQL or PostgreSQL
Canada - Migrating Oracle to Azure SQL or PostgreSQL
中国 - Migrating Oracle to Azure SQL or PostgreSQL
香港 - Migrating Oracle to Azure SQL or PostgreSQL
澳門 - Migrating Oracle to Azure SQL or PostgreSQL
台灣 - Migrating Oracle to Azure SQL or PostgreSQL
USA - Migrating Oracle to Azure SQL or PostgreSQL
Österreich - Migrating Oracle to Azure SQL or PostgreSQL
Schweiz - Migrating Oracle to Azure SQL or PostgreSQL
Deutschland - Migrating Oracle to Azure SQL or PostgreSQL
Czech Republic - Migrating Oracle to Azure SQL or PostgreSQL
Denmark - Migrating Oracle to Azure SQL or PostgreSQL
Estonia - Migrating Oracle to Azure SQL or PostgreSQL
Finland - Migrating Oracle to Azure SQL or PostgreSQL
Greece - Migrating Oracle to Azure SQL or PostgreSQL
Magyarország - Migrating Oracle to Azure SQL or PostgreSQL
Ireland - Migrating Oracle to Azure SQL or PostgreSQL
Luxembourg - Migrating Oracle to Azure SQL or PostgreSQL
Latvia - Migrating Oracle to Azure SQL or PostgreSQL
España - Migrating Oracle to Azure SQL or PostgreSQL
Italia - Migrating Oracle to Azure SQL or PostgreSQL
Lithuania - Migrating Oracle to Azure SQL or PostgreSQL
Nederland - Migrating Oracle to Azure SQL or PostgreSQL
Norway - Migrating Oracle to Azure SQL or PostgreSQL
Portugal - Migrating Oracle to Azure SQL or PostgreSQL
România - Migrating Oracle to Azure SQL or PostgreSQL
Sverige - Migrating Oracle to Azure SQL or PostgreSQL
Türkiye - Migrating Oracle to Azure SQL or PostgreSQL
Malta - Migrating Oracle to Azure SQL or PostgreSQL
Belgique - Migrating Oracle to Azure SQL or PostgreSQL
France - Migrating Oracle to Azure SQL or PostgreSQL
日本 - Migrating Oracle to Azure SQL or PostgreSQL
Australia - Migrating Oracle to Azure SQL or PostgreSQL
Malaysia - Migrating Oracle to Azure SQL or PostgreSQL
New Zealand - Migrating Oracle to Azure SQL or PostgreSQL
Philippines - Migrating Oracle to Azure SQL or PostgreSQL
Singapore - Migrating Oracle to Azure SQL or PostgreSQL
Thailand - Migrating Oracle to Azure SQL or PostgreSQL
Vietnam - Migrating Oracle to Azure SQL or PostgreSQL
India - Migrating Oracle to Azure SQL or PostgreSQL
Argentina - Migrating Oracle to Azure SQL or PostgreSQL
Chile - Migrating Oracle to Azure SQL or PostgreSQL
Costa Rica - Migrating Oracle to Azure SQL or PostgreSQL
Ecuador - Migrating Oracle to Azure SQL or PostgreSQL
Guatemala - Migrating Oracle to Azure SQL or PostgreSQL
Colombia - Migrating Oracle to Azure SQL or PostgreSQL
México - Migrating Oracle to Azure SQL or PostgreSQL
Panama - Migrating Oracle to Azure SQL or PostgreSQL
Peru - Migrating Oracle to Azure SQL or PostgreSQL
Uruguay - Migrating Oracle to Azure SQL or PostgreSQL
Venezuela - Migrating Oracle to Azure SQL or PostgreSQL
Polska - Migrating Oracle to Azure SQL or PostgreSQL
United Kingdom - Migrating Oracle to Azure SQL or PostgreSQL
South Korea - Migrating Oracle to Azure SQL or PostgreSQL
Pakistan - Migrating Oracle to Azure SQL or PostgreSQL
Sri Lanka - Migrating Oracle to Azure SQL or PostgreSQL
Bulgaria - Migrating Oracle to Azure SQL or PostgreSQL
Bolivia - Migrating Oracle to Azure SQL or PostgreSQL
Indonesia - Migrating Oracle to Azure SQL or PostgreSQL
Kazakhstan - Migrating Oracle to Azure SQL or PostgreSQL
Moldova - Migrating Oracle to Azure SQL or PostgreSQL
Morocco - Migrating Oracle to Azure SQL or PostgreSQL
Tunisia - Migrating Oracle to Azure SQL or PostgreSQL
Kuwait - Migrating Oracle to Azure SQL or PostgreSQL
Oman - Migrating Oracle to Azure SQL or PostgreSQL
Slovakia - Migrating Oracle to Azure SQL or PostgreSQL
Kenya - Migrating Oracle to Azure SQL or PostgreSQL
Nigeria - Migrating Oracle to Azure SQL or PostgreSQL
Botswana - Migrating Oracle to Azure SQL or PostgreSQL
Slovenia - Migrating Oracle to Azure SQL or PostgreSQL
Croatia - Migrating Oracle to Azure SQL or PostgreSQL
Serbia - Migrating Oracle to Azure SQL or PostgreSQL
Bhutan - Migrating Oracle to Azure SQL or PostgreSQL