PostgreSQL

Database Software Installation:

PostgreSQL Opensource orCommunity Edition Installation in RHEL or OEL 8 and above (postgresql.org)

EDB Advanced Server (enterprisedb.com)

PostgreSQL Developer Support:

1. What is PostgreSQL? Features, Advantages and History?
2. PostgreSQL Languages
3. PostgreSQL Data types
4. PostgreSQL Constraints
5. PostgreSQL Operators
6. PostgreSQL Functions
7. PostgreSQL Set Operations
8. PostgreSQL Joins
9. PostgreSQL Sub-Query
10. PostgreSQL Sequence
11. PostgreSQL Import and Export on CSV

PostgreSQL PL/PG SQL:

1. PL/PGSQL Advantages
2. Block Structures
3. Errors and Messages
4. Variable and Datatype Declaration
5. If Condition Statements
6. Looping Structures
7. Functions
8. Functions Overloading
9. Procedures
10. Triggers
11. cursor

PostgreSQL Administration Support:

1. PostgreSQL Architecture and Components
2. PostgreSQL Memory Buffers
3. PostgreSQL Background Process
4. PostgreSQL Query Flow
5. PostgreSQL Physical Storage
6. Managing Tablespace
7. PostgreSQL Create and Accessing a Database
8. PostgreSQL Schema Management
9. PostgreSQL Pages and Tuples
10. Managing Users, Roles and Privileges
11. PostgreSQL Views and Materialized Views
12. PostgreSQL Indexes
13. PostgreSQL Vacuum Process
14. PostgreSQL Partition
15. PostgreSQL Lock Management
16. PostgreSQL Performance Tuning
17. PostgreSQL DB Link and FDW
18. PostgreSQL Physical Backup & Restore
19. PostgreSQL Logical Backup & Restore
20. PostgreSQL Base Backup & Restore
21. PostgreSQL Point in Time Recovery (PITR)
22. PostgreSQL Upgradation
23. PostgreSQL Streaming Replication
24. PostgreSQL Monitoring Queries

PostgreSQL Opensource Tools:

1. Backup and Recovery Manager(Barman) Installation, Configuration and Backup Restore Commands
2. PgBackRest Backup and recovery Tool
3. Replication Manager (Repmgr) Installation, Configuration and Commands
4. PG-POOL-II PostgreSQL Connection Pooling Tool Installation and Conigurations
5. PgBadger Reporting Tool Installation, Configuration and Commands
6. Oracle to PostgreSQL Migration Using ORA2PG Installation, Configuration and Migration Commands

PostgreSQL EnterpriseDB (EDB) Tools:

1. EDB Backup and Restore Tool (BART) Installation, Configuration and Backup Restore Commands
2. EnterpriseDB Migration Toolkit (EDB-MTK) Installation, Configuration and Commands
3. EnterpriseDB (EDB-XDB) Replication Tool Installation & Configuration