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 PostgreSQL Create, Alter, Add, Drop USER
Tutorial How to Create & Drop Table in PostgreSQL [Example]
Tutorial PostgreSQL Select: Distinct, Order By, Limit
Tutorial PostgreSQL vs MySQL: What's the Difference?