PostgreSQL Home

Beginner-friendly notes on PostgreSQL stored procedures with practical dvdrental examples.

Contents

• PostgreSQL Sample Database
• How to Access and Use psql in Windows
• Stored Procedures in PostgreSQL (Using dvdrental)
  • Advantages of Using Stored Procedures in PostgreSQL
• Introduction to Triggers in PostgreSQL (Using dvdrental Database)

Database Management

• Create a Database
• Rename a Database
• Drop a Database

Roles and Privileges

• Create Roles
• Grand Privileges
• Revoke Privileges
• Drop Roles
• 🧪 Lab Exercise: Managing Roles in PostgreSQL

Assignments

• PostgreSQL Python
• Final Project Guidelines for Database

Presentation Topics

##

• Review Questions
• Practical Questions

See Also

• PostgreSQL Tutorial