Migrating Oracle to Azure SQL or PostgreSQL Training Course

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.

This course is available as onsite live training in Ireland or online live training.

Thank you for sending your enquiry! One of our team members will contact you shortly.

Thank you for sending your booking! One of our team members will contact you shortly.

Course Outline

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

Requirements

Experience with database management systems
Familiarity with cloud computing

Audience

Database administrators
Cloud architects

7 Hours

Delivery Options

Private Group Training

Our identity is rooted in delivering exactly what our clients need.

Pre-course call with your trainer
Customisation of the learning experience to achieve your goals -

Bespoke outlines
Practical hands-on exercises containing data / scenarios recognisable to the learners

Training scheduled on a date of your choice
Delivered online, onsite/classroom or hybrid by experts sharing real world experience

Private Group Prices RRP from €2280 online delivery, based on a group of 2 delegates, €720 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.

Public Training

Please see our public courses

Need help picking the right course?

Testimonials (3)

Great comunication, Łukasz explained everything in easy and understandable way

Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.

Course - ORACLE SQL Fundamentals

the trainer was very helpful , the pace of the training was really good and the exercises weren't too hard, also not too easy. whenever I got stuck he helped me out very well and made sure I understood everything.