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

Course NameDurationBrochureLocationScheduleEnroll
PostgreSQL Administration5 Days
img
Register

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!

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

AWS Training Partner
Google cloud
VMware Partner Logo
Redhat Partner logo
Citrix

Students Certified

0167899

Keep me Updated

Get tips, latest Courses and Offers