Tags
Language
Tags
June 2025
Su Mo Tu We Th Fr Sa
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 1 2 3 4 5
    Attention❗ To save your time, in order to download anything on this site, you must be registered 👉 HERE. If you do not have a registration yet, it is better to do it right away. ✌

    ( • )( • ) ( ͡⚆ ͜ʖ ͡⚆ ) (‿ˠ‿)
    SpicyMags.xyz

    Postgresql Dba Migration From Oracle To Postgresql

    Posted By: ELK1nG
    Postgresql Dba Migration From Oracle To Postgresql

    Postgresql Dba Migration From Oracle To Postgresql
    Published 2/2024
    MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
    Language: English | Size: 592.68 MB | Duration: 1h 38m

    Certified PostgreSQL DBA Certification (CPSDBA) - Module 9

    What you'll learn

    PostgreSQL DBA Export/Import

    Migration from Oracle to PostgreSQL

    Difference between Oracle and PostgreSQL

    Data Integrity and Consistency

    Prepare the Source Environment

    AWS Migration From Oracle to SQL

    Benefits of Migration to the Cloud

    Requirements

    Basic SQL & Linux OS, Internet access is required to download PostgreSQL Server and Basic understanding of SQL language is highly recommended but not required

    Description

    Only Vendor Neutral Training & Certification course for PostgreSQL DBACOURSE FOR BEGINNERS TO EXPERT LEVEL DATABASE PROFESSIONALSPostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The origins of PostgreSQL date back to 1986 as part of the Postgres project at the University of California at Berkeley and has more than 30 years of active development on the core platform.PostgreSQLCert is a dedicated PostgreSQL Training, Certification & Services division of CertFirst (A leading Global Open Source and Security certification Training Provider). CertFirst became the first company in 2005 to launch a structured PostgreSQL Training & Certification program and has successfully provided hands-on Instructor-led training to hundreds of clients world-wide.Postgresqlcert offers vendor Neutral certification programs so the client can get to learn about all available options in the market NOT just focused on one vendor who is just trying to promote their own products and services. Postgresqlcert goal is provide the best possible non-bias training & certification possible to all its clients.Pre-Requisite:Basic SQL & Linux OSInternet access is required to download PostgreSQL ServerBasic understanding of SQL language is highly recommended but not requiredTarget Audience:Existing Oracle, MySQL or Microsoft DBA’s or new candidates interested in getting certified as a PostgreSQL DBA.Certification Exam Fee: $195 (not Included)This extensive PostgreSQL DBA training & certification program is divided in to several domains. Each video covers a specific specialized topic which will enable candidate to master each domain by learning and then applying this knowledge in the hands-on environment. Local or cloud installation will be required in order to perform all labs.The “PostgreSQL DBA Introduction and System Architecture” topic within the PostgreSQLCert program provides a  Comprehensive overview of PostgreSQL database administration and system architecture. It delves into the core responsibilities of a PostgreSQL Database Administrator (DBA), essential activities like installation, configuration, and upkeep, and offers insights into the underlying system architecture. This encompasses critical components such as storage mechanisms, memory management, and query processing. Moreover, this topic serves as a valuable preparation for thePostgreSQL DBA certification program.

    Overview

    Section 1: PostgreSQL DBA Export/Import

    Lecture 1 PostgreSQL DBA Export/Import

    Section 2: Streaming Replication

    Lecture 2 Streaming Replication

    Section 3: Migration from Oracle to PostgreSQL

    Lecture 3 Migration

    Lecture 4 What is Database Migration?

    Lecture 5 Difference between Oracle and PostgreSQL

    Lecture 6 Pre-Migration Considerations

    Lecture 7 Migration Strategies

    Lecture 8 Schema and Data Compatibility

    Lecture 9 Application Code Changes

    Lecture 10 Performance Tuning

    Lecture 11 Security and Access Control

    Lecture 12 Data Integrity and Consistency

    Lecture 13 Backup the Source Database

    Lecture 14 Prepare the Source Environment

    Lecture 15 Migrate the Database

    Lecture 16 Validate and Test

    Lecture 17 Update Application Connectivity

    Lecture 18 AWS Migration From Oracle to SQL

    Lecture 19 Benefits of Migration to the Cloud

    Lecture 20 AWS Migration Steps

    Lecture 21 Testing your Migration

    Existing Oracle, MySQL or Microsoft DBA’s or new candidates interested in getting certified as a PostgreSQL DBA.