elizabeth-christensen

elizabeth-christensen / postgres-full-day-training

Public

Comprehensive PostgreSQL training with hand's on exercises.

10
6
100% credibility
Found Mar 07, 2026 at 10 stars -- GitGems finds repos before they trend. Get early access to the next one.
Sign Up Free
AI Analysis
PLpgSQL
AI Summary

Comprehensive open-source training materials for a full-day PostgreSQL workshop, covering beginner fundamentals to advanced query tuning with slides, SQL examples, and a sample database.

How It Works

1
🔍 Discover the training

You find this free, open-source full-day workshop to learn PostgreSQL databases from complete beginner to expert.

2
💻 Get your computer ready

Download and install the simple free tool needed to run practice databases on your Mac, Windows, or Linux machine.

3
🚀 Launch your practice database

Follow the quick guide to start a sample movie database right on your computer, ready for hands-on learning.

4
📚 Begin the lessons

Open the easy-to-read slides for Hour 1 and start exploring basics like creating tables and simple questions to data.

5
Choose your learning path
👤
Self-study

Read slides hour by hour, copy example questions into your database tool, and practice each concept.

👥
Teach a group

Load the slides into a presentation app, run live demos from your database, and guide participants through exercises.

6
⚡ Progress through advanced topics

Move from basic questions and joins, to managing databases, fixing issues, boosting speed, and fine-tuning queries.

🎉 Master PostgreSQL!

You've completed the full workshop and now confidently build, troubleshoot, and optimize real-world databases.

Sign up to see the full architecture

5 more

Sign Up Free

Star Growth

See how this repo grew from 10 to 10 stars Sign Up Free
Repurpose This Repo

Repurpose is a Pro feature

Generate ready-to-use prompts for X threads, LinkedIn posts, blog posts, YouTube scripts, and more -- with full repo context baked in.

Unlock Repurpose
AI-Generated Review

What is postgres-full-day-training?

This repo delivers a comprehensive full-day PostgreSQL training curriculum, packing 6 hours of hands-on exercises from absolute beginner setup to query tuning and production DBA skills. Developers spin up a Dockerized Postgres instance (with PostGIS, pgvector, and hypopg extensions) using docker compose up -d, load a realistic movie database via psql commands, then work through PLpgSQL SQL scripts tied to Markdown slides. It solves the gap between scattered Postgres tutorials and structured, self-paced workshops that mimic real production workflows.

Why is it gaining traction?

Docker eliminates setup headaches, letting anyone jump into exercises instantly without installing Postgres locally. The hour-by-hour progression with verifiable SQL outputs (like SELECT COUNT(*) FROM bluebox.film returning 7836) builds confidence fast, unlike dry docs or incomplete samples. Real-world topics like logical replication, pgBouncer pooling, and EXPLAIN ANALYZE stand out for bridging theory to troubleshooting.

Who should use this?

App developers new to Postgres who need quick SQL fluency for CRUD, JSONB, and window functions. DBAs switching from MySQL wanting replication, VACUUM tuning, and lock debugging. DevOps engineers handling Postgres infra, practicing config tweaks and monitoring via pg_stat_activity.

Verdict

Grab it for self-study or team training—solid docs and Docker make it instantly usable despite 10 stars and 1.0% credibility score signaling early maturity. Run the quick start today; lacks tests but exercises cover the gaps constructively.

(198 words)

Sign up to read the full AI review Sign Up Free

Similar repos coming soon.