psql basics - SkilBrill

Skip to content

Home
Courses
About
Contact
Blog
- Freshers

Search for:

Home - Lessons - PostgreSQL Training - M1 — PostgreSQL Architecture and SQL Refresher - psql basics

PostgreSQL Training psql basics

PostgreSQL Training

0% Completed

M1 — PostgreSQL Architecture and SQL Refresher

Process and memory model

WAL and checkpoints

DDL and data types

M2 — SQL Power Skills

Window functions

CTEs and recursive CTEs

JSONB and arrays

Full-text search

M3 — Indexes and Statistics

B-tree, GIN, GiST, BRIN

Partial and expression indexes

VACUUM, ANALYZE, planner stats

Index-only scans

M4 — Transactions, MVCC and Locking

Isolation levels and anomalies

Locks: row, page, advisory

Deadlocks and detection

M5 — Performance Tuning

EXPLAIN ANALYZE deep dive

pg_stat_statements

Connection pooling with PgBouncer

Memory and work_mem tuning

M6 — Partitioning and Sharding Patterns

Declarative partitioning

Partition pruning

Foreign tables and sharding

TimescaleDB extensions

M7 — Replication and High Availability

Streaming replication

Logical replication

Patroni and etcd

Failover and quorum

M8 — Backup, Restore and PITR

pgBackRest fundamentals

PITR configuration

Disaster recovery drills

Encryption and WORM

M9 — Operations and Observability

Monitoring with pgwatch / Prometheus

Alerting on replication lag

Maintenance windows

Upgrade patterns

M10 — Capstone and Certification Prep

Production HA cluster build

Performance case studies

PostgreSQL Certified Engineer mocks

Announcements Course Info

Global Trusted Software Training Partner Since 2022

SkilBrill Training Institute delivers industry-focused technology education that bridges the gap between academic learning and real-world demands. Our structured programs combine foundational theory with practical application, ensuring every graduate is confident and job-ready from day one.

Learn More About Us

© 2026 SkilBrill Training Institute. All Rights Reserved. Privacy Policy Terms Refunds Outcomes

📞 Enroll Now

Start Your Journey

Fill in your details and our team will get back to you within 24 hours

Please enable JavaScript in your browser to complete this form.

Full Name *

Email *

Course Interested In *

Mode of Course *