Short, applied courses with a verifiable certificate. Search for a topic, or narrow by category, level, duration and price.
Learn to diagnose and speed up slow PostgreSQL queries. You will understand how B-tree and other index types work, read EXPLAIN and EXPLAIN ANALYZE plans to find the real bottleneck, and design composite, partial and covering indexes while keeping tables healthy with VACUUM and ANALYZE.
Learn to design well-structured PostgreSQL tables: pick the right data type for every column, model relationships correctly, and enforce data quality with keys and constraints. You will finish able to translate a real-world requirement into a clean, normalised schema that keeps bad data out.
Turn raw rows into the summaries a report needs — counts, totals, averages and per-category breakdowns — using PostgreSQL's aggregate functions, GROUP BY and HAVING. You will finish able to summarise data for reporting, filter groups correctly, count distinct values and produce subtotals with ROLLUP.
