Free 30-day beta access · no payment · progress saved
The business problem
Several reports calculate the same monthly metric differently.
What you will be able to do
Create a view, explain its limits and refresh a PostgreSQL materialized view.
Create a view
Choose a view or CTE
Understand materialization
Plan a refresh
Scope of this micro-course
This micro-course targets one focused skill. It does not replace a complete path or server administration training.
Prerequisites
SELECT, JOIN and aggregations
Project and practice
7 verified exercises are available. Validation is based on the programme exercises.
Focused path
Your programme, in order.
Content remains centralised: completing an activity here also updates the path that contains it.
Micro-lessons
01
A CTE gives a name to a reasoning step
The WITH clause allows you to define several intermediate results. A first CTE can aggregate monthly sales, a second calculate the margin, then the final query classifies the periods.
The same KPI copied into five reports ends up diverging. A view centralizes the logic; a materialized view can speed up expensive computation but introduces a freshness lag.
Use a view to encapsulate a query without storing its result. Use a materialized view when the cost justifies a stored result and a refresh policy is acceptable.
Create a reusable billing view 2 training scenario
Centralize a definition of active data without copying the query. You must produce the result, check it on the source data and explain what it allows you to decide in this billing system.
Create a reusable logistics view 3 training scenario
Centralize a definition of active data without copying the query. You must produce the result, check it on the source data and explain what it allows you to decide in this national expeditions.
Centralize a definition of active data without copying the query. You must produce the result, control it on the source data and explain what it allows you to decide in this human resources management.
Centralize a definition of active data without copying the query. You must produce the result, check it on the source data and explain what it allows you to decide in this audit log.