PostgreSQL Training and Certification

Mindmajix Technologies

Online

₹ 9000 11250

particular

details

                                    Medium of instructions
                                    English

                                    Mode of learning
                                    Self study, Virtual Classroom

                                    Mode of Delivery
                                    Video and Text Based

                                    Frequency of Classes
                                    Weekdays, Weekends

Introduction to PostgreSQL

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

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

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

Creating and Managing DB Clusters

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

Configuration

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

Creating and Managing Databases

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

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

Security

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

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

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

Table Partition

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

Data Dictionary

The Catalog Schema
Information Tables
Information Functions
Administration Functions
Information Views

Data Loading

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

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

Tablespace

Data Files Advantages
Changing Default Tablespace
Altering Tablespace
Dropping Tablespace

PostgreSQL Replication

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

Database Upgrade

PostgreSQl Major version & minor version
Upgrade Options
Pg_Upgrade

Migration

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

Extensions & FDW

Performance Tuning

Important Parameters
Basic query tuning
Query plan reading
Indexes

PG-pool

What is Pgpool
Pgpool Architecture
Features of Pgpool
Pgpool Example

Tools for PostgreSQL

Backup
Replication
High availability
Monitoring

Practice Test And Interview Questions

Popular Courses

Popular Platforms

Popular Searches

PostgreSQL Training and Certification

Online

₹ 9000 11250

Quick Facts

Course and certificate fees

Fees information

certificate availability

certificate providing authority

The syllabus

Introduction to PostgreSQL

Installation

System Architecture

Creating and Managing DB Clusters

Configuration

Creating and Managing Databases

User Tools - Command Line and GUI Interfaces

Security

SQL Primer

Backup, Recovery and PITR

Table Partition

Data Dictionary

Data Loading

Maintenance Tasks

Tablespace

PostgreSQL Replication

Database Upgrade

Migration

Extensions & FDW

Performance Tuning

PG-pool

Tools for PostgreSQL

Practice Test And Interview Questions

Articles

Popular Articles

Latest Articles

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Thank You!

Download Careers360 App

All this at the convenience of your phone