One lesson
An individual lesson
This track has no lesson ready to buy yet. Each lesson becomes available only after it is built and reviewed.
$5.00Not available yet
All course tracks
Databases and SQL · 30 lessons · up to 10 minutes each
PostgreSQL
A planned PostgreSQL path through SQL, JSONB, plans, roles, and safe recovery.
Coming Soon
One-time purchase · USD
Choose what to unlock
Access is attached to your account after payment is verified. No subscription.
Full category
PostgreSQL
Permanent access to the lessons published in this track when you buy. Future lessons are not included. 0 of 30 lessons are published; 0 are in owner review and 30 are Coming Soon.
$29.0030 lessons still in progress
Beginner
Lessons 1–10
01 PostgreSQL: Sketch psql and connection options
Topic: psql and connection options
Draw a small map of psql and connection options in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Beginner4 minComing Soon02 PostgreSQL: Name the parts of schemas and search_path
Topic: schemas and search_path
Label the main pieces in schemas and search_path in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Beginner5 minComing Soon03 PostgreSQL: Trace an example of types and constraints
Topic: types and constraints
Follow one input through types and constraints in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Beginner6 minComing Soon04 PostgreSQL: Compare choices for joins and CTEs
Topic: joins and CTEs
Write down one practical difference between joins and CTEs in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Beginner7 minComing Soon05 PostgreSQL: Find the boundary in JSONB operators
Topic: JSONB operators
Mark where JSONB operators in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Beginner8 minComing Soon06 PostgreSQL: Inspect an example of indexes and EXPLAIN
Topic: indexes and EXPLAIN
Annotate a minimal example of indexes and EXPLAIN in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Beginner9 minComing Soon07 PostgreSQL: Connect transactions and isolation to a neighboring concept
Topic: transactions and isolation
Show how transactions and isolation in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Beginner10 minComing Soon08 PostgreSQL: Spot a failure mode in roles and privileges
Topic: roles and privileges
Describe one likely failure for roles and privileges in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Beginner3 minComing Soon09 PostgreSQL: Read an official example of backup and restore checks
Topic: backup and restore checks
Summarize an official example of backup and restore checks in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Beginner5 minComing Soon10 PostgreSQL: Choose a use case for PostgreSQL 18 release notes
Topic: PostgreSQL 18 release notes
Match one small use case to PostgreSQL 18 release notes in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Beginner6 minComing Soon
Intermediate
Lessons 11–20
11 PostgreSQL: Build an example with psql and connection options
Topic: psql and connection options
Create a small working example that uses psql and connection options in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Intermediate4 minComing Soon12 PostgreSQL: Compose schemas and search_path with another component
Topic: schemas and search_path
Combine schemas and search_path in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Intermediate5 minComing Soon13 PostgreSQL: Configure types and constraints for a small case
Topic: types and constraints
Set up types and constraints in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Intermediate6 minComing Soon14 PostgreSQL: Validate inputs around joins and CTEs
Topic: joins and CTEs
Add a check around joins and CTEs in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Intermediate7 minComing Soon15 PostgreSQL: Use JSONB operators in a short workflow
Topic: JSONB operators
Add JSONB operators in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Intermediate8 minComing Soon16 PostgreSQL: Refactor indexes and EXPLAIN into a reusable unit
Topic: indexes and EXPLAIN
Extract indexes and EXPLAIN in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Intermediate9 minComing Soon17 PostgreSQL: Exercise transactions and isolation with sample data
Topic: transactions and isolation
Run sample data through transactions and isolation in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Intermediate10 minComing Soon18 PostgreSQL: Observe roles and privileges outputs
Topic: roles and privileges
Capture the result of roles and privileges in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Intermediate3 minComing Soon19 PostgreSQL: Recover from a backup and restore checks failure
Topic: backup and restore checks
Handle one expected failure from backup and restore checks in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Intermediate5 minComing Soon20 PostgreSQL: Document PostgreSQL 18 release notes behavior
Topic: PostgreSQL 18 release notes
Write a short usage note for PostgreSQL 18 release notes in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Intermediate6 minComing Soon
Advanced
Lessons 21–30
21 PostgreSQL: Test a boundary around psql and connection options
Topic: psql and connection options
Add an edge-case test for psql and connection options in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Advanced4 minComing Soon22 PostgreSQL: Harden schemas and search_path
Topic: schemas and search_path
Add the relevant access, safety, or validation control to schemas and search_path in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Advanced5 minComing Soon23 PostgreSQL: Measure types and constraints
Topic: types and constraints
Record a small baseline for types and constraints in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Advanced6 minComing Soon24 PostgreSQL: Reduce cost in joins and CTEs
Topic: joins and CTEs
Change one measurable cost in joins and CTEs in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Advanced7 minComing Soon25 PostgreSQL: Diagnose a JSONB operators failure
Topic: JSONB operators
Use an observable signal to explain a failure in JSONB operators in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Advanced8 minComing Soon26 PostgreSQL: Make indexes and EXPLAIN repeatable
Topic: indexes and EXPLAIN
Show that rerunning indexes and EXPLAIN in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Advanced9 minComing Soon27 PostgreSQL: Review trade-offs in transactions and isolation
Topic: transactions and isolation
Compare two documented approaches to transactions and isolation in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Advanced10 minComing Soon28 PostgreSQL: Improve roles and privileges maintainability
Topic: roles and privileges
Refine roles and privileges in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Advanced3 minComing Soon29 PostgreSQL: Verify backup and restore checks end to end
Topic: backup and restore checks
Check that a complete small flow using backup and restore checks in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Advanced5 minComing Soon30 PostgreSQL: Audit PostgreSQL 18 release notes against its source docs
Topic: PostgreSQL 18 release notes
Check the implementation of PostgreSQL 18 release notes in the context of PostgreSQL 18 queries, types, indexing, and administration basics; save a short example or check that demonstrates the result.
Advanced6 minComing Soon
Reference documentation
References support the selected track topics while its lesson content is built and reviewed progressively.
This track is a catalog outline only. Each lesson remains unavailable until it is built and personally reviewed.