PostgreSQL Tutorial: Learn in 3 Days
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?