postgresql Mastry Series

Introduction to Databases

Creating a Database

Copying a Database

Renaming a Database

Dropping a Database

Backup and Restore Overview

Backing Up Databases

Restoring Databases

Introduction to PSQL

Fixing PSQL Issues

Roles and Privileges Overview

Creating Roles

Altering Roles

Dropping Roles

Understanding Current User

Granting Privileges

Revoking Privileges

Roles & Privileges Lab Exercise

Introduction to Triggers

Triggers Lab Exercise

Stored Procedures

Advanced Stored Procedures

DVD Rental Database

Practical Questions

Review Questions