Backend Roadmap
PostgreSQL
Learning Path
Follow these concepts in order to master this topic.
1
What is PostgreSQL?2
Installing PostgreSQL3
pgAdmin4
Creating Databases5
Creating Tables6
Data Types7
Constraints8
Primary Keys9
Foregin Keys10
Relationships11
CRUD Operations12
Indexes13
Views14
Functions15
Triggers16
Transactions17
Backups & Restore18
Connecting PostgreSQL with Node.js19
Using PostgreSQL with Express20
PostgreSQL Best PracticesDocumentation
Official documentation and references.
Video Courses
Recommended free video courses.
Practice Websites
Practice what you've learned.
Projects
Apply what you've learned by building real projects.
Student Management Database
BeginnerInventory Managment System
IntermediateE-commerce Backend with PostgreSQL
Advanced