Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

PostgreSQL Training

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 Oraganization or individual person want to DBA support Just ping Us following mentioned contact."
    Name: nijamutheen J
    Mobile: +91-8838953252
    Website: www.tutorialdba.com  
    LinkedIn Profile: LinkedIn
    Skype ID: Nijamutheenjobs
    WhatsApp chat: link
    PostgreSQL Forum: https://discuss.tutorialdba.com

    Comments

    Post a Comment

    Popular posts from this blog

    How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

    Method 1 You can check the mode of the server using "pg_controldata". [pgsql@test~]$ pg_controldata /usr/local/pgsql/data84/ Database cluster state: in archive recovery --> This is Standby Database Database cluster state: in production --> This is Production Database [Master] Method 2 You can use pg_is_in_recovery() which returns True if recovery is still in progress(so the server is running in standby mode or slave) postgres=# select pg_is_in_recovery(); pg_is_in_recovery ------------------- t (1 row) If Return    false   so the server is running in primary mode or master postgres=# select pg_is_in_recovery(); pg_is_in_recovery ------------------- f (1 row)
    Read more

    7 Steps to configure BDR replication in postgresql

    Image
     The  BDR  (Bi-Directional Replication) project adds multi-master replication to PostgreSQL 9.4.  Postgres-BDR has a lower impact on the masters(s) than trigger-based replication solutions. There is no write-amplification, as it does not require triggers to write to queue tables in order to replicate writes.   Here We are using  postgres version 9.4.12 and bdr version 1.0.2. for configuring  multi master replication . Simply Following 7 steps you can configure the multi master replication in postgresql. To download the bdr in below link. .   https://github.com/2ndQuadrant/bdr/archive/bdr-pg/REL9_4_12-1.tar.gz $ tar -xzvf REL9_4_12-1.tar.gz $ wget https://github.com/2ndQuadrant/bdr/archive/bdr-plugin/1.0.2.tar.gz $ tar -xzvf 1.0.2.tar.gz 1. To install BDR. $ cd ~/bdr-bdr-pg-REL9_4_12-1 $ ./configure --prefix=/usr/lib/postgresql/9.4 --enable-debug --with-openssl $ make -j4 -s install-world $ cd ~/bdr-bdr-plugin-1.0.2 $ PATH=/usr/lib/postgresql/9.4/bin:"$PATH" ./c
    Read more

    How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

    In this post, I am sharing few important function for finding the size of database, table and index in PostgreSQL. Finding object size in postgresql database is very important and common. Is it very useful to know the exact size occupied by the object at the tablespace. The object size in the following scripts is in GB. The scripts have been formatted to work very easily with PUTTY SQL Editor. 1. Checking table size excluding table dependency: SELECT pg_size_pretty(pg_relation_size('mhrordhu_shk.mut_kharedi_audit')); pg_size_pretty ---------------- 238 MB (1 row) 2. Checking table size including table dependency: SELECT pg_size_pretty(pg_total_relation_size('mhrordhu_shk.mut_kharedi_audit')); pg_size_pretty ---------------- 268 MB (1 row) 3. Finding individual postgresql database size SELECT pg_size_pretty(pg_database_size('db_name')); 4. Finding individual table size for postgresql database -including dependency index: SELECT pg_size_pretty(pg_total_rel
    Read more

    PostgreSQL Introduction

    PostgreSQL tutorial provides basic and advanced concepts of SQL. Our PostgreSQL tutorial is designed for beginners and professionals. PostgreSQL is an opens-source object-relational database management system (ORDBMS). Our PostgreSQL tutorial includes all topics of PostgreSQL language such as create database, create table, drop database, drop table, select database, select table, insert record, update record, delete record, triggers, functions, procedures, cursors etc. There are also given PostgreSQL interview questions and quizzes to help you better understand the PostgreSQL language. Prerequisite: Before you start doing practice with various types of examples given in this reference, I'm making an assumption that you are already aware about what is database, especially RDBMS and what is a computer programming language. you must have the basic knowledge of SQL Problem: We assure that you will not find any problem in this PostgreSQL tutorial. But if there is any mistake
    Read more

    ERROR: operator does not exist: text ->> unknown LINE 1: ...stomer' as customer_name,sales_info ->>'PRODUCTS' ->>'produc... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

    postgres=# select * from sales; id | sales_info ----+---------------------------------------------------------------------------------- 1 | { "customer": "NIJAM", "PRODUCTS": {"product_name": "choclate","total_item": 6}} 2 | { "customer": "ABU", "PRODUCTS": {"product_name": "badam","total_item": 5}} 3 | { "customer": "UMAR", "PRODUCTS": {"product_name": "mobile","total_item": 1}} (3 rows) postgres=# SELECT sales_info ->>'customer' as customer_name,sales_info ->>'PRODUCTS' ->>'product_name' as name_of_product from sales where sales_info ->>'customer'='UMAR'; ERROR: operator does not exist: text ->> unknown LINE 1: ...stomer' as customer_name,sales_info -&
    Read more