What you'll learn

This tutorial is designed to give details to PostgreSQL, relational database concepts, and the SQL language
Learn Syntax, Data Types, Create Database, Select Database and Drop Database
Learn Schema, details about query and clause

Requirements

Some basic knowledge on DBMS and SQL language.
No particular programming experience is required.

Description

PostgreSQL is a powerful, open source object-relational database system. This tutorial is designed to give details to PostgreSQL, relational database concepts, and the SQL language. It has been prepared for the beginners to help them understand the concepts related to PostgreSQL Database.

The training will include the following:

Overview

Environment Setup

Syntax

Data Types

Create Database

Select Database

Drop Database

CREATE TABLE IF NOT EXISTS

Drop Table

Schema

Insert Query

Select Query

Operators

Expressions

Where Clause

AND & OR Clauses

Update Query

Delete Query

Like Clause

Limit Clause

Order By Clause

Group By

With Clause

Having Clause

Distinct Keyword

Who is the target audience?

Professionals
Students