arrow_back
Oracle - PostgreSQL Migration Introduction.
About Trainer - Deepak Mahto
Introduction to PostgreSQL for Oracle Folks
PostgreSQL Introduction - Processes, Schema, Default Database and PL\pgSQL Foundation.
Intro to PostgreSQL Internals - MVCC, Vacuum and Process Architecture.
PostgreSQL Introduction - Data types overview and considerations.
PostgreSQL and it's Internals
PostgreSQL Toast Overview
Oracle PostgreSQL Cohorts - Important of Extensions with pg_stat_statements and pgbench
Oracle PostgreSQL Cohorts - Install Extensions and Key Oracle vs PostgreSQL.
How to Perform Oracle Assessment and Schema Conversion Gotchas
Oracle PostgreSQL Cohorts - Ora2pg Setup on Windows Machine.
Oracle PostgreSQL Cohorts - All Tool we need as Migration Engineer on Windows Machine.
Oracle PostgreSQL Cohorts - Key Assessment Consideration and How to Perform using Ora2pg.
AWS Schema Conversion Tool Setup and running assessment.
Oracle PostgreSQL Cohorts AWS SCT Schema Conversion - DDL
Schema Conversion Gotchas - Function based indexes, Partitioning , Functions Volatility.
Oracle PostgreSQL Cohorts - User/Schema Mapping and Deployment
Oracle PG - Cohorts - Reference Github
Understand Pl\pgSQL, and its Internals in PostgreSQL
Procedural Code internal comparision - PLSQL vs PL\pgSQL
Key Conversion Gotchas - Oracle PLSQL vs PostgreSQL PL/pgSQL
Key Conversion Gotchas - Oracle PLSQL vs PostgreSQL PL/pgSQL
Code Conversion using Ora2pg and it's must known configurations.
Advanced Code Conversion Pattern and Ora2pg Configuration
How to perform Oracle PL\SQL to PostgreSQL Conversion
Code Conversion with AWS SCT and Its Pattern and Gotchas
Code Conversion Gotchas and Key Extensions for Migration Part 1
Key Extensions and it's usage in Conversion as Migration Pattern Part 2
Code Conversion - Understanding Volatility in PL/pgSQL Functions and its Importance.
PostgreSQL - Code Conversion Challenges and Acceleration
Accelerating PL/pgSQL Code Conversation When Migrating to Postgres | POSETTE 2024
Accelerating PL/pgSQL Code Conversion When Migrating to Postgres
Code Conversion - Testing and Deployment
Importance of Code Sanity in Migration and how to Automate it.
Code Conversion - Deployment planning and approach.
Oracle PostgreSQL Cohorts - Using plpgsql_check linter tool for PL/pgSQL Code.
Must-Know PostgreSQL Extensions for Developers and DBAs During Migration
Must-Know PostgreSQL Extensions for Developers and DBAs During Migration
Must Know Postgres Extension for DBA and Developer during Migration
Migrating 1 Millions Lines of Procedural Code from Oracle to PostgreSQL
Migrating 1 million lines of code to PostgreSQL
How to perform Data Migrations from Oracle to PostgreSQL and Validation
Oracle PostgreSQL Cohorts - Data Migration Strategy
Oracle PostgreSQL Cohorts - Ora2pg Full Load - Data Migration
Oracle PostgreSQL Cohorts - Ora2pg Full Load - Performance Improvement and Configurations.
Post Data Migration Activities - Validation, Faster load of Indexes, Foreign Key
Oracle PostgreSQL Cohorts - Performance Considerations.
Partitions Management and Observability Configurations.
PostgreSQL Observability Handson.
Observability with pgbadger , pgbench and PostgreSQL Logs
PostgreSQL Memory Tuning and Bloat Optimization - work_mem/hash_mem_multipier/pgrepack
PostgreSQL - Need of Connection Poolers and PgBouncer
PostgreSQL Explain Analyze and Configurations for Oracle Folks.
PostgreSQL Tuning for Cutover and during Migration.
Oracle PostgreSQL Cohorts - Cutover
Oracle to PostgreSQL - High levels steps in Cutover
Oracle PostgreSQL Cohorts - Final Run-Through End to End
Oracle PostgreSQL Cohorts - Final Run Through - Part 1
Consolidated Script FinalRunDown-Part1
Oracle PostgreSQL Cohorts - Final Run Through - Part 2
Consolidated Script FinalRunDown-Part2