PostgreSQL DBA Training Logo

PostgreSQL DBA Training

Live Online & Classroom Enterprise Training

Learn how to setup and manage PostgreSQL database professionally with our PostgreSQL DBA Training. Gain practical experience in basic installation to advanced activity such as replication of PostgreSQL database. Be the PostgreSQL DBA your team needs.

Looking for a private batch ?

REQUEST A CALLBACK

Need help finding the right training?

Your Message

  • Enterprise Reporting

  • Lifetime Access

  • CloudLabs

  • 24x7 Support

  • Real-time code analysis and feedback

What is PostgreSQL DBA Training about?

Master the basics of Postgres Administration from installation to creating the database, clusters and servers as you learn with our expert. Through our practical oriented PostgreSQL DBA training, be able to use sophisticated features of Postgres database such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups,the query planner/optimizer, and write ahead logging for fault tolerance.

In our Cloudlabs, practice installing PostgreSQL, configuring it, defining roles and privileges, and adding security measures. Get hands on practice on advanced databases operations from SQLDump, restore, replication of the database to migrating Oracle to Postgres DB and upgrade it. Be able to professionally optimize, monitor and maintain the Postgres DB.

Be the PostgreSQL DBA your organization wants.

What are the objectives of PostgreSQL DBA Training ?

After completing the PostgreSQL DBA Training, you will be able to:

  • Install and setup PostgreSQL
  • Create databases and database structures
  • Insert and manipulate data in a PostgreSQL database
  • Define roles, their attributes and role memberships
  • Select the encryption method and setup security for the database
  • Perform Backup and Recovery, SQL Dump, and Restore
  • Upgrade the Postgres DB
  • Migrate the Oracle DB to Postgres
  • Maintain, monitor and optimize the PostgreSQL database

 

What are the prerequisites for PostgreSQL DBA Training?

  • Mandatory
    • Understanding of SQL
    • Database concepts
  • Suggested
    • Knowledge of Linux environment

Available Training Modes

Live Online Training

Course Outline Expand All

Expand All

  • Installing PostgreSQL
  • Compiling and Installing PostgreSQL on Linux/Unix
  • Post-Installation Setup *The PostgreSQL Windows Installer
  • Creating a Database and Testing the Server
  • Initializing a Cluster
  • Creating a Database
  • Starting the Database Server
  • The psql Client
  • Startup Failures and Client Connection Problems
  • Overview of PostgreSQL Architecture
  • Configuration Files
  • Physical Storage and File Layout
  • Tablespaces
  • System Catalogs
  • Logging Parameters
  • Roles and Privileges
  • Roles and Their Attributes
  • Privileges
  • Role Membership
  • Security
  • Securing TCP Connections with SSL
  • Create Secure SSH Tunnels
  • Client Authentication
  • Encryption Options
  • Backup and Recovery
  • Overview of Backup Methods
  • Performing an SQL Dump and Restore
  • Filesystem Backup
  • Maintenance and Monitoring
  • Replication using Pgpool-II
  • Master to Slave replication
  • Master to Master replication
  • Statement based replicatio
  • Upgrading PostgreSQL.
  • Migration from Oracle to Postgres
  • Server Optimization
  • Table Partitioning
  • Installation
  • Configuration
  • Maintenance
  • Lab-6
  • Lab-7
  • Lab-8
  • Lab-9
  • Lab-10
  • Lab-11
  • Lab-12
  • Lab-13
  • Lab-14
  • Lab-15

Who is the instructor for this training?

The trainer for this PostgreSQL DBA Training has extensive experience in this domain, including years of experience training & mentoring professionals.

Reviews