Best PostgreSQL DBA Training - 100% Lab Access | AKSWAVE

Course Overview

What will you learn?

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

What are the pre-requisites for this Course?

Course Content


  • History of PostgreSQL
  • Major Features
  • PPAS Features
  • Architectural Overview
  • General Database Limits
  • Common Database Object Name
  • Architectural Summary
  • Process & Memory Architecture
  • Utility Processes
  • Connection Request-Response
  • Disk Read Buffering Disk
  • Write Buffering
  • Background Writer Cleaning Scan
  • Commit & Checkpoint
  • Statement Processing
  • Physical Database Architecture
  • Data Directory Layout
  • Installation Directory Layout
  • Page Layout
  • OS User & Permissions
  • Installation Options
  • Installation of PostgreSQL
  • StackBuilder
  • Setting Environmental Variables
  • Database Cluster
  • Creating a Database Cluster
  • Starting and Stopping the Server (pg_ctl)
  • Connect to the Server Using psql
  • Introduction to PSQL and EDB-PSQL
  • Conventions • Connecting to Database
  • PSQL Command Line Parameters
  • Entering PSQL Commands
  • PSQL Meta-Commands
  • PSQL SET Parameters
  • Information Commands
  • Setting PostgreSQL Parameters
  • Access Control
  • Connection Settings
  • Security and Authentication Settings
  • Memory Settings
  • Query Planner Settings
  • WAL Settings
  • Background Writer Settings
  • Statement Behavior
  • Configuration File Includes
  • Object Hierarchy
  • Creating Databases
  • Users • Access Control
  • Creating Schemas
  • Schema Search Path
  • Introduction to PEM Client
  • Registering a server
  • Viewing and Editing Data
  • Query Tool
  • Databases
  • Languages
  • Schemas
  • Database Objects
  • Maintenance
  • Tablespaces
  • Roles
  • Authentication and Authorization
  • Levels of Security
  • pg_hba.conf File
  • Object Ownership 
  • Application Access Parameters 
  • Protecting Against Injection Attacks with SQL/Protect 
  • Source Code Protection for Functions
  • Data Types
  • Structured Query Language (SQL)
  • Tables and Constraints 
  • Manipulating Data using INSERT,UPDATE and DELETE 
  • Creating Other Database Objects: Sequences, Views and Domains
  • Table Partitioning 
  • Partitioning
  • Partitioning Methods
  • When to Partition 
  • Partitioning Setup 
  • Partitioning Example
  • Partitioning and Constraint Exclusion
  • Caveats
  • Quoting 
  • SQL Functions
  • Concatenation
  • Nested Queries
  • Joins  
  • Materialized Views 
  • Updatable Views o Indexes
  • Backup Types
  • SQL Dump Backups 
  • SQL Dump Options 
  • Handling Large Databases
  • Restoring SQL Dumps 
  • Cluster Dump
  • Offline Backups
  • Recovering a Database using Offline
  • Online Directory Backups 
  • Continuous Archiving 
  • Backup with Low level API
  • How to use pg_basebackup for Online Backups
  • Point-In Time Recovery Concepts
  • Recovery Example 
  • Backup and Recovery Tool (BART)

  • Database Maintenance
  • Maintenance Tools 
  • Optimizer Statistics 
  • Data Fragmentation 
  • Routine Vacuuming
  • Vacuuming Commands 
  • Preventing Transaction ID Wraparound Failures
  • Vacuum Freeze
  • The Visibility Map
  • The System Catalog Schema 
  • System Information Tables
  • System Information Functions
  • System Administration Functions 
  • System Information Views
  • Oracle-like Dictionaries
  • Loading flat files
  • Import and export data using COPY
  • Examples of COPY Command 
  • Using COPY FREEZE for performance
  • Introduction to EDB*Loader for PPAS
  • Statement Processing 
  • Common Query Performance Issues
  • SQL Tuning Goals 
  • SQL Tuning Steps 
  • Identify slow queries 
  • Review the query execution plan 
  • Optimizer statistics and behavior
  • Restructure SQL statements 
  • Indexes
  • Review Final Execution Plan
  • Performance Tuning - Overview 
  • Performance Monitoring using PEM 
  • A Tuning Technique 
  • Operating System Considerations
  • Server Parameter Tuning
  • Memory Parameters 
  • Temporary File Parameters
  • WAL Parameters
  • Data Replication 
  • Data Replication in PostgreSQL
  • Sync or Async • Log-Shipping Standby Servers
  • Log-Shipping Architecture • Streaming Replication 
  • Hot Streaming Architecture • Cascading Replication 
  • Setup Replication Using Archive 
  • Setup Streaming Replication 
  • Prepare the Primary Server 
  • Synchronous Streaming Replication Setup
  • Configure Authentication 
  • Take a Full Backup of Primary Server 
  • Setting up the Standby Server 
  • Adding Cascading Replicated Standby Server 
  • Monitoring Hot Standby 
  • Recovery Control Functions
  • Connection Pooling Overview
  • pgpool-II – Features
  • Connection pooling
  • Replication 
  • Load balance
  • Limiting exceeding connections 
  • Automatic failover
  • pgpool II - Installation and Configuration
  • Configuring pcp.conf, pgpool.conf 
  • Setting up pool_hba.conf for Client Authentication (HBA)
  • Starting/Stopping pgpool-II

  • What are Extension Modules  
  • Installing Extension Modules 
  • Module Index
  • Monitoring 
  • Database Monitoring 
  • Database Statistics 
  • The Statistics Collector 
  • Database Statistic Tables
  • Operating System Process Monitoring
  • Current Sessions and Locks
  • Log Slow Running Queries
  • Disk Usage 
  • Postgres Enterprise Manager 
  • PEM – Features
  • PEM – Architecture
  • Version Change and Upgrade 
  • Need to Upgrade
  • Upgrade Plan 
  • Upgrade Using pg_upgrade
  • Upgrading Best Practices

Modes of Training

Classroom Training

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


Online Training

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


Self-pace Training

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

Program Benefits

MULTIPLE BENEFITS CLASSROOM ONLINE RECORDINGS

Live Sessions by expert trainer

  • Training by Expert & Oracle Certified Master trainer
  • Sessions by Mr. Akal Singh (OCM) with real-time examples
  • Having 18+ yrs Exp, more than 500 batches delivered

Recorded session videos

  • 28 hours of Recorded sessions

Course material

  • Course and material designed by Experts
  • Provide you Study Material
  • Step-by-step Lab Practice Guide Provided
  • Online Material for additional reading

Lab practice environment

  • Dedicated Machine for Practice
  • Certified Lab Assistance support
Help for preparing lab setup in students laptop
Guidance for oracle certification exams
100% satisfaction guaranteed

Upcoming Batches

Classroom Sessions

Not yet scheduled
Not yet scheduled
Not yet scheduled

Duration: 22 sessions

12,000/-
14,000/- save 14%

Online Sessions

01-Aug 
7:00am - 8:30am
Mon - Fri
06-Aug 
7:00am - 8:30am
Mon - Fri
10-Aug 
7:00am - 8:30am
Mon - Fri

Duration: 22 sessions

20,000/-
22,000/- save 9%

Recorded Sessions

Recorded Videos : 33
Material : Study and Lab Material
Lifetime
15,000/-
18,000/- save 17%

Our Trainers

No Records Found

Demo Video

No Records Found

Interview Questions

Lorem Ipsum is simply dummy text?

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry.

Lorem Ipsum is simply dummy text?

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry.

Lorem Ipsum is simply dummy text?

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry.

Certification Guidence

No Records Found

Read More

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 [email protected] 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

Related Courses

No Related Courses Founded

Testimonials

Recently I took Oracle Golden gate and Exadata-X6 classroom training from AKSWAVE ORACLE TRAINIGS by Mr.Akal Singh good teaching and good Lab Environment.One of the Best Institute in Hyderabad.

-Venkatesh

Oracle DBA

This institute is a very good platform to build your career. Mr Akal Singh is one of the best teacher for Oracle DBA. in this institute lab facilities is very good.it is the best institute for 12c DBA and RAC.

-Sandeep Singh

DBA

Google Ratings

4.6

Facebook Ratings

4.9

Twitter Ratings

4.8

Course Enquiry

The Secret of getting ahead is getting started.

Classroom Sessions Online Sessions Recorded Sessions