Training Summary


PostgreSQL is an enterprise-class open source database management system. It supports both SQL for relational and JSON for non-relational queries. This course covers basics to advance topics like creating a database, create a table, drop the database, drop table, select table, insert a record, update record, delete a record, order by, group by, triggers, substring, database keys, etc.

What should I know?


The online guide is designed for beginners with little or no PostgreSQL Experience.

Course Syllabus

Tutorial What is PostgreSQL? Introduction, History, Features, Advantages
Tutorial How to Download and Install PostgreSQL on Windows
Tutorial PostgreSQL Data Types
Tutorial PostgreSQL CREATE DATABASE with Example
Tutorial PostgreSQL DROP DATABASE with Example
Tutorial How to Create & Drop Table in PostgreSQL [Example]
Tutorial PostgreSQL Create, Alter, Add, Drop USER
Tutorial PostgreSQL Select: Distinct, Order By, Limit
Tutorial PostgreSQL Array: Functions, Type, Example
Tutorial PostgreSQL BETWEEN with Example
Tutorial PostgreSQL IN, Not IN with Examples
Tutorial PostgreSQL LIKE, Not Like, Wildcards (%, _ ) Examples
Tutorial PostgreSQL EXISTS with Examples
Tutorial PostgreSQL DELETE Row matching 1/2 Condition, Exits Example
Tutorial PostgreSQL ALTER Table: ADD Column, Rename Column/Table Examples
Tutorial PostgreSQL SUBSTRING() with Example
Tutorial PostgreSQL Union, Union ALL with Examples
Tutorial PostgreSQL Joins: Inner, Outer, Left, Right, Natural with Examples
Tutorial PostgreSQL Create View with Example
Tutorial PostgreSQL Trigger: Create, Drop Example
Tutorial PostgreSQL vs MySQL: What's the Difference?