Course Code: oragoldengate
Duration: 14 hours
Prerequisites:
  • Basic Understanding of Database Concepts: 
    • Participants should have a foundational knowledge of database systems and SQL.
  • Experience with Oracle Databases: 
    • Familiarity with Oracle Database architecture and administration.
  • Basic knowledge of PL/SQL and SQL scripting.
  • Operating System Knowledge:
    • Understanding of basic operating system commands (preferably Unix/Linux).
    • Experience with file system navigation and management.
  • Networking Basics:
    • Basic understanding of networking concepts (e.g., IP addressing, subnetting). 
Course Outline:

1. Introduction
- Overview of Oracle GoldenGate features and architecture
- Understanding Oracle GoldenGate processing methods and databases
2. Getting Started
- Setting up a practice lab
- Installing Oracle GoldenGate
- Navigating the Oracle GoldenGate user interface
3. Configuring Oracle GoldenGate
- Setting up processes and configurations
- Monitoring Oracle GoldenGate configurations
4. Setting up and Implementing Replication
- Implementing unidirectional replication
- Implementing DDL replication
- Implementing bidirectional replication
5. Filtering and Manipulating Data
- Implementing data filtration
- Transforming data in Oracle GoldGate
6. Troubleshooting
7. Summary and Next Steps