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
What this micro-course does not promise yet
The content, exercises and laboratory are not accessible yet. This page describes a production goal, not a skill you can already practise on SQL.tn.
Prerequisites
- SELECT, JOIN and aggregations
Project and practice
The planned structure contains 7 exercises and a mini-project. They will remain unavailable until they have been run and validated.