Brief Introduction
It has been prepared for the beginners to help them understand the concepts related to PostgreSQL DatabaseDescription
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
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
Requirements
- Requirements
- Some basic knowledge on DBMS and SQL language.
- No particular programming experience is required.