π₯ YouTube full video:
π PostgreSQL 18: Zero to Hero in 12 Hours β Complete DBA Series
Welcome to the PostgreSQL 18 Zero to Hero in 30 Days course! This series is designed for Database Administrators (DBAs), DevOps Engineers, System Administrators, Cloud Engineers, and Backend Developers who want to master PostgreSQL 18 administration from installation to high availability, backup, disaster recovery, monitoring, performance tuning, and enterprise security.
Whether you're preparing for a PostgreSQL DBA interview, managing production databases, or building your PostgreSQL administration skills, this hands-on series will guide you through real-world DBA tasks step by step.
π Course Roadmap
π΅ Week 1 β PostgreSQL Installation & Administration
0:00 β
Day 1: PostgreSQL 18 Installation on Ubuntu 24.04
9:53 β
Day 2: Remote Access Configuration (pg_hba.conf)
27:51 β
Day 3: PostgreSQL Configuration & Performance Settings
54:00 β
Day 4: Automated Backup & Restore Lab (Ubuntu & Windows Server)
1:33:25 β
Day 5: Performance Tuning Fundamentals
1:58:35 β
Day 6: PgBouncer Connection Pooling
2:17:45 β
Day 7: High Availability using Patroni & HAProxy
π’ Week 2 β Enterprise Backup & Recovery
2:42:18 β
Day 8: Backup & Restore using pgBackRest
3:05:08 β
Day 9: Remote Backup Configuration with pgBackRest
3:34:17 β
Day 10: Point-in-Time Recovery (PITR)
3:53:35 β
Day 11: Enterprise Backup using Barman
4:19:09 β
Day 12: Database Auditing with pgaudit
4:33:47 β
Day 13: Disaster Recovery Planning & Implementation
π‘ Week 3 β Replication, HA & Monitoring
5:17:24 β
Day 14: Streaming Replication Setup
5:35:45 β
Day 15: Logical Replication Configuration
5:56:42 β
Day 16: Bidirectional Replication
6:26:55 β
Day 17: repmgr Cluster & Automatic Failover
6:57:50 β
Day 18: High Availability with PgDog
7:51:54 β
Day 19: Monitoring using Prometheus & Grafana
8:17:33 β
Day 20: Monitoring using Nagios
π΄ Week 4 β Performance, Security & Migration
8:42:01 β
Day 21: Query Performance using pg_stat_statements
8:54:01 β
Day 22: PostgreSQL Log Analysis with pgBadger
9:13:42 β
Day 23: Table Partitioning Best Practices
9:36:36 β
Day 24: MySQL to PostgreSQL Migration using pgloader
9:56:32 β
Day 25: SSL Configuration for Secure Connections
10:32:02 β
Day 26: Data Encryption using pgcrypto
10:53:25 β
Day 27: Row-Level Security (RLS)
π£ Final Module
11:24:43 β
Day 28: Upgrade using pg_upgrade
11:38:46 β
Day 29: Docker + PgAdmin Setup Step-by-Step
11:55:30 β
Day 30: Kubernetes Data Recovery β οΈ Restore PV & PVC After Deletion
π― What You'll Learn
β PostgreSQL 18 Administration
β Database Installation & Configuration
β Security Best Practices
β Backup & Disaster Recovery
β Performance Tuning
β High Availability (HA)
β Replication Technologies
β Monitoring & Alerting
β Query Optimization
β PostgreSQL Upgrade & Migration
β Production DBA Best Practices
π¨βπ» This course is ideal for:
- PostgreSQL DBAs
- Database Administrators
- DevOps Engineers
- Linux Administrators
- Cloud Engineers
- Backend Developers
- Students preparing for PostgreSQL DBA roles
## β οΈ Disclaimer / ΰ€ ΰ€Έΰ₯ΰ€΅ΰ₯ΰ€ΰ€°ΰ€£
This video is created for educational & informational purposes only under Fair Use (Section 107, Copyright Act 1976). All trademarks and logos belong to their respective owners. No copyright infringement intended.
π© For copyright concerns: chiragmahto@gmail.com
π Follow:
π₯ YouTube: https://www.youtube.com/@ChiragMahtoOfficial
π· Instagram: https://www.instagram.com/chiragmahtoofficial
πΌ LinkedIn: https://www.linkedin.com/company/chirag-mahto
π Facebook: https://www.facebook.com/people/Chirag-Mahto/61592152850106/
π¬ WhatsApp Channel: https://whatsapp.com/channel/0029VbBgm16002T93KB16U12
π¬ Telegram Channel: https://t.me/chiragmahto
π Follow the process exactly as shown in the video.
π¬ Do you have any Question? Drop them in the comments box!
π₯ Donβt forget to π LIKE, π SHARE, π COMMENT, & π SUBSCRIBE to @ChiragMahtoOfficial
π« Chirag Mahto π«
π https://chiragmahto.blogspot.com
π https://chiragmahto.wordpress.com
Top comments (0)