PostgreSQL is a powerful, open source Object-Relational Database Management System (ORDBMS). Its is a relational database that supports both SQL (relational) and JSON (non-relational) querying.

PostgreSQL runs on all major operating systems.

PostgreSQL has earned a strong reputation for its proven architecture, reliability, data integrity, robust feature set, extensibility, and the dedication of the open source community behind the software to consistently deliver performant and innovative solutions.

PostgreSQL comes with many features aimed to help developers build applications, administrators to protect data integrity and build fault-tolerant environments, and help you manage your data no matter how big or small the dataset.

PostgreSQL is highly scalable both in the quantity of data it can manage and in the number of concurrent users it can accommodate.

In addition to being free and open source, PostgreSQL is highly extensible. Many features, such as indexes, have defined APIs so that you can build out with PostgreSQL to solve your challenges.

It is no surprise that PostgreSQL has become the open source relational database of choice for many people and organizations.

The course provides the learner with an extensive knowledge of PostgreSQL Database Administration with real time examples.

• Introduction to PostgreSQL

• PostgreSQL Architecture

• Installation of PostgreSQL on Linux

• Using psql command-line interface

• System Catalogs and System Views

• Starting and Stopping Database Server

• Server Configuration – parameters, configuration files  

• Managing Databases – create & destroy database, template databases

• Managing Users – creating , dropping

• Managing Privileges – cluster level and object level

• Managing Schemas – creating, dropping ,public schema, search path

• Managing Tablespaces

• Backup and Recovery

• Upgrading PostgreSQL Server - Major and Minor release upgrades

• PostgreSQL Replication

• Deinstalling PostgreSQL Sever

• Installing PostgreSQL on Windows