PostgreSQL Training

PostgreSQL Training Overview

Download PDF

PostgreSQL is a powerful, open-source object-relational database system. 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. It is a highly extensible & reliable database & PostgreSQL runs on all major operating systems.

PostgreSQL Training Objective

  • Understand the working of relational databases
  • Installing, setup PostgreSQL, and running queries on it

PostgreSQL Training Audience

Those who wish to learn PostgreSQL Database

PostgreSQL Training Prerequisites

Basic knowledge of DATABASE and RDBMS.
If they know any programming language it would be an added advantage.

PostgreSQL Training Outline

  • What is PostgreSQL
  • PostgreSQL – Syntax
  • Data Types
  • Create Database
  • Select Database
  • Drop Database
  • Create Table
  • Drop Table
  • Schema
  • Insert Query
  • Select Query
  • Operators
  • Where Clause
  • AND & OR Clauses
  • Update Query
  • Delete Query
  • Like Clause
  • Limit Clause
  • Order By Clause
  • With Clause
  • Having Clause
  • Distinct Keyword
  • PostrgreSQL Numeric Functions
  • PostgreSQL String Functions.
  • Joins
  • Unions Clause
  • NULL Values
  • Alias Syntax
  • Triggers
  • Indexes
  • Alter Table Command
  • Truncate Table
  • Views
  • Locks
  • Sub Queries
  • Auto Increment
  • Date/Time Functions
  • Operators
  • Functions


[miniorange_social_login shape="longbuttonwithtext" theme="default" space="4" width="300" height="50" color="000000"]