PostgreSQL in Depth
Signature Course No. 570 — A Signature AI Socratic Coaching Course.
No experience needed — your coach starts where you are.
A New Kind of Learning
Socratic coaching, delivered by an agentic AI coach.
Not a course you watch. An AI coach you work with.
The Lighthouse Coach begins by discovering how you think about the subject, teaches what is missing, and gives you realistic practice before asking you to prove that you can use it. You may test out of concepts you already understand, while capstones turn the learning into a practical plan, decision, conversation, or other real-world result.
The curriculum is deliberately authored; the AI delivers it through coaching. It is not an AI randomly generating lessons.
A coach that teaches by asking — not by lecturing
The Lighthouse Coach is an AI Socratic coach built on Cognosco Learning's PostgreSQL in Depth course, in the Personal Effectiveness & Well-Being category. It does not play videos at you. It holds a conversation: it asks you a question, listens to your answer, names the misconception it hears, affirms what you got right, and asks the next question — the way a great coach works in the room.
The statements are the weather; the platform is the building. PostgreSQL is two things that share a name: a language you write statements in, and a running system — processes, memory, files, logs, replicas — that must stay up, stay fast enough, and never lose what it promised to keep while those statements fly through it. This course owns the second thing: how the server is configured, how it uses memory and disk, how it protects every committed change, and how it is copied, backed up, restored, upgraded, and watched.
It runs on one stipulated case. A regional care network's scheduling, visit, and billing applications all write to one PostgreSQL 16 cluster on a single server: 32 GB of memory, a data volume with 400 GB usable, a database of 240 GB growing by a net 5 GB a month, and a largest table — the visit-record table — of 80 GB. The inherited settings are shared_buffers at 8 GB, max_connections at 200, and work_mem at 16 MB; the write-ahead log runs at 1.5 GB an hour on average, 36 GB a day, rising to 3 GB an hour at the morning peak; and a full base backup measures 60 GB after compression.
It starts in the machine room. The platform, not the language — what the server does when no query is running; configuration kept as a decision record; memory and connections budgeted together; storage and its growth; the WAL and checkpoint rhythm that makes durability affordable; vacuum, the standing obligation the concurrency design creates; indexes charged as rent; the planner's statistical picture kept current; and the platform's own evidence, read honestly.
It works in two movements. First, Module 1 — The Machine Room: How the Platform Behaves — work through Concepts 1–9, finishing with The Platform Baseline and Health Plan; then, Module 2 — The Long Watch: Protecting, Changing, and Keeping the Platform — work through Concepts 10–18, finishing with The Recovery, Replication, and Upgrade Plan.
Both capstones produce real artifacts — a platform baseline and health plan for a real cluster: the stipulated facts audited against the platform's own evidence, the budgets computed in full, the rhythms assessed, and the findings turned into dated, owned actions; and a recovery, replication, and upgrade plan that could be handed to a manager and defended line by line: the objectives stated in numbers, the machinery chosen and priced against them, and the year of obligations that keeps it all true.
The honesty standard is part of the course. This is a practice book: it prepares no examination, names no credential, and claims no certification. Its standard is simpler and harder — after this course, the platform in your care should be measurably better run: its settings decided rather than inherited, its backups proven rather than assumed, its growth forecast rather than discovered — and you should be able to show the arithmetic and the evidence behind every one of those claims. The body of the course teaches against PostgreSQL 16; anything that changes between versions is fenced to the book's Appendix, to be confirmed at the source before you rely on it.
The course is self-paced and always on — roughly 30 minutes per concept, about 9 hours in full, taken in as many sittings as you like. You can type your answers, or talk out loud: the Voice Coach speaks its questions and listens to your spoken replies. Learners who already know the material can test out concept by concept.
PostgreSQL in Depth is part of The Lighthouse Signature Series — the online counterpart to the one-day, in-person learning Cognosco Learning delivers.
Course Facts
One full concept, coached end to end — free: verify your email and we’ll send you a link to start.
Already enrolled? Enter the course →
Diagnose → Learn & Practice → Prove → Capstone
Every learner moves through the same discipline a Cognosco instructor would insist on in the room.
Diagnose
The Coach starts where the course starts: with the platform itself. Could you say right now — without checking — which standing processes exist on the PostgreSQL service you know best, what shared_buffers is set to, and whether anything other than answering statements has run in the last day? Was the last database problem you met found in a statement's wording, or in a shared resource — memory, disk, locks, a background process behind schedule? And if your server lost power tonight, what would happen, process by process, between the restart and the moment the service accepts work again? Every concept opens with three questions that locate where you actually stand, and your answers shape how deeply the Coach works the concept with you. Everyone begins with Module 1 — no skipping the foundations you only think you have.
Learn & Practice
Work each concept in conversation with the Coach — spoken or written — then practice it against realistic situations until it holds up.
Prove
Every concept ends in proof: answer the check cold and demonstrate the skill. Know it already? Test out and take credit immediately.
Capstone
Finish with two capstones — The Platform Baseline and Health Plan for Module 1 and The Recovery, Replication, and Upgrade Plan for Module 2 — that pull the whole course together, and earn the certificate.
What You'll Learn
You operate the system statements pass through. When the platform misbehaves, the untrained response is to stare at the statements — the weather. The trained response is to ask which building system is complaining: a shared resource under strain, a standing process behind schedule, a rhythm skipped. This course teaches the building.
Module 1 takes the running platform apart. What the server does between statements; how its settings are layered, changed, and ledgered; how memory and connections divide one machine; how data occupies disk and grows; how the write-ahead log and the checkpoint make committed work survive a crash; why the concurrency design obliges a permanent cleaning duty; what indexes charge the platform that carries them; how the planner's picture of the data is kept honest; and where the platform's own evidence lives.
Module 2 puts that understanding under obligation. Backups judged by the recovery they can actually perform; point-in-time recovery built and proven in rehearsal; replication and availability decided on stated objectives; upgrades without surprises; security held at the platform layer; extensions governed and hosting chosen honestly; incidents triaged from evidence; capacity and change planned as one discipline; and the whole arrangement kept alive for years through routine, record, and succession.
And it holds its boundary throughout. This course teaches the platform, not the language: it teaches no query writing, and statements appear only as the load the platform carries — the traffic whose memory, locking, logging, and storage consequences the operator must bear. It works at workflow and judgment level: what to decide, what to check, what the evidence means, and when to act.
What you will learn
- Describe what the PostgreSQL server is doing beneath the statements it serves — its processes, memory, and files — and name which part of the platform owns any symptom you meet
- Treat configuration as a decision record: set parameters deliberately, know which changes need a restart, and keep the record of what was changed and why
- Budget memory and connections together, with arithmetic that accounts for per-operation memory and proves the machine can carry the load you allow
- Forecast storage honestly — live data, free space, index weight, and growth — and act on the forecast while acting is still cheap
- Explain how the write-ahead log and checkpoints deliver durability, size their cost, and recognise when the rhythm between them is wrong
- Run vacuum as a standing obligation of the concurrency design, read bloat from evidence, and intervene at the right weight for the problem
- Judge backup and recovery as one discipline: choose the copy that fits the obligation, price retention in real volumes, and prove restores before they are needed
- Decide replication, availability, upgrade, and hosting questions on stated objectives — recovery point, recovery time, and who carries which risk — rather than on fashion or fear
- Operate the platform for years: monitor its own evidence, plan capacity and change, hold its security posture, and keep the written ledger that makes the next operator's job possible
Everything in the course
- All 18 concepts of PostgreSQL in Depth, in 2 modules
- A starting-point check first — the Coach finds where you actually stand before teaching
- Learn, Practice, Prove for every concept — no passive video watching
- A test-out on every concept: prove you know it and move on
- The Voice Coach: talk with the Coach out loud — it speaks, listens, and replies
- A personal Learner Record of your work across the course
- Two capstone exercises: The Platform Baseline and Health Plan and The Recovery, Replication, and Upgrade Plan
- A printable session summary whenever you pause
- The Lighthouse Coach completion certificate (Signature Series)
- Your progress is saved as you go — stop anytime, resume where you left off
Built for the people the database quietly landed on
Developers and engineers who have become accidental database operators — the application is yours, so the cluster became yours — and who run it on folklore because no one ever taught the platform itself; and systems and platform engineers responsible for PostgreSQL alongside other infrastructure, who need its specific behaviour — vacuum, WAL, checkpoints — rather than generic database habits imported from a different engine.
The course assumes you can connect to a PostgreSQL server, recognise a statement when you see one, and find your way around a server's files and logs at a working level. It assumes no prior administration experience, and it teaches no query writing: statements appear only as the load the platform carries.
Prefer to learn live and in person? The same material anchors Cognosco's one-day programs — browse the in-person catalog.
Start with The Platform, Not the Language
$195 — introductory price. One payment. No subscription, no password to manage.
Here is exactly what happens when you enroll:
- Pay securely with Stripe — you are taken straight into the course
- Create your learner profile and begin the Module 1 starting-point check
- Save the access key you are given — it restores your enrollment on any device
- Learn at your pace; your progress is stored in your browser on your device
For the full voice experience, use Chrome and allow the microphone when asked. Typing your answers works everywhere, all the time. Questions before you enroll? Email hello@cognoscolearning.com.
Before you enroll
What is a Socratic coaching session?
A conversation, not a video. Your coach asks a question; you answer — out loud by voice, or by typing — and the coach responds to what you said: naming the misconception it hears, affirming what you got right, and asking the next question. You advance only when you have mastered each concept, so a finished course means the learning held.
How long does it take — and how long do I have?
About 30 minutes per concept. Learn in sittings of any length; your progress is saved as you go. You have a full year from purchase to finish, and you can revisit and retake within that year.
What does the certificate verify?
That you completed every concept and both capstones of this course. Anyone can confirm a Cognosco certificate online — enter its certificate ID on our verification page.
What if it isn't for me — what are the refunds?
If you have not started, cancel for a full refund within seven days of purchase. Once you have started, there is no cash refund — stop before finishing and we credit the full amount you paid toward any other course in the library (credit valid one year from your original purchase). Once you complete the course, no refund or credit applies.
Independently verified before publication — structure, claims, and sources checked; tested end to end as a learner takes it.
More Signature Courses are coming
PostgreSQL in Depth is Signature Course No. 570. Leave your email and we'll send you news of future Signature Courses and Lighthouse updates as they are announced — nothing else.