PostgreSQL Training and Certification

Mindmajix Technologies

Online

28 Hours

₹ 9000 11250

Quick Facts

particular	details
Medium of instructions English	Mode of learning Self study, Virtual Classroom	Mode of Delivery Video and Text Based

Course and certificate fees

Fees information

₹ 9,000 ₹11,250

certificate availability

Yes

certificate providing authority

Mindmajix Technologies

The syllabus

Module 1 - Introduction to PostgreSQL

PosgreSQL Platform
Facts about PostgreSQL
History of PostgreSQL
Major Features
General Database Limits
Common Database Object Names

Module 2 - Installation

OS User and Permissions
Installation Option
Wizard Installer
YUM/Package Installer
RPM/OFFLINE Installer
Source Code Compilation
Installation of Postgres server
Setting Environmental Variables

Module 3 - System Architecture

Process and Memory Architecture
Utility Processes
Disk Read Write Buffering
Background Writer Cleaning Scan
Commit and Checkpoint
Statement Processing
Physical Database Architecture
Data Directory Layout
Installation Directory Layout

Module 4 - Creating and Managing DB Clusters

Database Clusters
Creating a Database Cluster
Starting and Stopping the Server (pg_ctl)
Connecting to the Server Using psql

Module 5 - Configuration

Setting Server Parameters
Access Control
Connection Settings
Security and Authentication Settings
Memory Settings
Query Planner Settings
WAL Settings
Log Management
Background Writer Settings

Module 6 - Creating and Managing Databases

Object Hierarchy
Creating Databases
Users
Access Control
Creating Schemas
Schema Search Path

Module 7 - User Tools - Command Line and GUI Interfaces

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

Module 8 - Security

Authentication and Authorization
Levels of Security
pg_hba.conf File
Object Ownership
Application Access Parameters

Module 9 - SQL Primer

Data Types
Structured Query Language(SQL)
Tables and Constraints
Manipulating Data using
INSERT, UPDATE and DELETE
Creating Other Database Objects
Sequences
Views
Indexes
Domains

Module 10 - Backup, Recovery and PITR

Backup Types
Handling Large Databases
Restoring SQL Dumps
Cluster Dump
Online Directory Backups
Continuous Archiving
Backup with Low-level API
How to use pg_basebackup for Online Backups
Point-In Time Recovery Concepts

Module 11 - Table Partition

Partition types
What is declarative partitioning?
Explanation of new partitioning features
Performance problems
New partitioning performance features in PostgreSQL 12

Module 12 - Data Dictionary

The Catalog Schema
Information Tables
Information Functions
Administration Functions
Information Views

Module 13 - Data Loading

Loading flat files
Import and export data using COPY
Examples of COPY Command
Using COPY FREEZE for performance

Module 14 - Maintenance Tasks

Database Maintenance
Maintenance Tools Optimizer Statistics
Data Fragmentation
Routine Vacuuming & Vacuuming Commands
Transaction ID Wraparound
Visibility Map File
Per Table Thresholds
Reindexing & Clustering

Module 15 - Tablespace

Data Files Advantages
Changing Default Tablespace
Altering Tablespace
Dropping Tablespace

Module 16 - PostgreSQL Replication

Replication Architect
Why is replication required?
Features of replication
Replication Mode
Switchover/Switchback and Failover
Logical Replication

Module 17 - Database Upgrade

PostgreSQl Major version & minor version
Upgrade Options
Pg_Upgrade

Module 18 - Migration

Why migrate to PostgreSQL?
Migration process -overview
Migration Analysis
Migration challenges
Data Migration challenges

Module 19 - Extensions & FDW

Module 20 - Performance Tuning

Important Parameters
Basic query tuning
Query plan reading
Indexes

Module 21 - PG-pool

What is Pgpool
Pgpool Architecture
Features of Pgpool
Pgpool Example

Module 22 - Tools for PostgreSQL

Backup
Replication
High availability
Monitoring

Module 23 - Practice Test And Interview Questions

Articles

Latest Articles

5 Free Courses to Master SQL for Data Science in 2025 Updated On 07 Sep, 2025

Top 50 SQL Interview Questions and Answers (2025) Updated On 11 Jun, 2025

Top 50 SQL Server Interview Questions and Answers to Get Hired Updated On 14 Apr, 2025

How to Rename a Column Name in SQL? Updated On 20 Feb, 2024

Understanding SQL Functions and How to Write Them Updated On 14 Feb, 2024

An Introduction to Triggers in SQL Updated On 06 Feb, 2024

Comprehending DECODE In SQL Updated On 05 Feb, 2024

Understanding SQL Commands And Its Types with Examples Updated On 24 Jan, 2024

What are the Views in SQL? Types of Views in SQL Updated On 22 Jan, 2024

What Is Cursor in SQL, Understanding the Types & Syntax of SQL Cursor Updated On 22 Jan, 2024

SQL Joins: A Comprehensive Guide to SQL and SQL Join Types Updated On 10 Jan, 2024

15+ Online MySQL Courses to Pursue Updated On 24 Mar, 2021

Trending Courses

Popular Courses

General Management Courses Public Health Courses Teaching and Education Courses Financial Management Courses Web Development Courses Mathematics Courses Data Science Courses Programming Courses Cyber Security Courses Digital Marketing Courses Law Courses Mechanical Engineering Courses Explore all courses

Popular Platforms

upGrad Courses Udemy Courses Swayam Courses Edx Courses Coursera Courses NPTEL Courses Futurelearn Courses Mindmajix Technologies Courses Vskills Courses IIT Kharagpur Courses IIT Kanpur Courses Emeritus Courses Explore all platforms

Learn more about the Courses

10 Reasons to Enrol Yourself in a Digital Marketing Course 8 Must-Have Skills for AWS Cloud Architects Planning to Upskill Yourself? Enrol for a Program in Data Science 25+ Tips for Improving Your Graphic Design Skills Top Universities in India Offering Cyber Security Courses 15+ Courses for Learning Data Mining How to Make a Career in the Field of Artificial Intelligence Top 10 Benefits Of Holding A Certification In Business Intelligence Which are the best certification courses for Photography in India A Beginner's Guide to Pursue Python Programming Want to Pursue a Career in Blockchain Technology? Here is all that you need to Know How Entrepreneurs Can Use Machine Learning to Make their Business Successful? The Scope of Artificial Intelligence in India Top 10 Online Courses for Travel Lovers 10 Best Certification Courses After Hospital and Healthcare Management

Open in App

Get the Careers360 App today!

And never miss an important update

Download Careers360 App

All this at the convenience of your phone

Regular Exam Updates
Best College Recommendations
College & Rank predictors
Detailed Books and Sample Papers
Question and Answers

Popular Searches