Short, applied courses with a verifiable certificate. Search for a topic, or narrow by category, level, duration and price.
Learn to retrieve exactly the data you need from a PostgreSQL database using SELECT, WHERE, ORDER BY and friends. You will filter rows precisely, handle NULLs safely, match text patterns, and shape result sets so a query returns the right columns in the right order.
Learn to change data safely in PostgreSQL — adding rows with INSERT, correcting them with UPDATE, removing them with DELETE and TRUNCATE, and merging with UPSERT. You will wrap risky changes in transactions with BEGIN, COMMIT, ROLLBACK and savepoints so every modification is deliberate and reversible.
Learn to combine data across tables in PostgreSQL with confidence — INNER, LEFT, RIGHT and FULL joins, self and cross joins, and the relationships behind them. You will model one-to-many and many-to-many data, write correct multi-table queries, and avoid the accidental Cartesian products that silently corrupt results.
Get PostgreSQL installed on any operating system and learn to connect with the psql client, create your own databases and users, and navigate the object hierarchy with confidence. You walk away able to install, connect to and move around a real PostgreSQL database — the foundation every later skill builds on.
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.
