Certificate Authentication

PostgreSQL Advanced DBA Certificate for Jesica Mendoza Meza

Add to LinkedIn

Certificate ID: 
799199
Authentication Code: 
d6bc9
Certified Person Name: 
Jesica Mendoza Meza
Trainer Name: 
Christian Ortiz
Duration Days: 
2
Duration Hours: 
14
Course Name: 
PostgreSQL Advanced DBA
Course Date: 
2025-02-17 09:00 to 2025-02-18 16:00
Course Outline: 
  • Introduction
    • Architectural Overview
    • Lab Machine Setup

       
  • Performance Monitoring and Tuning
    • Monitoring Slow Queries
    • SQL Tuning
    • Table Partitioning
    • Operating System Best Practices
    • Parameter Tuning
    • Extensions
    • Benchmarking
    • Monitoring Best Practices 
    • Demos and Labs

       
  • Database Backups and Restores
    • Logical or SQL Dump Backups
    • Restoring SQL Dumps
    • Physical Backups - Offline
    • Restoring Offline Backups
    • Physical Backups - Online
    • Write Ahead Log(WAL) Archiving
    • Recovery configuration
    • Point in Time Recovery using WAL Archives

       
  • High Availability
    • Transaction Log Archiving 
    • Streaming Replication
    • Connection Pooling and HA setup using pgpool-II
    • Installation
    • Configuration
    • pgpool Setup
    • HA Setup
    • Demos and Labs

       
  • Database Security
    • Users and Groups
    • Access Control
    • Row Level Security 
    • Host Based Access Control
    • Data Encryption using pgcrypto
    • Demos and Labs

       
  • Database Upgrades
    • PostgreSQL Versioning
    • Plan for Upgrade
    • Upgrade using pg_dump
    • Upgrade using pg_upgrade
    • In Place or Not-in Place Upgrade
    • Post Upgrade Tasks