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