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? |