As businesses transition to open-source solutions, Oracle professionals are increasingly adopting PostgreSQL. While both databases share some similar concepts, there are key differences in the handling of core elements like schemas, tablespaces, and other structural components.

Umair Shahid, Founder of Stormatics, on November 6, 2024, gave a session on "From Oracle to Postgres: Understanding Core Differences for a Successful Transition". Umair explored the structural differences between Oracle and PostgreSQL in this session and explained how to manage these differences for optimal performance.

The webinar covered the following topics:

Schema

Tablespaces

PL/SQL vs PL/pgSQL

 Partitioning

Indexing

Concurrency control

Roles and privileges

Whether you’re in the early stages of expansion to PostgreSQL or looking to enhance your skills, this webinar will provide you with the tools you need for success.

About the Speaker

Umair Shahid

Umair, founder of Stormatics, is a 20-year veteran of the PostgreSQL community with extensive experience in solving real-world problems with technology. Being a recognized expert in PostgreSQL, he is a blogger and a regular global conference speaker. His previous experience with commercial PostgreSQL has spanned roles related to professional services and product management in major pure-play PostgreSQL organizations.