Programming
Intermediate Level
Hands-on Labs
In-browser IDE
PostgreSQL Advanced Database Engineering: Relational Architecture, JSONB & Indexing
Master Enterprise Relational Architecture with PostgreSQL\nPostgreSQL is the world's most advanced open-source object-relational database system, driving enterprise workloads at Apple, Reddit, and Instagram. Directly aligned with the complete PEA Africa Postgr...
What You'll Learn in This Course
Design normalized, high-integrity relational schemas using PostgreSQL native data types
Execute complex multi-table queries utilizing INNER, LEFT, RIGHT, and FULL OUTER JOINs
Command aggregate functions and analytical grouping with GROUP BY and HAVING clauses
Ensure ACID compliance and race-condition immunity using Transactions and ON CONFLICT Upserts
Store and index semi-structured NoSQL document data using native JSONB and GIN indexes
Analyze and optimize slow queries using EXPLAIN ANALYZE and strategic B-Tree indexing
Manage database users, roles, permissions, and Row-Level Security (RLS) in production
Course Syllabus & Curriculum
8 Modules · 48 Lessons
Week 1
Module 1: PostgreSQL Architecture, Installation & psql Shell
Introduction to PostgreSQL: Enterprise Relational Architecture
FREE
20 min
Installation & Server Setup on Linux, Windows & Cloud
20 min
Getting Started: Connecting with psql CLI & Authentication
20 min
pgAdmin 4 GUI Tool & Database Management
20 min
Creating & Dropping Databases in PostgreSQL
20 min
PostgreSQL SQL Syntax Conventions & Execution Flow
20 min
Week 2
Module 2: Data Definition Language (DDL) & Schema Design
Week 3
Module 3: Data Manipulation Language (DML) & Basic Queries
Week 4
Module 4: Filtering Operators, Pattern Matching & Range Queries
Week 5
Module 5: Multi-Table Relationships & Relational Joins
Week 6
Module 6: Aggregations, Grouping & Analytical Summaries