PostgreSql Course Structure
Introduction
PostgreSQL System Architecture
Installation
Configuration
Creating and Managing Databases
Postgres Data Dictionary
Introduction to PSQL
pgAdmin III
Security Basics
SQL
Backup and Recovery & Point-in Time Recovery
Routine Maintenance
Moving Data
Advanced
Introduction & Architecture
Transactions and Concurrency
Performance Tuning
Replication & Failover
Table Partitioning
Connection Pooling
Monitoring
Procedural Languages
Add on Utilities – Extension