Programme 10 of 14 · Databases

PostgreSQL - Database Mastery

641 words3 min read

Master PostgreSQL from developer to DBA to data engineer: query optimization, administration, performance tuning, replication, and the extension ecosystem that makes Postgres the default open-source database.

PostgreSQLpsqlReplicationPostGISPythonAirflow
PostgreSQL - Database Mastery: the syllabus at a glance1PostgreSQLfoundations2Performance andoptimization3Administration4Extensions andengineeringProject
Curriculum · 20 chapters in 4 modules

The full syllabus

Four modules of five chapters each, sequenced so the material builds cumulatively. The brochure carries a note on what each chapter teaches.

M1 PostgreSQL foundations Ch 1-5 · 5 chapters
  1. The PostgreSQL architecture
  2. Data types and the type system
  3. SQL in PostgreSQL
  4. Transactions and MVCC
  5. Schemas, roles, and permissions
M2 Performance and optimization Ch 6-10 · 5 chapters
  1. Indexing strategies
  2. Query planning and EXPLAIN
  3. Query optimization
  4. Vacuum, bloat, and maintenance
  5. Partitioning large tables
M3 Administration Ch 11-15 · 5 chapters
  1. Configuration and tuning
  2. Backup and recovery
  3. Replication and high availability
  4. Monitoring and diagnostics
  5. Security and hardening
M4 Extensions and engineering Ch 16-20 · 5 chapters
  1. The extension ecosystem
  2. PostGIS and specialized workloads
  3. Integration with Python and Airflow
  4. PostgreSQL in data pipelines
  5. The PostgreSQL capstone
Where PostgreSQL - Database Mastery can leadThis programmeopens roles inDatabase EngineerPostgreSQL DBAData EngineerBackend Engineertoward Principal Cloud & Data Platforms
FAQ

Frequently asked questions

What is the PostgreSQL - Database Mastery programme?

Master PostgreSQL from developer to DBA to data engineer: query optimization, administration, performance tuning, replication, and the extension ecosystem that makes Postgres the default open-source database.

Who is this programme for?

It suits developers building on PostgreSQL, along with others described on this page.

How is it delivered?

Self-paced with hands-on labs across developer, DBA, and data-engineering tracks.

Is there a project or capstone?

Take a PostgreSQL database from developer to production-grade: design and index a real schema, optimize its heaviest queries with EXPLAIN, configure replication and backups for high availability, and integrate it into a data pipeline, documenting the tuning throughout.

How does this fit the wider journey?

PostgreSQL opens the databases stage. As the default open-source database it appears in almost every stack, and its optimization and administration skills transfer to the other databases and underpin the whole senior data-platform skill set.

Can my organization run this as a private cohort?

Yes. Every programme can be delivered as a tailored corporate cohort. Contact us to scope it.

How it is delivered

Three ways to take PostgreSQL Database Mastery

Self-paced is a document-and-media programme with lifetime access - no live sessions. Cohort and enterprise add live instructor-led training. Mentorship is not offered in any tier.
Feature Self-paced Cohort Enterprise
Format Written chapters, video explainers and podcasts Everything in self-paced, plus scheduled live sessions Everything in cohort, delivered privately to your team
Live sessions None Scheduled, instructor-led Scheduled, instructor-led, private
Mentorship Not offered Not offered Not offered
Access Lifetime Lifetime Lifetime for every enrolled seat
Pace Entirely your own Guided schedule with a peer group Agreed with your desk
Tailoring Fixed curriculum Fixed curriculum Sequenced to your markets, systems and governance
Best for Individuals learning around a job Individuals who want structure and deadlines Desks building the same capability together
For individuals

Get the programme guide

The full chapter list, what each module covers, and how the tiers compare - sent to your inbox as a PDF.

For teams

Run this for my desk

Private delivery for your desk, sequenced to your markets and systems. Tell us the team and we will scope it.

Run this for my desk