PostgreSQL - Tironation - DBA Courses near Mumbai | Thane | Navi Mumbai

100% Placement

Expert Trainers

Practical Training

Live Projects

About PostgreSQL

Power Your Data with PostgreSQL: The Ultimate Open-Source Database Solution

PostgreSQL is a powerful open-source relational database management system (RDBMS) known for its reliability, extensibility, and adherence to SQL standards. It offers advanced features, scalability, and security, making it suitable for a wide range of applications. With a vibrant community and strong community support, PostgreSQL continues to be a popular choice for businesses and developers worldwide.

Tech Excellence Hub
Expert-Led Learning Journeys
Innovative Skills Development

Cutting-Edge Lab Facilities
Global Certification Hub
Career-Ready Training Solutions

More About Us

8070705599

Call Us For Admission

Best at feature

Why Choose Tironation

Introduction

Configuration (time require - 2 - 2:30 hours)

 Setting PostgreSQLParameters
 Access Control
 Connection Settings
 Security and Authentication
 Settings
 Memory Settings
 Query Planner Settings
 WAL Settings
 Log Management
 Background Writer Settings
 StatementBehavior
 Vacuum Cost Settings
 Autovacuum Settings

Introduction (time require - 25-30 Min)

 History of PostgreSQL
 Major Features
 New Features ofPostgreSQL
 Multi Version ConcurrencyControl
 Write-AheadLogging
 ArchitecturalOverview
 Limits

PostgreSQL System Architecture (time require - 1:00 - 1:30 hours)

 Architectural Summary
 Shared Memory
 Statement Processing
 Utility Processes
 Disk Read Buffering
 Write Buffering
 Background Writer CleaningScan
 Commit &Checkpoint
 Physical DatabaseArchitecture
 Data Directory Layout
 Installation Directory Layout
 Page Layout

Installation (time require - 1:30 Hours)

 OS User &Permissions
 Installation
 Setting environment variables
 Clusters
 Creating a database cluster
 Starting and Stopping theServer
 (pg_ctl)
 Connect to the server usingpsql
 Connect to the server using PGAdmin

Security Basics

Security Basics (time require - 30-50 Min)

 Authentication
 Authorization
 Levels ofsecurity
 pg_hba.conf file
 Users
 Object ownership
 Access control
 Application access parameters

Creating and Managing Databases,Schemas,Users,Tablespaces (time require - 30-45 Min)

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

Postgres Data Dictionary (time require - 15-20 Min)

 The System Catalog Schema
 System Informationviews/tables
 System InformationFunction

Registering a server(time require - 15-20 Min)

 Registering a server
 Query Tool
 Databases
 Schemas
 Indexes

Backup and Recovery

Performance Tuning (time require - 2 hours)

 Hardware Configuration
 OS Configuration
 Server ParameterTuning
 Connection Settings
 MemoryParameters
 Memory settings forPlanner
 WAL Parameters
 Explain Plan
 Explain Example
 Statistics Collection
 Indexes
 Examining Index Usage
 Tips for Inserting Large Amount ofData
 Some Notes About pg_dump Non-Durable Settings

Transactions and Concurrency (time require - 45 Min)

 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

Moving Data (time require - 15 Mins)

 The COPY Command
 Examples

Routine Maintenance (time require - 30 Mins)

 Explain and Explain Analyze
 Table Statistics
 Updating Planner Statistics
 Vacuuming
 Scheduling Auto Vacuum
 Preventing Transaction ID WraparoundFailures
 The Visibility Map
 Routine Reindexing

Backup and Recovery & Point-in Time Recovery (time require - 2:00 hours)

 Backup Types
 pg_dump
 pg_dumpall
 pg_restore
 Cluster Dump
 Offline Copy Backup
 Continuous Archiving
 pgbackrest
 pg_basebackup
 Point-In TimeRecovery
 BARMAN

Replication & Failover

Other Tools – All Tools and Topics covered with Practical’s

 pgbadger (time require – 30 Min)
 pgadmin (time require – 25 Min)
 pgbouncer (time require – 30 Min)
 pgpool (time require – 30 Min)
 repmgr (time require – 1 hour)
 ora2pg
 BARMAN
 pg_backrest

Different Upgrade Methods (time require - 45 Min)

 pg_dump/pg_restore
 Upgrading PostgreSQL Database
 Migration from Oracle to Postgres

Table Partitioning (time require - 45 Min)

 Partitioning
 Partitioning Methods
 When to Partition
 Partitioning Setup
 Partitioning Example
 Partitioning and Constraint
 Exclusion
 Caveats

Replication & Failover (time require - 3 hours)

 Database High Availability
 Causes of Data Loss
 Plan for Common Errors
 Selection Criteria
 High AvailabilityOptions
 Hot Streaming Replication, Architecture and Setup
 Streaming Replication Example
 repmgr Installation and Configuration
 Switchover Using repmgr
 Promote using repmgr
 Automatic Failover using repmgrd
 Troubleshooting ReplicationLag