Lesson 4 of 8

Reuse logic with views and materialized views

Choose between always fresh result and pre-calculated result.

34 minPostgreSQL Pro

By the end of this lesson

  • Create a view
  • Understanding materialization
  • Schedule a refresh

SQL Essentials

Unlock this lesson and continue the path.

Reuse logic with views and materialized views is part of the complete programme: 38 lessons, 62 verifiable exercises and 8 published guided projects.

  • Complete content with explained examples
  • SQL simulator and expected result
  • Detailed answer, common mistakes and challenge
View SQL EssentialsI already have access
Six-month access, one-time payment and no automatic renewal.