PostgreSQL DBA Training in hyderabad - VLR Training Software Training institute Kukatpally -Jntu

Why PostgreSQL Database?
PostgreSQL Introduction
History of PostgreSQL Database.

PostgreSQL Database Administration (DBA) Course Catalogue

PostgreSQL Architecture

General Architecture
Memory Based Architecture
Process Based Architecture

PostgreSQL Major Features

PostgreSQL Data Types

PostgreSQL Installation Types

Source Code Installation
RPM Installation
Run installation

PostgreSQL Basic Activities

PostgreSQL Cluster initialization
DATA directory Explanation
Starting and Stopping PostgreSQL cluster Services
Automatic Startup / Shutdown
Common Issues & Troubleshooting
Installation Lab setup for PostgreSQL configuration
Host Based Authentication and Access Management
Benefits of Vacuuming
Recovering Disk Space
Updating Planner statistics
Transaction ID explanation
Transactions & concurrency Control
Routine DBA Tasks and Best Practices
Audit Log Management
Query Analysis
Monitoring and Statistics
Database Logs
OS Process Monitoring
PostgreSQL Statistics
Collector Statistics
Views
Statistics Functions
HW Configuration
Transaction Logs
Tablespaces
Partitioning
Data Import and Export

PostgreSQL Tools Overview

PG Badger
PG Pool
PG Admin
PG Bench

Backup AND Restore strategies

Logical Backup & Restore
PG_DUMP
PG_DUMPALL
PG_RESTORE
PSQL RESTORE

Physical Backup and Restore:
PG_BASEBACKUP
PG_RECIVEXLOG

PostgreSQL Maintenance Activities

VACUUM
ANALYZE
VACUUM FULL
VACUMM FREEZE
REINDEX

Database Upgrade

PostgreSQL contrib module installation
PostgreSQL database upgrade Methods
Major Upgrade
Minor Upgrade
Upgrade Roll Back

Replication Methods and usage

ostgreSQL Streaming Replication
understanding Recovery.conf
understanding Initializing Streaming Replication
Recovery Options
Standby Promotion
Cascading Replication
Replication Slots
Synchronous Replication
Replication Type Selection
Cascading Replication
Replication Slots
Synchronous Replication
Switchover Scenarios
Failover Scenarios
PostgreSQL High Availability
Failing Back Scenarios
Standby Conflicts
Standby Promotion
WAL Shipping process
Replication Overview
Replication Configuration & Setup
Replication Monitoring
pg_rewind usage
Inheritance and Partitioning
PostgreSQL self-Partitioning
PostgreSQL Trigger Based Partitioning

Performance Tuning

Operating System Level Performance Tuning
Query Level Performance Tuning
Database Level Performance Tuning
User Level Performance Tuning.
Object Level Performance Tuning

Oracle to PostgreSQL Migration

Ways of Migration
Types of Migration
Tools using for migration
Oracle to PostgreSQL Migration Demo

Register Now for PostgreSQL Database Administration (DBA) Live Demo