PostgreSQL Training course Content

PostgreSQL, the most advanced open source database, offer lots of compensation intended for the industry in excess of other database systems. It too is accessible used for almost every operating system with the latest even release. PostgreSQL support ACID (Atomicity, Consistency, Isolation, and Durability) property. our training program is usually regarded as being far extra cost-effective, convenient, and useful in the real world than that of the most important database vendor. PostgreSQL is obtainable for nearly all brand of UNIX and window compatibility. There are a lot of high-quality GUI Tools existing for PostgreSQL from equally open source developers and business providers.

PostgreSQL is recognized around the world as an incredibly powerful tool for database management. Our Postgres training courses teach practical abilities to unlock the PostgreSQL skills. The best fit for anyone working in database administration, knowledge of web technologies, & application development. Take your PostgreSQL knowledge to next level from IQ Online Training. This course will give you best practices of Installation and Creating Database, Server Administration, client Interfaces. Access to pre-recorded PostgreSQL DBA  Training Videos. Download of self-paced PostgreSQL Training course content/material prepared by industry experts.

POSTGRESQL COURSE CONTENTS
BASIC LINUX COMMANDS :

•    Linux Mostly Used Commands
•    Linux top command
•    Linux crontab
•    Linux User Management
•    Linux rsync command
•    Linux copy command
•    Linux move command
•    Linux monitoring Disk
•    Linux monitoring RAM
•    Linux SSH remote
•    Linux chmod/chown permission

BASIC POSTGRESQL:

•     PostgreSQL Brief History
•     PostgreSQL Features
•     PostgreSQL Monitoring Tools Overview
•     PostgreSQL Oracle Vs Postgresql (If have oracle Knowledge)
•     PostgreSQL Data Types

POSTGRESQL INSTALLATION AND CONFIGURATION:

•     PostgreSQL Vmware Installation
•     PostgreSQL Create Linux Virtual Machine
•     PostgreSQL Installation Types
•     PostgreSQL GUI Installation
•     PostgreSQL Text Mode Installation
•     PostgreSQL Unattended Mode Installation
•     PostgreSQL RPM installation
•     PostgreSQL installing Configuration mode
•     Other Installation mode for Reference only not for class

 POSTGRESQL DATABASE MANAGING:

•     PostgreSQL Connect Database
•     PostgreSQL Database startup/shutdown/reload/restart
•     PostgreSQL .bash_profile Set Up
•     PostgreSQL Database Creation topic -1
•     PostgreSQL Database Creation topic -2
•     PostgreSQL Connect database
•     PostgreSQL Drop Database

   POSTGRESQL SQL LANGUAGE OVERVIEW:

•     PostgreSQL SQL Languages
•     PostgreSQL Create Table
•     PostgreSQL Create table with CTAS method
•     PostgreSQL Alter Table topic-1
•     PostgreSQL Alter Table topic-2
•     PostgreSQL Drop Table
•     PostgreSQL Truncate Table
•     PostgreSQL Rename
•     PostgreSQL Comment
•     PostgreSQL Insert
•     COPY From Text File
•     COPY to Text File
•     PostgreSQL Update
•     PostgreSQL Table Delete
•     PostgreSQL Merge
•     PostgreSQL Select
•     PostgreSQL UNION
•     PostgreSQL UNION ALL
•     PostgreSQL INTERSECT
•     PostgreSQL DISTINCT

 USER/OBJECTS PRIVILEGE AND ROLES ASIGNING:

•     PostgreSQL Grant
•     PostgreSQL Revoke
•     PostgreSQL Privileges Assigning

   MVCC:

•     PostgreSQL Commit
•     PostgreSQL Rollback
•     PostgreSQL Savepoint

POSTGRESQL USER/SCHEMA MANAGEMENT:

•     PostgreSQL User Creation
•     PostgreSQL User Creation Using Utility
•     PostgreSQL Drop user
•     PostgreSQL Drop User Using Utility
•     postgreSQL User password change
•     PostgreSQL Group
•     PostgreSQL User Alter
•     PostgreSQL Schema topic-1
•     PostgreSQL Schema topic-2
•     PostgreSQL Schema topic-3

   POSTGRESQL CONSTRAINTS:

•     PostgreSQL Constraints
•     PostgreSQL Primary Key topic-1
•     PostgreSQL Primary Key topic-2
•     PostgreSQL UNIQUE Constraint topic-1
•     PostgreSQL UNIQUE Constraint topic-2
•     PostgreSQL CHECK Constraint
•     PostgreSQL NOT NULL Constraint
•     PostgreSQL Foreign Key topic-1
•     PostgreSQL Foreign Key topic-2
•     PostgreSQL Foreign Key topic-3

POSTGRESQL ADVANCE DATA TYPE:

•     PostgreSQL DOMAIN Data Type topic-1
•     PostgreSQL DOMAIN Data Type topic-2
•     PostgreSQL Alter Domain
•     PostgreSQL DOMAIN Drop
•     PostgreSQL Json Data Type
•     PostgreSQL Sequence

  POSTGRESQL VIEWS:

•     PostgreSQL View

  POSTGRESQL MONITORING OBJECT USUAGE:

•     Checking PostgreSQL Objects Size

POSTGRESQL SERVER ADMINISTRATION :

  POSTGRESQL DATABASE ARCHITECTURE :

•     PostgreSQL Tablespace
•     PostgreSQL UnderStanding Of Objects
•     PostgreSQL Architecture
•     PostgreSQL Query Flow

  POSTGRESQL BACKUP AND RECOVERY :

•     PostgreSQL Backup & Recovery Overview
•     PostgreSQL Pg_dump
•     PostgreSQL Pg_dumpall
•     PostgreSQL Pg_basebackup
•     schema migration
•     Backup Compress format
•     PostgreSQL Archive log

   POSTGRESQL POINT IN TIME RECOVERY :

•     PostgreSQL Point In Time Recovery

   PERFORMANCE TUNINIG :   

•     PostgreSQL Index
•     PostgreSQL Reindex
•     PostgreSQL Tuning
•     Tips for Tuning
•     PostgreSQL EXPLAIN PLAN
•     PostgreSQL Table partition

 ROUTINE DATABASE MAINTENANCE TASK:

•     PostgreSQL VACUUM
•     Autovacuum

  HIGH AVAILABILITY, LOAD BALANCING, AND REPLICATION

•     PostgreSQL Replication
•     PostgreSQL Switchover
•     PostgreSQL Failover

   UPGRADING POSTGRESQL :

•     PostgreSQL Upgradation

   IMPORTANT ADMIN VIEWS :

•     PostgreSQL Views
•     PostgreSQL System Catalog Views
•     PostgreSQL PG_SHADOW View
•     PostgreSQL PG_AUTHID View
•     PostgreSQL pg_stat_database
•     PostgreSQL Important DBA Commands

   TOOLS OVERVIEW :

•     PostgreSQL PgBouncer
•     PostgreSQL PgBadger
•     PostgreSQL Barman
•     PostgreSQL Repmgr
•     PostgreSQL pgadmin
•     PostgreSQL pgAgent

“We have lot of experienced candidates in PostgreSQL DBA as well as oracle, we will Give DBA support depend on Company requirements, If any Organization or individual person want to DBA support Just ping Us following mentioned contact.”