6 courses available
Master PostgreSQL replication strategies for building resilient database systems. Learn physical streaming replication, logical replication with publications and subscriptions, standby management, and failover procedures for production environments.
Master JSON and JSONB data handling in PostgreSQL. Learn to store, query, and manipulate document data efficiently, use JSON path expressions, create GIN indexes for fast searches, and integrate relational and document paradigms.
Master relational database concepts with PostgreSQL 18. From your first query to complex joins and aggregations, build a solid foundation in SQL and database design.
Master query optimization, indexing strategies, and performance tuning for production PostgreSQL databases. Learn to analyze execution plans, design efficient indexes, and maintain high-performance systems.
Master procedural programming inside PostgreSQL. Build functions, stored procedures, triggers, and robust error handling to implement business logic directly in your database.
Secure your PostgreSQL databases with authentication, authorization, and encryption. Master roles, privileges, row-level security, and compliance best practices.
