PostgreSQL MOC

Database Installation and connection

• Install PostgreSQL on WSL 2 (Ubuntu)
• Connect PostgreSQL on WSL 2 (Ubuntu)
• PostgreSQL Database

Table

• PostgreSQL Table
• PostgreSQL Primary Key and Foreign Key
• PostgreSQL Constraints
• PostgreSQL Sequence and UUID

Data Manipulation

• PostgreSQL Insert and Import
• PostgreSQL Select
• PostgreSQL Update
• PostgreSQL Delete
• PostgreSQL Conflict
• PostgreSQL Join

References

• Learn PostgreSQL Tutorial - Full Course for Beginners (youtube.com)