Eğitim İçeriği
Introduction to Oracle GoldenGate Architecture
- GoldenGate components and process roles: Extract, Pump, Replicat, Manager, and Collector
- GoldenGate topologies: one-way, bi-directional, cascaded, and hub-and-spoke
- Overview of GoldenGate Microservices architecture and key differences from classic architecture
Installation, Configuration, and Environment Preparation
- System requirements, supported platforms, and installation steps for GoldenGate 19c
- Configuring Manager process, parameter files, and deployment directories
- Database prerequisites, user privileges, and network considerations
Change Data Capture and Data Movement
- Capture methods: Classic Extract, Integrated Extract, and Log-based CDC
- Trail file architecture, transport strategies, and checkpointing
- Configuring Extract, Data Pump, and Replicat processes
Mapping, Transformations, and Conflict Handling
- Data mapping and column transformations using parameter files and mapping rules
- Handling data type conversions and character set considerations
- Conflict detection and resolution strategies for bidirectional replication
GoldenGate Microservices and Administration UI
- Deploying and managing the GoldenGate Microservices Manager and Admin Server
- Using the GoldenGate Studio and REST APIs for administration
- Configuring security: SSL/TLS, user roles, and secure connections
Monitoring, Troubleshooting, and Performance Tuning
- Monitoring replication health, latency metrics, and performance counters
- Common error patterns, log analysis, and recovery procedures
- Tuning Extract/Replicat parameters and resource management for high throughput
Advanced Topics: High Availability, Cloud, and Migration
- Implementing high-availability and zero-downtime migration strategies with GoldenGate
- GoldenGate in cloud deployments and hybrid architectures (OCI, AWS, Azure)
- Upgrading GoldenGate, patching best practices, and migration planning
Hands-on Labs and Real-World Scenarios
- Lab: Installing GoldenGate 19c and configuring a one-way replication pipeline
- Lab: Implementing transformations and handling DML and DDL replication
- Scenario: Diagnosing replication latency and executing failover/recovery steps
Summary and Next Steps
Kurs İçin Gerekli Önbilgiler
- An understanding of relational database concepts
- Experience administering Oracle Database or equivalent RDBMS
- Familiarity with Linux/Unix or Windows server administration
Audience
- Database administrators (DBAs)
- Data replication and integration engineers
- Platform and operations engineers responsible for high-availability systems
Danışanlarımızın Yorumları (3)
Mükemmel iletişim, Łukasz her şeyi kolay ve anlaşılabilecek bir şekilde açıkladı
Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.
Eğitim - ORACLE SQL Fundamentals
Yapay Zeka Çevirisi
antrenör çok yardımcı oldu, eğitim hızı gerçekten iyiydi ve egzersizler ne kadar zor değildi, aynı zamanda ne de çok kolayydı. her defasında takıldığım zamanlar antrenör benim için çok iyi bir şekilde yardım etti ve her şeyi anladığımdan emin oldu.
Jade Stappaerts - KULeuven
Eğitim - Oracle SQL Language
Yapay Zeka Çevirisi
alıştırmalar
Amna AlAli - Federal Demographic Council
Eğitim - Oracle SQL for beginners
Yapay Zeka Çevirisi