Mastering Postgres - A video course on PostgreSQL

What you'll learn

• Use advanced PostgreSQL data types such as JSON, arrays, ranges, generated columns, and composite types.
• Design and reason about indexes including partial, composite, covering, functional, and hash indexes.
• Read query plans and understand PostgreSQL performance behavior.
• Apply advanced SQL features such as window functions, recursive CTEs, upserts, and RETURNING.
• Use full-text search, pgvector, and PostgreSQL extensions in real applications.

Requirements

• Basic SQL knowledge.
• Some experience using databases in application development is helpful.

Who is this course for

• Developers who want deeper PostgreSQL skills.
• Backend engineers who work with application databases.
• Database-focused developers who want to understand PostgreSQL features and performance.