Certificate Authentication

Introduction to PostgreSQL

• A Brief History of PostgreSQL
• Features
• Internals Summary
• Limits and Terminology

Installation and Configuration

• Pre-requisites
• Installation from Packages and Creating Database
• Installation from Source Code
• Client Installation
• Starting and Stopping a Database Server
• Environment Setup

The SQL Language

• SQL Syntax
• Data Definition
• Data Manipulation
• Queries
• Data Types
• JSON
• Functions and Operators
• Type Conversion
• Indexes

Transactions and Concurrency

• Transactions and Isolation
• Multi-Version Concurrency Control

Client Interfaces

• Command Line Interface - psql
• Graphical Interface - pgadmin4

Server Programming

• Extending SQL
• Triggers
• The Rule System
• Procedural Languages
• PL/pgSQL - SQL Procedural Language
• Error Handling
• Cursors

Foreign Data Wrappers

• Extension in PostgreSQL
• Adding FDW in a Database
• postgres_fdw
• file_fdw
• Other FDWs

SQL Tuning

• Logging in PostgreSQL
• Query Plans
• Optimizing Queries
• Statistics
• Planner Parameters
• Parallel Query Scans
• SQL Best Practices
• Indexes
• Table Partitioning

PSQL Tool

• Connecting to a Database
• Executing SQL
• psql Meta Commands

 PGAdmin4

• Connecting to a Database
• Basic Tasks using GUI

 Database Designing

• Database Users
• Creating and Managing Databases
• Schemas
• Tables
• Data Types
• Sequences
• Views
• Materialized Views

 Database Backups 

• Logical or SQL Dump Backups
• Physical Backups - Offline
• Physical Backups - Online
• Archiving

 Restoring Backups

• Restoring SQL Dumps
• Restoring Offline Backups
• Point in Time Recovery
• Partial Restore

 Proactive Maintenance 

• Database Statistics
• Data Fragmentation and Vacuuming
• Data Re-organization
• Automatic Maintenance Configuration 
• Re-indexing