Course curriculum

  1. 1

    • 1- Difference between IAAS vs PAAS in PostgreSQL

    • 2- 20 Questions and answers " What is PostgreSQL cloud service providers

    • Postgresql on VM or RDS

    • 20 Question and answers on postgresql.conf file

    • Bloating in postgresql

    • 25 question and answers on passwordfile in postgresql

    • Cluster Table in Postgres

    • Reindexing in postgresql

    • Vacuuming and Best Practices in PostgreSQL

    • Pgloader

    • 20 Questions and Answers on Cluster in PostgreSQL

    • tablespace in Postgres

    • 10 Question and answers on default user in postgresql

    • Postgresql.conf File and Parameters

    • 20 Questions and Answers on pg_hba.conf File and Parameters

    • PostgreSQL Architecture
  2. 2

    • 20 questions and answers for Archiving in postgreSQL

    • backup and recovery using pgbasebackup

    • Replication slot

    • short 40 Question and its answers on logical replication postgresql replication

    • 10 Question and Answers on pg_upgrade in postgresql

    • 20 interview questions and answers on upgrading postgresql via pg_dumpall

  3. 3

    • A sample postgres database adminstration skill for 4 years of experiance as a postgresql DBA
  4. 4

    • Who need to enroll for this course

  5. 5

    • performance tuning