Certificate Authentication

Bespoke - PostgreSQL Advanced (2 days) Certificate for Jhemys Alves

Add to LinkedIn

Certificate ID: 
783903
Authentication Code: 
82c09
Certified Person Name: 
Jhemys Alves
Trainer Name: 
Michał Kuna
Duration Days: 
2
Duration Hours: 
14
Course Name: 
Bespoke - PostgreSQL Advanced (2 days)
Course Date: 
22 October 2024 09:30 to 23 October 2024 16:30
Course Outline: 

 

PostgreSQL Advanced (2 days)

 

  • Introduction
    • Architectural Overview
    • Lab Machine Setup
  • Performance Monitoring and Tuning
    • Monitoring Slow Queries
    • SQL Tuning
    • Table Partitioning
    • Operating System Best Practices
    • Parameter Tuning
    • Useful Extensions
    • Benchmarking
    • Monitoring Best Practices 
    • Demos and Labs
  • Indexes & Transaction Isolation levels
    • Index types – BTREE, BRIN, GIST, GIN
    • Isolation levels and locks
  • 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
  • Replication High Availability
    • Transaction Log Archiving 
    • Binary / Streaming Replication
    • Replication parameters
    • Slony
    • Installation
    • Configuration
    • Demos and Labs
    • PgPool & Replication Manager
  • 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
    • Post Upgrade Tasks