Oracle to PostgreSQL Migration Expert.
Deepak Mahto - Your Database Guy
14 modules
English
Lifetime access
In our course our core agenda is to enable folks to understand complexity in migration, understand different phases in actions and will share my personal experience of migrating plethora of customers out of Oracle to PostgreSQL compatible offerings like RDS, Amazon Aurora , Cloud SQL and AlloyDB.
Overview
Course New Update
07-Sept-2024 - Added Ora2pg Installation on Window.
12-Sept-2024 - Added All Tool we need as Migration Engineer on Windows Machine.
10-Oct-2024 - PLpgcheck Extensions and Its usage.
Database migration to any cloud or platform is a niche skill and needs experienced professionals to drive larger scale migration for enterprise customers that involve near real time migration with minimal downtime, efficient code conversion from oracle dialect to postgresql compatible one, data migration planning and achieving similar performance as current stack post migration.
In Course our core agenda is to enable folks to understand complexity in migration, understand different phases in actions and will share my personal experience of migrating plethora of customers out of Oracle to PostgreSQL compatible offerings like RDS, Amazon Aurora , Cloud SQL and AlloyDB.
Course is recording from live session and designed to be shared as hands on that we will perform on a Mock Schema that include intentional code complexity.
What we will learn.
- Oracle Anomalies that no one will talk about in the assessment phase.
- Schema Conversion complexity and some gotchas.
- How to efficiently plan Code Conversion for customers migrating away from Oracle.
- Key difference between Oracle and PostgreSQL SQL and Procedural Block.
- Code Conversion steps and sanity how to automate.
- Data type mapping between Oracle and PostgreSQL.
- Efficient Data Migration planning and how to handle large tables with or without partitions.
- How to perform validation during and post migrations.
- Post migration activities that involves production ready instance, Monitoring and
Intended Audience.
With minimum 3 years of experience with any databases in Development, DBA or as Data Engineer.
Folks who are interested in understanding overall migrations and develop a niche on how to conduct end to end migrations.
Please contact for more information
krishnamahto10591@gmail.com
Mobile :- +91 8169415723
What you will learn
Schema and Code Migration-Best Practise
Oracle Anomalies that no one will talk about in the assessment phase. Schema Conversion complexity and some gotchas. How to efficiently plan Code Conversion for customers migrating away from Oracle.
Perform Code Coversion checks
Code Conversion steps and sanity how to automate. Data type mapping between Oracle and PostgreSQL.
Data Migration Considerations.
Efficient Data Migration planning and how to handle large tables with or without partitions.
Day 1 Operation
Handles Day 1 operation from monitoring, security , audit and performance investigations.
Modules
Introduction to PostgreSQL for Oracle Folks
3 attachments • 1 hrs
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
3 attachments • 2 hrs
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
8 attachments • 4 hrs
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
5 attachments • 3 hrs
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
4 attachments • 2 hrs
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.
Code Conversion - Testing and Deployment
3 attachments • 1 hrs
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.
Migrating 1 Millions Lines of Procedural Code from Oracle to PostgreSQL
1 attachment • 55 mins
Migrating 1 million lines of code to PostgreSQL
How to perform Data Migrations from Oracle to PostgreSQL and Validation
4 attachments • 3 hrs
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.
7 attachments • 4 hrs
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
1 attachment • 35.93 mins
Oracle to PostgreSQL - High levels steps in Cutover
Oracle PostgreSQL Cohorts - Final Run-Through End to End
4 attachments • 1 hrs
Oracle PostgreSQL Cohorts - Final Run Through - Part 1
Consolidated Script FinalRunDown-Part1
Oracle PostgreSQL Cohorts - Final Run Through - Part 2
Consolidated Script FinalRunDown-Part2
FAQs
How can I enrol in a course?
Enrolling in a course is simple! Just browse through our website, select the course you're interested in, and click on the "Enrol Now" button. Follow the prompts to complete the enrolment process, and you'll gain immediate access to the course materials.
Can I access the course materials on any device?
Yes, our platform is designed to be accessible on various devices, including computers, laptops, tablets, and smartphones. You can access the course materials anytime, anywhere, as long as you have an internet connection.
How can I access the course materials?
Once you enrol in a course, you will gain access to a dedicated online learning platform. All course materials, including video lessons, lecture notes, and supplementary resources, can be accessed conveniently through the platform at any time.
Can I interact with the instructor during the course?
Absolutely! we are committed to providing an engaging and interactive learning experience. You will have opportunities to interact with them through our community. Take full advantage to enhance your understanding and gain insights directly from the expert.
About the creator
Deepak Mahto - Your Database Guy
Founder at DataCloudGaze Consulting, a passionate expert in Databases and with experience working at Amazon and Google.
15 years of enriching professional Career, worked with 50+ Customer on databases from performance to migrations.
SME of Databases on Cloud primarily RDS, Amazon Aurora, Cloud SQL and AlloyDB.
Conducted enablement program at AWS and Google Cloud and Build Training and content on Migrations.
More info @ https://linktr.ee/mahtodeepak
Rate this Course
$ 110.00
$120
Order ID:
This course is in your library
What are you waiting for? It’s time to start learning!
Wait up!
We see you’re already enrolled in this course till Lifetime. Do you still wish to enroll again?
