← All free certificatesFree learning path Final step
PostgreSQL
10 short modules. Each one: a simple lesson, two quick games and a 8-question quiz for its own free certificate. Finish them all, then take the full PostgreSQL certificate.
0 of 10 module certificates
- Introduction to PostgreSQLPostgreSQL is a powerful open-source relational database.0/4
- Creating tables and data typesDesign tables with the right data types and constraints.0/4
- Querying dataSelect, filter, sort and paginate with SQL.0/4
- Joins and relationshipsCombine related tables with foreign keys and joins.0/4
- Aggregation and groupingSummarise data with GROUP BY and aggregate functions.0/4
- Indexes and performanceMake queries fast and read query plans.0/4
- Transactions and concurrencyKeep data correct when many users act at once.0/4
- Advanced features: JSONB, views, functionsUse Postgres's powerful built-in features.0/4
- Security and rolesControl access with roles, privileges and row-level security.0/4
- Backup, replication and operationsKeep Postgres reliable in production.0/4
🏆 Full PostgreSQL certificate
20 questions from basic to advanced, 60% to pass. Best taken after the modules.