PostgreSQL

Course Scope

This section is a PostgreSQL course migrated into a consistent Docusaurus format. Lessons emphasize correct SQL semantics, production-safe patterns, and repeatable workflows.

Prerequisites

• A PostgreSQL instance you can run queries against (local, Docker, or a sandbox)
• Access to psql (recommended) or a SQL client that shows results clearly

How To Use This Course

Each lesson is structured the same way:

• Concept overview (what/why/where it fits)
• Syntax rules and safe patterns
• Step-by-step examples with realistic tables
• Common mistakes and troubleshooting
• Hands-on practice and quick reference

Modules

• 1. Introduction
• 2. PostgreSQL Data Types
• 3. Basic SQL Operations
• 4. Filtering and Conditions
• 5. Aggregate Functions
• 6. Joins and Unions
• 7. Grouping and Filtering
• 8. Advanced SQL Features
• 9. Database Management
• 10. Constraints and Indexes
• 11. Date and Time Functions
• 12. Views
• 13. Stored Procedures and Functions
• 14. Triggers
• 15. Scheduling and Automation
• 16. Transactions and Concurrency
• 17. User Management and Security
• 18. Performance Optimization
• 19. Backup and Recovery

Recommended Usage

Learning Order

Complete modules in numeric order, run each query locally, and test behavior under realistic data volume before applying to production.

Notes

• Examples assume modern PostgreSQL versions (features called out when version-sensitive).
• Use a dedicated practice database (for experiments) and a separate validation database (for verifying migrations and performance).

What's Next

• Start with 1. Introduction.
• Keep one practice database for experiments and one for validation.