Course Objective
Write real PostgreSQL — queries, joins, indexes, transactions, and schema design patterns used in production Supabase and Next.js projects.
0% complete1375 XP total
1
PostgreSQL Fundamentals
Write all four DML statements with WHERE, ORDER BY, and LIMIT clauses.
10m
Basic+1502
Joins & Relationships
Write INNER JOIN and LEFT JOIN queries to combine data from related tables.
11m
Basic+1503
Aggregates & Window Functions
Use COUNT, SUM, AVG with GROUP BY and apply ROW_NUMBER with window functions.
11m
Basic+1504
Indexes & Query Performance
Create appropriate indexes and use EXPLAIN ANALYZE to identify slow queries.
11m
Masters+1755
Transactions & Constraints
Use transactions for atomic operations and define constraints to enforce data rules.
10m
Masters+1756
CTEs & Advanced Queries
Use Common Table Expressions (CTEs) and JSON operators for complex data operations.
11m
Masters+1757
Schema Design Patterns
Apply normalization and design a multi-entity schema with proper relationships.
11m
PhD+2008
Functions, Triggers & Security
Write PL/pgSQL functions and triggers to automate data integrity rules.
10m
PhD+200