YugabyteDB Administrator Training
Operate YugabyteDB clusters across AWS, GCP and YugabyteDB Aeon, covering YSQL, security, backup/PITR, xCluster replication, PostgreSQL migration, monitoring and IaC basics.
Book a Free Demo
Tell us which program you are interested in. We will contact you with batch details.
Skills built for real-world implementation
YugabyteDB Architecture
Learn the concepts, implementation workflow, operational checks and troubleshooting approach.
YSQL & Security
Learn the concepts, implementation workflow, operational checks and troubleshooting approach.
Backup, PITR & DR
Learn the concepts, implementation workflow, operational checks and troubleshooting approach.
Monitoring & Performance
Learn the concepts, implementation workflow, operational checks and troubleshooting approach.
PostgreSQL Migration
Learn the concepts, implementation workflow, operational checks and troubleshooting approach.
Terraform & Ansible
Learn the concepts, implementation workflow, operational checks and troubleshooting approach.
What You Will Actually Build
Create an RF=3 cluster on AWS or GCP
Guided implementation focused on practical architecture, operations and validation.
Configure TLS, users, roles and backup/PITR
Guided implementation focused on practical architecture, operations and validation.
Set up xCluster replication and observe lag
Guided implementation focused on practical architecture, operations and validation.
Migrate PostgreSQL to YugabyteDB using Voyager
Guided implementation focused on practical architecture, operations and validation.
Course modules
Expand each module to see the major topics covered.
Module 01 — YugabyteDB Foundations
- Distributed SQL vs single-node databases
- YB-Master and YB-TServer architecture
- Tablets, replicas, Raft groups and YSQL
- Sharding and replication factor
Module 02 — Installation & Cluster Creation
- Sizing and Linux preparation
- Single-node and 3-node RF=3 clusters
- AWS EC2 / EBS / security groups
- GCP Compute Engine / storage / firewall
- Cluster health UIs
Module 03 — Basic Data Placement
- Cloud, region and zone placement
- Single-region multi-zone deployment
- Leaders and read replicas
Module 04 — Working with YSQL
- ysqlsh, databases, schemas and tables
- Hash vs range sharding
- Users, roles, grants and transactions
- pg_stat_statements, pgcrypto, pgaudit and pgbouncer
Module 05 — Security Basics
- Password auth and login roles
- Client/server and node-to-node TLS
- AWS KMS / GCP KMS encryption basics
- RBAC, audit logging and firewall ports
Module 06 — Backup & Restore
- Distributed snapshots
- S3 / GCS backups
- Restore verification and PITR
- Logical backups and backup schedules
Module 07 — Replication & Basic DR
- HA vs DR
- xCluster asynchronous replication
- Replication lag and simple failover
Module 08 — Day-to-Day Operations
- Safe node restart
- Add/remove nodes
- Rolling upgrades
- yb-admin commands and logs
Module 09 — Monitoring Basics
- Prometheus metrics
- Grafana starter dashboards
- Latency, throughput, disk and replication alerts
- Slow query analysis with pg_stat_statements
Module 10 — Basic Performance Awareness
- Sharding and hotspots
- Index decisions
- EXPLAIN basics
- Connection pooling and scale up vs scale out
Module 11 — PostgreSQL Migration with Voyager
- Assessment report
- Schema export and conversion review
- Data export/import
- Cutover and post-migration checks
Module 12 — YugabyteDB Anywhere Basics
- Install YBA
- AWS/GCP providers
- Create and operate universes
- Backups, metrics and alerts
Module 13 — YugabyteDB Aeon Basics
- Sandbox and dedicated clusters
- Network allow-lists and VPC peering
- Users, backup/PITR and scaling
Module 14 — Infrastructure as Code Basics
- Terraform providers/resources/state
- Provision AWS/GCP VMs
- Aeon Terraform provider
- Ansible inventory/playbooks/roles
- Git and plan-before-apply workflow
Module 15 — Troubleshooting Basics
- Slow cluster and node-down checklists
- Under-replicated tablets and leader distribution
- Logs, full-disk handling and support bundles
Work with the real technology stack
The program is structured around technologies and operational workflows used in modern environments.
Who should join?
- Database administrators and support engineers
- Cloud, DevOps and platform engineers
- Developers moving into infrastructure or AI engineering
- Working professionals upgrading to modern enterprise technologies
Training approach
- Concept → implementation → troubleshooting
- Hands-on and production-oriented examples
- Structured curriculum with practical labs
Public DBA CENTRE reviews
Practical training and strong technical explanations with attention to real-world implementation.
UrbanPro ReviewStudents highlight hands-on learning, interview preparation and trainer support.
UrbanPro ReviewFeedback commonly mentions useful labs, technical depth and real-time examples.
UrbanPro ReviewCommon questions
Is this a hands-on course?
Yes. The program is designed around implementation, administration, troubleshooting and practical labs.
Can working professionals join?
Yes. Contact DBA CENTRE for the current schedule and delivery mode.
Can I attend a demo before enrolling?
Yes. Use the free-demo form or WhatsApp 90195 78898.
Are batch dates fixed on this page?
Batch schedules change. Please contact us for the latest date and timing.
Start YugabyteDB Administrator Training
Book a free demo and get the latest batch schedule.