Available Training Rooms

  • Classroom Training
    PRIVATE BATCH
  • Virtual Instructor-led Training
    PUBLIC PROGRAM
  • On Demand Training
    ON DEMAND
  • Hybrid Training
    BLENDED

Course Details

DAY ONE

Part 1: Introduction

  • History of PostgreSQL
  • Major Features
  • New Features of PostgreSQL
  • Multi Version Concurrency Control
  • Write-Ahead Logging
  • Architectural Overview
  • Limits

Part 2: PostgreSQL System Architecture

  • Architectural Summary
  • Shared Memory
  • Statement Processing
  • Utility Processes
  • Disk Read Buffering
  • Write Buffering
  • Background Writer Cleaning Scan
  • Commit & Checkpoint
  • Physical Database Architecture
  • Data Directory Layout
  • Installation Directory Layout
  • Page Layout

Part 3: Installation

  • OS User & Permissions
  • Installation
  • Setting environment variables
  • Clusters
  • Creating a database cluster
  • Starting and Stopping the Server
  • (pg_ctl)
  • Connect to the server using psql

Part 4: Database Clusters

  • Database Clusters
  • Creating a Database Cluster
  • initdb Utility
  • Starting a Database Cluster
  • Connecting to a Database Cluster
  • Reload a Database Cluster
  • Stopping a Database Cluster
  • View Cluster Control Information
  • Demo – Database Cluster

 

DAY TWO

Part 5: Configuration

  • Setting PostgreSQL Parameters
  • Access Control
  • Connection Settings
  • Security and Authentication
  • Settings
  • Memory Settings
  • Query Planner Settings
  • WAL Settings
  • Log Management
  • Background Writer Settings
  • Statement Behavior
  • Vacuum Cost Settings
  • Autovacuum Settings

Part 6: Creating and Managing Databases

  • Object Hierarchy
  • Creating Databases
  • Creating Schemas
  • Schema Search Path
  • Roles, Users & Groups
  • Access Control

Part 7: Postgres Data Dictionary

  • The System Catalog Schema
  • System Information views/tables
  • System Information Functions

 

DAY THREE

Part 8: Introduction to PSQL

  • Introduction
  • Conventions
  • Connecting to PostgreSQL
  • PSQL Command Line Parameters
  • Entering PSQL Commands
  • PSQL Meta-Commands
  • PSQL SET Parameters
  • Information Commands

Part 9: pgAdmin IV

  • Registering a server
  • Viewing and Editing Data
  • Query Tool
  • Databases
  • Languages
  • Schemas
  • Domains
  • Functions
  • Sequences
  • Tables
  • Columns
  • Constraints
  • Indexes
  • Maintenance
  • Rules
  • Triggers
  • Types
  • Views
  • Table spaces
  • Roles

Part 10: Security

  • Authentication
  • Authorization
  • Levels of security
  • pg_hba.conf file
  • Users
  • Object ownership
  • Access control
  • Application access parameters

 

DAY FOUR

Part 11: SQL

  • Data Types
  • Tables
  • SQL Queries
  • Quoting
  • Using SQL Functions
  • Constraints
  • Dropping or Removing Database
  • Objects
  • Views
  • Sequences
  • Indexes

Part 12: Backup and Recovery & Point-in Time Recovery

  • Backup Types
  • SQL Dump
  • Cluster Dump
  • Offline Copy Backup
  • Continuous Archiving
  • pg_basebackup
  • Point-In Time Recovery

Part 13: Routine Maintenance

  • Explain and Explain Analyze
  • Table Statistics
  • Updating Planner Statistics
  • Vacuuming
  • Scheduling Auto Vacuum
  • Preventing Transaction ID Wraparound Failures
  • The Visibility Map
  • Routine Reindexing

Part 14: Moving Data

  • The COPY Command
  • Examples

 

DAY FIVE

Part 15: Transactions and Concurrency

  • Transaction Definition
  • Effects of Concurrency on
  • Transactions
  • Transaction Isolation Levels
  • Multi-Version Concurrency Control
  • Overview (MVCC)
  • MVCC Example
  • Internal Identifiers
  • Transaction Wraparound
  • MVCC Maintenance
  • MVCC Demo

Part 16: Table Partitioning

  • Partitioning
  • Partitioning Methods
  • When to Partition
  • Partitioning Setup
  • Partitioning Example
  • Partitioning and Constraint Exclusion
  • Caveats
  • Lab

Part 17: Performance Tuning

  • Hardware Configuration
  • OS Configuration
  • Server Parameter Tuning
  • Connection Settings
  • Memory Parameters
  • Memory settings for Planner
  • WAL Parameters
  • Explain Plan
  • Statistics Collection
  • Indexes
  • Tips for Inserting Large Amount of Data
  • Labs

Part 18: PostgreSQL Replication

  • PostgreSQL Replication Overview
  • Types of Replications
  • Modes of Replication
  • Streaming Replication
  • Logical Replication
  • Physical Replication
  • Replication Demo on Azure

Part 18: Test

Public Program Schedule

There is no upcoming Public Batch Schedule, you can ask for Private Batch or for On-Demand Learning
Course NameDurationBrochureLocationScheduleEnroll

Download the syllabus

Download

The highest standard, The happiest learners

img

Sarada
Accenture Security-India | Training Operations

We appreciate the session conducted by Rohit Srivastava on Metaverse and Web3 Security as part of the ATCI Security Week 2022.   We received excellent feedback from the audience and look forward to many such collaborative opportunities in the future.

img

Rich Rushton
COO Layer 8 Training

Brijesh has done an excellent job. Things are a little bit slow in May – but RPS is high on our list to fill voids in our schedule. Thank you for being easy to work with!

img

Alphonsa Mathai
Learning & Knowledge Leader, IBM CIC India

I want to THANK YOU and your entire team at RPS for partnering with us during this time, Moving all the programs to a virtual environment without disrupting the learning for the Learner. We have had a successful Qtr. of delivering programs virtually.

The vast free webinars that you supported us with were very useful & relevant to the Current industry needs. Please convey our heartfelt thanks to each one of your team members for helping us out On a day to day basis and ensuring that business continuity was never impacted.
Looking forward to our continued partnership.

img

Justin Ouma
Kakirasugar

Just wanted to send my appreciation for the wonderful training you gave us in VSphere ICM in Bangalore. Your detailed elaboration gave me a new lease in VMware and with that knowledge, I now feel bold enough to do a certification exam soon. We returned to Uganda safe and moving on with our infrastructure upgrade. It was a blessing to be trained by you.

img

Jacquelene Sonia
Lead – Technical Learning Tesco PLC

A great work  for organizing AZ-900 training.
Even though appreciation words are not enough for your great work. It was flawless in all the 3 session. You take every task with utmost sincerity.  Much appreciated.

img

Ankit Sharma
Learning Operations Specialist Learning and Knowledge Team

Thanks for your support we had a successful session with 300 participants attending the same.

img

Niketa Saxena
Assistant Manager – L&D NIIT Technologies Ltd

First of all, thank you so much for supporting us and providing with the best training solutions. I have been hearing good feedback of the sessions provided by RPS during this hard time. It feels like one team with one mission of making all towards learning as it says learning is continuous process and no one can take from you. Feels good, when we see your emails with good turnaround time and making it happen for us. You take our learnings as yours and provide the best solution. Looking forward for your continuous support

img

Roshal-Maria
Thales Group

We would like to thank and appreciate you for helping us from the day one in sharing the learnings ( be it VILT or free webinars) and addressing our queries at any time during this situation. The webinars which you are sharing with us is very helpful for our employees. We wish you all the very best and hope to see the same support in future.

img

Ranjitha Raj
Systems Analyst Tesco Technology

It was a great session, we got to learn so much in the training, specially practical part was amazingly interesting. Thanks for conducting it and for choosing the right trainer.

img

Simraon Varna
Airtel

Regarding the session, the feedback received reflects that the attendees were thoroughly engaged and took away relevant learnings from the session. Really liked how Sudhanshu kept asking questions during the session & ensured attendees’ involvement.

More than 380 employees had joined in the session and there were around 30 questions in total raised by the attendees all of which were answered in detail by the speaker.

img

Jibu Kumar.J.B
Education Deployment Lead - Learning and Knowledge (L&K) IBM India

Thank you so much for all the contribution your organization is doing to ensure that the feedback is shared periodically with your trainers and constantly improving the training delivery. Continue this great work.

img

Lokesh Varshney

Training was very good .All the content were well explained with examples, well organized, relevant and useful. Exposure to industrial working culture.

Facilitator is highly knowledgeable, skilled and enthusiast. Well timed Precise to the point, Neat Delivery of Content. Expertise in subject, punctual and time management.

img

Loyson Paes
Senior Learning Partner, HR Danske IT and Support Services India Private Limited

In these times of the pandemic and in the midst of all the fears it is creating, I just wanted to put out a note for the wonderful work and coordination you are doing. Be it weekends / weekdays, you are always there to answer our calls and queries. Thanks a ton for keeping up that focus. Its indeed wonderful working with you. Do pass on my wishes to the rest of the team as well.

img

Keerthana T

Thanks to trainer Dhananjay for facilitating the Accessibility training diligently, detailed and very interactive. Trainer gave lot of space for the participants to raise their queries and answered them with enough patience. This session was great success.

img

Subhashini Rawat
Ericsson

Thank you for your contribution towards Learn to Lead! Session by Trainer Shantanu was highly engaging and interesting. Participants were very impressed by Trainer’s knowledge and confident delivery of the content. We look forward to many more similarly engaging sessions in the future!

img

Arif Ismail Bijle
IT Division Abdul Latif Jameel

Thanks for your email follow up and it was great experience working with RPS for the Virtual Training attended for Citrix Administration course. Many thanks for the necessary arrangements. Appreciating your kind support and support from instructor as well.

img

Sudhakar B
Fluentgrid Limited

We appreciate your cooperation and coordination in organising all Azure courses in smooth manner for our associates. We are really thankful to RPS Consulting for all the support extended and look forward to work with you in future.

img

Clarine Caszo
Learning and Development | HR Capgemini Technology Services India Limited

Inspite of so many last minute changes, maintaining cool and balancing between OEM and Business you made it possible to have the certification on time

img

Umapathy M R
Assistant Manager HR MFX Services

It is of great help for our employees and they are getting benefited out of all the free Webinars that you post. Really appreciate your efforts and support during this COVID period.

img

Ruchi Maithani
Ericsson

We had a very good experience with the trainer on Docker and Kubernetes training and would like to repeat a batch for some of the other members in the MANA delivery cluster with the same trainer for a 2 days curriculum this time.

Our Enterprise Clients

  • Logo - i Nautix
  • Logo - Genpact
  • Logo - Unisys
  • Logo - Fujitsu
  • Virtusa
  • Logo - Microland
  • Logo - GE
  • Logo - Intuit
  • Logo - Allstate

FAQ

Other Related Courses

    Related courses will be updated soon...

Other Certifications

Courses & Certifications
Logo - Automation Anywhere
Logo - Hitachi
Logo - Linux Foundation
RPS Siemen logo
Logo - BMC
Logo - Specialized Training
Courses & Certifications
Logo - Automation Anywhere
Logo - Hitachi
Logo - Linux Foundation
RPS Siemen logo
Logo - BMC
Logo - Specialized Training

Students Certified

0167899

Keep me Updated

Get tips, latest Courses and Offers


I can confirm that I have read the Privacy policy and accepted the terms and conditions