PostgreSQL DBA Learning Path & Course Curriculum
⭐ 0 (0 ratings) • 0 users
Created by Anonymous
Last updated 01/1970 • English [Auto]
What you'll learn
- Managing a business successfully
- Formulating winning business strategies
- Marketing
- Purchase & Manufacturing
- Finance & Control
- Right People Management
- Right Products in Right Markets
- Sales & Distribution
- Research & Development
- Real-Life Business Strategy
Course content
12 modules • 81 lessons • 9h 39m total length
- ✅ Installation & configuration 03:28
- ✅ Directory structure & configuration 03:28
- ✅ Configuration files 03:28
- ✅ Service management 03:28
- ✅ Process architecture 03:28
- ✅ Memory structure 03:28
- ✅ Storage architecture 03:28
- ✅ WAL (Write Ahead Log) fundamentals 03:28
- ✅ User & role management 03:28
- ✅ Grant and revoke privileges 03:28
- ✅ Role inheritance 03:28
- ✅ Row level security 03:28
- ✅ Creating and dropping databases 03:28
- ✅ Schema management 03:28
- ✅ Tablespace management 03:28
- ✅ Maintenance tasks (VACCUM basics) 03:28
- ✅ Query optimization (EXPLAIN and EXPLAIN ANALYZE) 03:28
- ✅ Execution plans interpretation 03:28
- ✅ Common performance anti-patterns 03:28
- ✅ Query rewriting techniques 03:28
- ✅ Advanced index types (GIN, GLIST< BRIN, SP-GiST) 03:28
- ✅ Partial indexes 03:28
- ✅ Expression indexes 03:28
- ✅ Composite indexes 03:28
- ✅ Index maintenance 03:28
- ✅ Local backups (pg_dump, pg_dumpall) 03:28
- ✅ Physical backups (pg_basebackup) 03:28
- ✅ Continuous archiving 03:28
- ✅ Point-In-Time recovery (PITR) 03:28
- ✅ Recovery scenarios 03:28
- ✅ Testing recovery procedures 03:28
- ✅ Backup automation 03:28
- ✅ Disaster recovery planning 03:28
- ✅ SSL/TLS configuration 03:28
- ✅ Authentication methods 03:28
- ✅ Audit Logging 03:28
- ✅ Data encryption (pgcrypto) 03:28
- ✅ Connection security 03:28
- ✅ VACCUM strategies (AUTO, FULL) 03:28
- ✅ ANALYZE and statistics 03:28
- ✅ Reindexing strategies 03:28
- ✅ Bloat management 03:28
- ✅ Cron jobs/pg_cron 03:28
- ✅ Scripting with bash/psql 03:28
- ✅ Monitoring alerts setup 03:28
- ✅ Streaming replication setup 03:28
- ✅ Logical replication 03:28
- ✅ Cascade replication 03:28
- ✅ Replication slots management 03:28
- ✅ Using pg_rewind 03:28
- ✅ Manual failover procedures 03:28
- ✅ Automatic failover (Patroni) 03:28
- ✅ Witness servers 03:28
- ✅ Prometheus + Grafana setup 03:28
- ✅ pg_stat_statements configuration 03:28
- ✅ Custom metrics collection 03:28
- ✅ Alerting rules 03:28
- ✅ Wait event analysis 03:28
- ✅ Lock monitoring 03:28
- ✅ Query performance analysis 03:28
- ✅ Capacity planning 03:28
₱0 ₱0
🔥 3 days left at this price!
30-Day Money-Back Guarantee
This course includes:
- ✔ 9.5 hours on-demand video
- ✔ 64 downloadable resources
- ✔ Access on mobile and TV
- ✔ Full lifetime access
- ✔ Certificate of completion