PostgreSQL DBA

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 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 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 students 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

• PostgreSQL Replication - Streaming & Logical Replication

• Deinstalling PostgreSQL Sever

• Installing PostgreSQL on Windows