Trainer

NA yrs exp

Duration

30 Days Days

Recordings

44 Hrs Hrs

Material

Reading and LAB guide

Online LAB

Server 24x7 available

Course Overview

What will you learn?


This comprehensive PostgreSQL 17 training is designed for beginners and experienced professionals alike. Whether you're new to database administration or looking to enhance your expertise, this course covers everything from fundamental PostgreSQL concepts to advanced topics like high availability, performance tuning, cloud deployments and Oracle to PostgreSQL migration using ora2pg and AWS DMS.

Who should go for this training?
The following professionals can go for this course:

  • Beginners starting their DBA journey
  • Developers looking to understand PostgreSQL administration
  • Database Administrators (DBAs) seeking advanced skills
  • Cloud & DevOps Engineers managing PostgreSQL in production

What are the pre-requisites for this Course?

  • Basic SQL Knowledge
  • Database Concepts
  • Basic Computer knowledge

Course Overview

Course Content

Expand All
  • History History  of PostgreSQL
  • Major Features
  • New Features in PostgreSQL 17
  • Multi-Version Concurrency Control (MVCC)
  • Write-Ahead Logging (WAL)
  • Architectural Overview
  • PostgreSQL Limits and Scalability Considerations
  • Architectural Summary
  • Shared Memory & Local Memory Management
  • Statement Processing (Parsing, Planning, Execution)
  • Utility Processes (Autovacuum, Checkpointer, WAL Writer, Background Writer)
  • Commit, Checkpoint & WAL Archival Process
  • Physical Database Architecture
  • Data Directory Layout & Structure
  • Installation Directory Layout
  • Page Layout and Tuple Storage
  • OS User & Permissions Setup
  • Installing PostgreSQL on Linux (Cent OS, RHEL, Ubuntu)
  • Setting Environment Variables
  • Database Cluster Concepts
  • Creating a Database Cluster (initdb)
  • Starting and Stopping the Server (pg_ctl)
  • Connecting to the Server using psql
  • Using PostgreSQL Service on Systemd-based Linux
  • Creating a Database Cluster
  • initdb Utility and Default Configurations
  • Starting, Stopping, and Restarting a Database Cluster
  • Connecting to a Database Cluster via psql and pgAdmin
  • Reloading PostgreSQL Configuration without Restart
  • Viewing Cluster Control Information
  • PostgreSQL Configuration File Overview (postgresql.conf, pg_hba.conf, pg_ident.conf)
  • Setting PostgreSQL Parameters for Performance
  • Access Control & Connection Security (pg_hba.conf)
  • Authentication Mechanisms (MD5, SCRAM-SHA-256,  Certificate Authentication)
  • Memory & Performance Tuning (shared_buffers, work_mem, maintenance_work_mem)
  • Query Planner Settings (enable_seqscan, enable_nestloop, random_page_cost)
  • WAL Settings for Durability & Replication (wal_level, checkpoint_timeout, archive_mode)
  • Log Management & Performance Monitoring
  • Background Writer Settings
  • Statement Behavior & Execution Costs
  • Autovacuum Settings for Database Health
  • PostgreSQL Object Hierarchy (Cluster → Database → Schema → Table)
  • Creating and Managing Databases
  • Understanding & Managing Schemas
  • Schema Search Path & Best Practices
  • Managing Roles, Users & Groups
  • Role-Based Access Control (RBAC) & Security Best Practices
  • Understanding System Catalog Schema (pg_catalog)
  • System Information Views & Tables (pg_stat_activity, pg_indexes, pg_tables)
  • System Information Functions for Monitoring & Debugging
  • Command-Line Conventions
  • Connecting to PostgreSQL via psql
  • Using PSQL Command-Line Parameters
  • Entering SQL & PSQL Commands
  • PSQL Meta-Commands (\l, \dt, \du, \df)
  • Configuring PSQL SET Parameters
  • Information Commands & Debugging Queries
  • Registering a Server & Connecting to PostgreSQL
  • Viewing & Editing Data with GUI Tools
  • Using the Query Tool for SQL Execution
  • Managing Databases, Schemas, Tables, Indexes, Sequences
  • Maintaining PostgreSQL Objects (Triggers, Rules, Views)
  • Managing PostgreSQL Security & User Permissions
  • Authentication vs. Authorization in PostgreSQL
  • PostgreSQL Security Layers & Best Practices
  • Managing pg_hba.conf for Secure Access
  • Users & Object Ownership
  • Role-Based Security & Privileges
  • Application-Level Security & Secure Connection Parameters
  • Understanding PostgreSQL Backup Types
  • Logical Backups (pg_dump, pg_dumpall)
  • Cluster-Wide Backup Strategies
  • Offline Copy Backup Methods
  • Continuous Archiving & WAL Archival Strategies
  • Using pg_basebackup for Physical Backups
  • Point-In-Time Recovery (PITR) Hands-On
  • Understanding EXPLAIN & EXPLAIN ANALYZE for Query Tuning
  • Table Statistics & Performance Monitoring
  • Updating Planner Statistics (ANALYZE)
  • Vacuuming & Auto Vacuum Scheduling
  • Preventing Transaction ID Wraparound Failures
  • Understanding the Visibility Map
  • Routine Reindexing & Table Optimization
  • Using the COPY Command for Bulk Data Operations
  • Real-World Data Migration Examples
  • ACID Properties in PostgreSQL
  • Understanding Transaction Isolation Levels
  • Effects of Concurrency on Transactions
  • Handling Deadlocks & Transaction Blocking
  • Types of Upgrades
  • Pre-Upgrade Considerations
  • Upgrade Methods (pg_upgrade, pg_dump and pg_restore)
  •  Performing a Major Version Upgrade
  • Handling Post-Upgrade Issues
  • Overview of High Availability in PostgreSQL
  • Understanding Replication Concepts
  • Streaming Replication (Synchronous vs. Asynchronous)
  • Logical Replication & Use Cases
  • Using Patroni for Automatic Failover
  • Pgpool-II & HAProxy for Load Balancing
  • Performance Tuning for Replication & HA
  • PostgreSQL Performance Optimization:
    • Hardware Configuration
    • OS-Level Optimization (HugePages, I/O Tuning)
    •  Server Parameter Tuning (work_mem, maintenance_work_mem)
    •  WAL Parameters & Checkpoint Tuning
    • Index Tuning & Query Performance Improvement
  • Hands-On Labs for Replication & HA
  • Introduction to AWS RDS & Aurora for PostgreSQL
  • Setting Up PostgreSQL on AWS RDS
  • Automated Backups & High Availability
  • Understanding Differences Between Oracle & PostgreSQL
  • Schema Conversion Using ora2pg
  • Migrating Data Using ora2pg & AWS DMS
  • Handling PL/SQL to PL/pgSQL Conversion
  • Best Practices & Troubleshooting Migration Issues
  • Performance Optimization After Migration
  • Live Migration Demonstration
Brochure Download

Modes of Training

Akswave_classroom

Classroom Training

Lives interactive sessions delivered in our classroom by our expert trainers with real-time scenarios.

Akswave_Online

Online Training

Learn from anywhere over internet, joining the live sessions delivered by our expert trainers.

Akswave_Selfpaced

Self-Pace Training

Learn through pre-recorded video sessions delivered by experts with your own pace and timings

For Coporate Training, We provide customized content and delivered by industry experts with complete practical demonstration, discussions and exercises based on practical use cases.

Contact Us

Our Key Highlights

Unique Benefits included in this training

  • BEST TRAINER : Having 15+ yrs exp and delivered more than 100 batches
  • QUALITY CONTENT : More content including advance features covered better in Industry
  • ONLINE LAB : Online Server access provided for doing your LAB practices
  • BEST PRICE : Affordable and best competitive price in the market
  • RECORDINGS : High-quality sessions recordings access for referring multiple times
  • REALTIME SCENARIOS : Training contains projects on Real-time Scenarios to gain more confidence
Key Benefits

Upcoming Batches

ONLINE TRAINING

This Course Includes:
  • Delivered by our experts having 6 yrs exp
  • 25 Virtual online sessions
  • Access for 38 Hrs of Recorded videos
  • Reading material and Lab activity guide
  • 50 Hrs of Lab practices
  • 100% practical-oriented classes
  • Real-time projects and certification guidance
  • Get certificate on course completion
  • Job assistance
  • Technical support thru chat and email
26-Mar

7:00am to 8:30am IST

30 Days (Mon-Fri)

01-Apr

7:00am to 8:30am IST

30 Days (Mon-Fri)

04-Apr

7:00am to 8:30am IST

30 Days (Mon-Fri)

Course Fee : ₹ 28,000/-

Discount :₹ 6,000/- (21%)

Offer Price : ₹22,000/- $254

SELF-PACED LEARNING

This Course Includes:
  • Access for 38 Hrs of Recorded videos
  • Reading material and Lab activity guide
  • 50 Hrs of Lab practices
  • Real-time projects and certification guidance
  • Technical support thru chat and email

₹15,000/-

Our Instructor

No Records Found

Demo Video

No Video Found

No Demo Video

Certification Guidence

No Records Found

Faq

Our Trainer has 8 years of working experience

Once you get registered, our back-end team will share you the details to join the session live over online portal which can be accessed through a browser.

Each of our live sessions are recorded. In case if you miss any, you can request us to share the link of that 

particular session.

For practical execution, our trainer/technical team will provide server access details to the student

Yes. We do provide the step-by-step document which you can follow and if required our technical team will assist you.

Live-Online training is where you can have live session with the trainer and clarify queries parallely.

Pre-recorded sessions are the recorded videos that will be provided to you that you can see, listen and learn anytime at ur feasible place. For doubts in the videos you can mail the trainer regarding the same.

You can contact our support team, or just drop an email to online@akswave-trainings.com with your queries.


The course material and recorded videos which are provided during the course period. You can download it anytime.

Visit our website regularly to check discount offers time to time. However, we provide discount for single participant

& special discount for 2 or more participants.

* If request for cancelation is made within 2 days of enrolment for class, 100% refunded.

* If request made after 2 days, then Refund is made after deduction of administration fee.

Live-Online training is where you can have live session with the trainer and clarify queries parallely.

Pre-recorded sessions are the recorded videos that will be provided to you that you can see, listen and learn anytime at ur feasible place. For doubts in the videos you can mail the trainer regarding the same.

Combo Offers

Pay less and learn more with our best combo courses. Avail more discount on multiple top trending technologies

Oracle 12C DBA

Enroll Now

Classroom

Oracle 12C DBA +
RAC Administration
(548 Reviews)

 22,000/-

save 8%

 24000/-
RAC Administration

Enroll Now

Classroom

RAC Administration +
12c Goldengate
(312 Reviews)

 21,000/-

save 13%

 24000/-
RAC Administration

Enroll Now

Online

RAC Administration +
Exadata X8
(130 Reviews)

 40,000/-

save 26%

 54000/-
Oracle 12C DBA

Enroll Now

Classroom

Oracle 12C DBA +
Apps DBA 12.2
(311 Reviews)

 20,000/-

save 29%

 28000/-

Related Courses

View All Courses

Testimonials

Manoj Kumar
3 years ago

I recently took Oracle RAC training from Akswave. Akal Sir is one of the best teacher for Oracle RAC. I learned lot of concepts, understood well and he cleared many of my doubts too. His explanation and presentation is better and easy to understand. About online Lab environment its good and the Co-ordinators are very helpful in clearing my doubts. I personally enjoyed and learned many new things in AKSWAVE.

Ravi Krishna
3 years ago

I have taken classes from Akswave Oracle Training and I gained excellent knowledge in Oracle DBA , Oracle RAC and APPs from there. I recommend people who wants better future in Oracle DBA, join Akswave. Lets see when the GoldenGate classroom training will start, I like to join.

Azjad Hussain
4 years ago

Akswave Oracle Training is one of the best institute in Ameerpet, comparing to other institutes in terms of Lab Infrastructure , helping nature faculties and the amazing skilled Mr Akal singh. Now waiting for cloud training to be started.

Google Ratings

4.6

Facebook Ratings

4.9

Twitter Ratings

4.8