Skip to main content
Level 1 · Beginner Databases

PostgreSQL Fundamentals PostgreSQL Fundamentals

Verify your foundational PostgreSQL skills across core SQL queries, joins, data types, schema changes, data modification, functions and aggregates, indexing basics, transactions, views, roles and permissions, basic administration, and common PostgreSQL-specific features such as JSONB, arrays, extensions, CTEs, and partitioning.

Skills Tested
  • SELECT Queries & Result Shaping
  • JOINs & Table Relationships
  • Functions, Aggregates & Window Function Basics
  • PostgreSQL-Specific Features
  • DDL & Schema Changes
  • DML & Data Modification
  • Data Types
  • Indexes & Query Performance Basics
  • Transactions & Isolation Basics
  • Roles & Permissions
  • Views & Materialized Views
  • Basic Administration & Backup Concepts
Assessment Details
20
Questions
78%
To Pass
30 min
Time Limit
Pass Rate

  • Questions are drawn randomly from the question pool each attempt
  • Answers cannot be reviewed after submission
  • Escalating cooldown between attempts: 8h, 24h, 72h, then 1 week
  • Certificates include a shareable verification token
  • Open Badges 2.0 compliant. Add to LinkedIn and digital wallets