Learn PostgreSQL from Community Experts
Beginner
- Build strong SQL and relational database foundations
- Learn schema design, constraints, and data modeling
- Get hands-on with PostgreSQL tools and workflows
Intermediate
- Master performance, indexing, and query optimization
- Work with application integration, security, and APIs
- Learn backups, monitoring, and real-world operations
Advanced
- Design scalable systems with replication, HA, and PITR
- Deep dive into internals, extensions, and architecture
- Explore AI workloads, distributed systems, and research
Meetup Talks
-
Speaker: Jay Miller Staff Product Advocate @ Aiven
Abstract: An app developer’s journey from avoiding the data layer to confidently working with PostgreSQL, using a “vibe-coded” application as a practical learning path. This talk explores how to make Postgres more approachable and less intimidating in the age of AI-driven development.
-
Speaker: Hettie Dombrovskaya Database Architect at DRW
HoldingsAbstract: Even long-running analytical queries can and should be optimized—ignoring them early leads to severe performance degradation as data scales. This session focuses on building efficient reports proactively to prevent future bottlenecks and ensure consistent performance.
Slides: Long-Queries-and-the-Art-of-Full-Scan.pptx
-
Speaker: Doğaç Eldenk Master’s student at Northwestern University (Ex Software Engineer Carbon Health)
Abstract: Learn how to efficiently reset PostgreSQL databases between integration tests without slowing down your workflow. This talk introduces a scalable, language-agnostic approach using PL/pgSQL to ensure fast, consistent, and reliable test environments.
Slides: https://pgday.dogac.dev/1