📚 Course

PostgreSQL — Query Lanjutan dan Performa

VidInsights Curriculum Team · Updated 24 Jul 2026

Kuasai Postgres: indexing, query planning, JSONB, window functions, dan tuning untuk skala.

Prerequisites: SQL basics

📖 3 lessons 🎯 Intermediate

Advanced Queries

Apply SQL Window Functions | Clearly Explained | PARTITION BY, ORDER BY, ROW_NUMBER, RANK, DENSE_RANK 12m

Recommended

PostgreSQL: Up and Running, 3rd Ed Check price on Amazon AU →

Indexing & Performance

Analyze Secret To Optimizing SQL Queries - Understand The SQL Execution Order 12m

JSONB & Modern Features

Apply JSON vs JSONB in PostgreSQL 12m

🧭 You might also like

AI Agents — ReAct & AutoGPT 3 lessons AI Cost Optimization 3 lessons AI Observability — LangSmith & Arize 3 lessons AI Red Teaming & Prompt Security 3 lessons AI Safety & Alignment 3 lessons Android Jetpack Compose Mastery 3 lessons Apache Airflow Deep Dive 3 lessons Apache Cassandra — Wide-Column Store 3 lessons Apache Druid — Real-Time OLAP 3 lessons Apache Flink — Real-Time Stream Processing 3 lessons