Guarantee consistency
Use types, keys and constraints to prevent invalid business states.
Available learning pathAdvanced
PostgreSQL · Transactions · Performance
PostgreSQL training: advanced practical course
Deepen your PostgreSQL skills by practising database structure, changes, transactions, optimisation and security in an isolated laboratory.
Prerequisites : Master SQL Foundations and be able to read a multi-step analytical query.
8structured lessons
8canonical experiences
2progressive modules
5 h 11Estimated duration
Target skills
Skills covered by this PostgreSQL course
Secure changes
Write INSERT, UPDATE and DELETE operations inside controlled, reversible transactions.
Optimise queries
Choose indexes and read the useful parts of a plan with EXPLAIN.
Automate thoughtfully
Use functions, triggers and permissions while knowing when to avoid hidden logic.
Evidence of progress
A rich learning path is not measured by page count alone.
You learn a method, reuse it on different data, then demonstrate independence in an assessment and a business case.
Understand
Understand the invariants of a PostgreSQL application database.
8 structured lessonsPractise
Write, roll back, automate, secure and measure in an isolated lab.
8 canonical experiences · Progressive hints, error diagnosis and explained answersDemonstrate
Choose constraints, transactions, indexes, functions, triggers and permissions with justification.
Queries executed and results compared automatically · Final assessment and business projectYour progress
Start the path
Detailed syllabus
8 structured lessons
Build, modify, automate, secure and optimise a PostgreSQL database in an isolated laboratory.
Detailed syllabus 1Structure and modify without losing consistency4 structured lessons+
- 01Impose integrity with constraintsChoose between type, NOT NULL, UNIQUE, CHECK, PRIMARY KEY and FOREIGN KEY. · Related practice: Guarantee integrity with real constraints
- 02Modify data with a secure DMLMaster INSERT, UPDATE, DELETE and UPSERT with a controlled perimeter. · Related practice: Edit data without losing control
- 03Protect an operation with transactionsUse COMMIT, ROLLBACK and SAVEPOINT, and understand concurrency. · Related practice: Secure an operation with transactions
- 04Reuse logic with views and materialized viewsChoose between always fresh result and pre-calculated result. · Related practice: Create and maintain reliable views
Detailed syllabus 2Automate, secure and optimise PostgreSQL4 structured lessons+
- 05Accelerate with indexes and read EXPLAINLink an index to a real query and measure its cost. · Related practice: Choose an index and read EXPLAIN
- 06Encapsulate logic with functions and proceduresChoose a reusable object without hiding logic unnecessarily. · Related practice: Write testable PostgreSQL functions
- 07Automate an audit with triggersUse OLD, NEW, BEFORE, and AFTER without creating invisible logic. · Related practice: Automate an audit with triggers
- 08Control access with roles and permissionsEnforce least privilege with GRANT, REVOKE, and group roles. · Related practice: Test roles and permissions positively and negatively
End-of-path practice
Put the skills from this path into practice.
Revisit an exercise at this level, explain the result and check an edge case. This practice is included in your path; it is not an independent certification.
Guarantee integrity with real constraints